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.

March 03, 2007 18:06:44	#5
Chiranjeevi Manne	Member Since: Visitor Total Comments: N/A
RE: What are the advantag...
The main advantage of maintaining a database in Archivelog Mode is that it is possible to take the full backup of database while the database is up and running which in turn facilitates the Point In Time Recovery in case of database failure using the archived redologs and last known full backup