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

> Can you think of a scenario where the backed up online redolog file will
> help you completely recover a database?

Sure I can, been there, done that.

Cold backup of a database that was shutdown with either shutdown abort, but more likely, a windoze platform where the database was shutdown by stopping the service, and the registry entries are not setup correctly for that.

Yes, I know the database should not be backed up in that state.

I've seen it happen anyway. For instance, when someone sends me 200 gig of tapes from another site, and the database is shutdown via MS Cluster Services, which are not properly shutting down the database.

The backed up online logs will be necessary.

I've run into this at other times as well.

I'm not saying you must always backup online logs. You certainly wouldn't do so during a hot backup.

There are times though that they are handy.

I've also read the Oracle docs on it, and don't agree.

Jared

Rajesh.Rao_at_jpmchase.com
Sent by: root_at_fatcity.com
 05/22/2003 12:42 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Confusion why online redo logs should never be backed up.

Can you think of a scenario where the backed up online redolog file will help you completely recover a database?

You dont back it up, coz u dont need it. And, as you ritely pointed out, there are pitfalls to backing it up.

Regards
Raj   

                    "Koivu, Lisa"   
                    <Lisa.Koivu_at_Fairfieldre       To:     Multiple 
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
                    sorts.com>                    cc:    
                    Sent by:                      Subject:     RE: 
Confusion why online redo logs should never be backed 
                    root_at_fatcity.com               up.    
  
  
                    05/22/2003 03:12 PM   
                    Please respond to   
                    ORACLE-L   
  
  

Hi Rick,

You want to rely on your os backup for backing up the online redo logs. The reason for this is, you don't want to overwrite your online redo logs with something not current (from your db backup, for example) when you are performing a recovery. To do so would cause an incomplete recovery.

It's confusing. I didn't believe it at first either.

And list, if I'm wrong, please set me straight.

Lisa Koivu
Oracle Database MONKEY
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459

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

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: Rajesh.Rao_at_jpmchase.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).