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

Home -> Community -> Usenet -> c.d.o.server -> Re: help recovering archives when all files in sync

Re: help recovering archives when all files in sync

From: Syltrem <syltrem_at_videotron.ca>
Date: Tue, 24 Oct 2000 09:13:18 -0400
Message-ID: <_SfJ5.3446$eE2.146164@weber.videotron.net>

Oh! my mistake. What I meant is: I can use whatever is in there to recreate the files. I did not mean "use it as is" but merely "use the information therein".

Bye!
Syltrem

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:39f539be$1_at_news.iprimus.com.au...
>
> "Syltrem" <syltrem_at_videotron.ca> wrote in message
> news:3MYI5.1897$eE2.78464_at_weber.videotron.net...
> > Woops! What did I say! Command to create redo log files actually is in
 the
> > trace file script from backup controlfile to trace.
>
> No it's not. Read it again.
>
> >
> > Before someone slaps me, I do it myself!
> >
> > Syltrem
> >
>
> Well, I'll lend you a slap for not reading the script closely enough.
>
> There are statements in there which tell you what redo logs ought to exist
> (as well as what datafiles exist), but that's merely a question of setting
> the *pointers* to those files in the about-to-be-created control file.
> Nothing to do with re-creating those files at all.
>
> Unless you have a magic trace file that I've never seen before. The
 command
> is to 'backup controlfile to trace' not 'backup the controlfile and
> re-create anything I may happen to need while you're at it'.
>
> Regards
> HJR
>
>
>
> > "Syltrem" <syltrem_at_videotron.ca> wrote in message
> > news:eQXI5.1887$eE2.76496_at_weber.videotron.net...
> > > That's pretty much the answer I was expecting, but I needed to make
 sure
> > > (100% sure!) as I am preparing a disaster recovery plan and WILL be
 testing
> > > it sometime next year.
> > >
> > > I will change my backup script to create a CREATE_REDO_LOGS.SQL script
 and
> > > save it on tape, too.
> > >
> > > Thanks for all advices given.
> > >
> > > Syltrem
> > >
> > >
> >
> >
>
>
Received on Tue Oct 24 2000 - 08:13:18 CDT

Original text of this message

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