Backup and Recovery - What are the advantages of operating a database in ARCHIVELOG mode over operating

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

Go To First | Previous Question | Next Question

Backup and Recovery | Question 11 of 42

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

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

Online database backup is possible only in ARCHIVELOG mode.

Total Answers and Comments: 7

Last Update: September 11, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 13, 2005 15:21:39

sandeep vig

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.

Is this answer useful? Yes | No

January 30, 2006 05:19:00

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.

Is this answer useful? Yes | No

May 31, 2006 06:40:54

RE: What are the advantag...

If the database is in archieve log mode then performance is bit slower as compared to the no archieve log mode.

Is this answer useful? Yes | No

November 12, 2006 23:08:21

rush

RE: What are the advantag...

A database backup guarantees that you can recover all committed transactions in the event of an operating system or disk failure.

You can use a backup taken while the database is open and in normal system use if you keep an archived log.

You can keep a standby database current with its original database by continually applying the original s archived redo logs to standby

regards

rush

Is this answer useful? Yes | No

March 30, 2007 18:06:44

Chiranjeevi Manne

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

Is this answer useful? Yes | No

May 13, 2008 23:35:57

ora10g_dba

Member Since: May 2008 Contribution: 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.

Is this answer useful? Yes | No

September 09, 2009 11:14:29

oracleofdelphi

Member Since: September 2009 Contribution: 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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank