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: Daniel W. Fink
INET: optimaldba_at_yahoo.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).
Received on Thu May 22 2003 - 14:48:12 CDT
