OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Archivelog Mode

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Archivelog Mode [message #51683]

Thu, 06 June 2002 10:19

Nita
Messages: 34
Registered: March 2002

Member

I have heard many conflicting opinions on the pros and cons of running in archivelog mode.

Pros??

Cons??

Please advise your thoughts.

Thanks

Report message to a moderator

Re: Archivelog Mode [message #51688 is a reply to message #51683]

Thu, 06 June 2002 16:14

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

Pros
- no data lost

Cons
- having one more thing to backup
- more I/O to archive the redo logs
- another background process running (CPU & RAM)

For productions DB - 100% ARCHIVEDLOG MODE. No doubt.

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here

The latest Oracle DBA forums

Report message to a moderator

Re: Archivelog Mode [message #51691 is a reply to message #51683]

Thu, 06 June 2002 19:57

Vikas Gupta
Messages: 115
Registered: February 2002

Senior Member

In Archivelog Mode:

You can take hot backups.
No chance of loosing data.
Ideal for 24x7 shops.
Point In time Recovery Possible.
Archivelogs backup have to be done.

In NoArchiveLog Mode:

You have to take cold backups daily.
No hot backup possible..not ideal for 24x7 shop.
No Point In time Recovery.
Chance of Loosing Data in event of a crash
(But this can be prevented in certain cases)

Report message to a moderator