Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Confusion why online redo logs should never be backed up.

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

From: <Rajesh.Rao_at_jpmchase.com>
Date: Thu, 22 May 2003 11:42:20 -0800
Message-ID: <F001.005A07FC.20030522114220@fatcity.com>

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). Received on Thu May 22 2003 - 14:42:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US