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

From: Babette Turner-Underwood <babette_at_rogers.com>
Date: Thu, 22 May 2003 20:12:00 -0800
Message-ID: <F001.005A106F.20030522201200@fatcity.com>

Also, people tend to use the cold backup of databases when cloning databases. It is useful to have the online redologs, so Oracle doesn't think they are missing have have problems opening the cloned database. Was always easier to clone when I had then than not

Babette

-----Original Message-----

Sent: Thursday, May 22, 2003 4:43 PM
To: Multiple recipients of list ORACLE-L

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

--

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Babette Turner-Underwood
INET: babette_at_rogers.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