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.

May 05, 2008 23:35:57	#6
ora10g_dba	Member Since: May 2008 Total Comments: 1
RE: What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
In the Archivelog mode complet database recovery can be possilbe and in No Archivelog mode incomplet database recovery is possible.