RE: Confusion why online redo logs should never be backed up.

In our (very old) hot backup scripts, log files get backed up.... no time to clean those scripts up.....

We just don't restore them during any recovery operations.

But again, I back them up just prior to the start of any recovery operation when taking a cold backup. I had to do this (recovery) just twice in the last 5 years.. !!

• Kirti

-----Original Message-----
Sent: Thursday, May 22, 2003 2:48 PM
To: Multiple recipients of list ORACLE-L

The online redo log group is being written to at the time of the backup. If you attempt to backup these files, you run the risk of missing redo that is written during the backup process. Oracle handles backing up online data files internally, but the mechanism does not exist for redo logs.

-- 
Daniel W. Fink
http://www.optimaldba.com


Rick_Cale_at_teamhealth.com wrote:



>Hi All,

>

>In Oracle8i Backup & Recovery Handbook pg 13 it states "Finally, online

>redo log files should never be backed up....So, it is good practice not to

>back up online log files for ANY kind of backup.

>

>Can someone clearly explain why this is recommended?

>

>Thanks

>Rick

>  

>



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).