| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Confusion why online redo logs should never be backed up.
Good point Jared and I agree with those points. My guess is that
Oracle put it there after the support see too many instances where
the current online redo log got over written during people's
recovery process.
Richard
-----Original Message-----
Sent: Thursday, May 22, 2003 3:48 PM
To: Multiple recipients of list ORACLE-L
This thread will likely go on for awhile.
Why not look it up in the archives at fatcity.com?
That said, the statement is patently incorrect.
Hot backups: no, you don't backup online logs
Cold backups: yes, it's a good idea.
I'll catch flames for that, but don't care. I've had to use the online logs restored from tape to recover a database on a few occasions. I was glad to have them. ( someone else was not shutting down the database properly )
Restoring the online logs from a cold backup also allows you to avoid 'open resetlogs'. If you open a database with resetlogs, you must back it up before anyone is allowed to use it.
Jared
Rick_Cale_at_teamhealth.com
Sent by: root_at_fatcity.com
05/22/2003 11:27 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Confusion why online redo logs should never be backed up.
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:
INET: Rick_Cale_at_teamhealth.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Ji
INET: Richard.Ji_at_ztango.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 - 15:42:58 CDT
 |
 |