Answer Detail: RE: What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

GeekInterview.com > Interview Questions > Oracle > Backup and Recovery

Print |

Question:

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Answer:

Complete database recovery from disk failure is possible only in ARCHIVELOG mode.

Online database backup is possible only in ARCHIVELOG mode.

September 09, 2009 11:14:29	#7
oracleofdelphi	Member Since: September 2009 Total Comments: 6
RE: What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
The one and only thing is that we can perform recovery where as in no archivelog mode we can only perform restore that is previous backup all transactions from then on is lost.