Answer Detail: RE: What are the advantag...

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.

October 10, 2005 15:21:39	#1
sandeep vig	Member Since: Visitor Total Comments: N/A
RE: What are the advantag...
although u can perform any type of recovery while the database in archive log mode and if u have to configure dataguard environment then the database should be in archivelog mode.