Re: help recovering archives when all files in sync

Fair enough, and my error. Apologies.

Actually, since it's only a script, you *could* put the relevant commands in there, and impress your friends, their tennis partners and the small dachshund named Colin, by recovering the whole lot with a single "@" command!

Regards
HJR "Syltrem" <syltrem_at_videotron.ca> wrote in message news:_SfJ5.3446$eE2.146164_at_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 Wed Oct 25 2000 - 03:33:14 CDT