What about the ability to be able to do point in time recovery? What about the ability to be able to make a copy of a database without having to shut it down? What about the ability to recover specific datafiles without having to shutdown the entire database. What about the ability to recover specific blocks in your datafiles in 9i with the datafiles online? What about the ability to be able to do incremental backups with RMAN? What about the ability to create a standby database architecture? What about the ability to store archived redo logs so we can mine them later?
Lots of reasons/benefits for archivelog mode, not a great deal of cost in return (some disk space, minimal CPU requirements). RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -----Original Message----- Sent: Tuesday, March 19, 2002 2:39 PM To: Multiple recipients of list ORACLE-L NOARCHIVELO "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi, > > Pardon me if I am wrong, I thought the only reason for the database to be in > archive log mode is so that I can recover the database up to the time when > the database crushes. > You are right except for ONLY. Another reason is the desire to take hot backups (although indeed both reasons are usually linked). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
