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.

January 01, 2006 05:19:00	#2
	Member Since: Visitor Total Comments: N/A
RE: What are the advantag...
database in archivelog mode chance to take hot backup and no data loss in recovery. you can use RMAN for backup and recovery .disadvantage is poor ferformance, and more chance to crash disc.