Richard,
I think we were talking two different scenarios... of course these are
two different things.
I wasn't thinking so much of online logs or not as opposed to just
taking a copy of where you are. We once ended up having to use Data
Unloader... and if we hadn't backed up the datafiles before we tried
recovering in other ways, we would have been dead in the water. That's
more what I was thinking.
Rachel
- Richard Foote <richard.foote_at_bigpond.com> 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
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Richard Foote
> INET: richard.foote_at_bigpond.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).
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 Mon May 26 2003 - 12:26:30 CDT
