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

my concept has always been backup ONLY 1 set, not all of them, so if you accidentally restore over the good copies, you can just copy the intact one back and all is well.

joe

Richard Foote wrote:

>>Hemant,
>>
>>you said:
>>
>>
>>
>>>The advice should be to backup online redo logs already on disk
>>>before beginning a restore. In fact, that is always a standing
>>>instruction in any Oracle Database recovery -- backup what you
>>>currently have on disk, no matter how badly "hosed" before you begin
>>>the recovery.
>>>
>>>
>>YAY!!!! That's a point everyone has been missing -- if you backup the
>>mess you have, including controlfiles, online logs, datafiles,
>>initialization files, you ALWAYS have a place to go back to if you mess
>>up a recovery.
>>
>>
>>
>Hi Rachel,
>
>Thanks, I needed some light relief today :)
>
>Backing up during a recovery as mentioned above is slightly different than
>the daily/weekly backup scenario.
>
>However, the reason why Oracle recommends backing up everything before a
>restore is to prevent the scenario when one accidentally overwrites the
>current online redo logs due to them being unnecessarily backed up in the
>first place!!
>
>It's not the point I've been missing but a point I've been making !!
>
>You've just gotta love the irony of it.
>
> Thanks for the smile.
>
> Cheers ;)
>
> Richard
>
>
>
>

-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.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).