Re: recovering offline redos

"Rolf Sapler" <bud_socks_at_gmx.net> wrote in message news:9fikg1$6g0$05$1_at_news.t-online.com...
> Hi Howard,
>
> i got online redos on tape younger than 29.01.
> Due to a different storage layout i had to create a new controlfile.
> Before that i`ve overwriten the online-redos with the above mentioned
 files.
> Right now the DB is in mount status. The v$logfile shows the correct
> online redos.
>
> I`ve got offline redos exactly to the point where i need to go to.
> Meanwhile i have succesfully recovered 2 offline redos by "recover
> database until cancel".
>
> Should i have used "...until time..." ?
>

Hi Rolf,

Until cancel is usually used when there is a missing redo log. It's rather a crude weapon to wield otherwise -Oracle says 'do you want to apply this log?', and you say 'cancel' -end of recovery session!

Until time is much more refined! It will allow parts of a redo log to be applied, and others to be ignored, and is usually used when all redo is present, but you don't want to play it in its entirety, because it contains something awful, like 'drop table customers'.

So, it would be up to you which to use in any given circumstance, but I saw that you had all redo until the 30th, but wanted to stop it at 6.30 the previous day -that sounded like a 'until time' to me.

Regards
HJR
> The SVRMGR always want to know the filename. How can i automatically run
> the recovery without confirming the messages ? What can the syntax be
 like
> ?
>
> Thanks in advance.
>
> R.
>
>
>
>
> "Howard J. Rogers" <howardjr_at_www.com> schrieb im Newsbeitrag
> news:3b1cc684$1_at_news.iprimus.com.au...
> > Yes it's possible, in theory.
> >
> > Unfortunately, if you simply restore everything from the backup, you
 will
> > have a beautifully consistent database at time January 27th, and
 recovery
> > will not be prompted for, nor possible.
> >
> > What you need is the control file and or datafiles from January 29th,
 then
> > restore ALL the datafiles from the backup of the 27th. Then it's a
 simple
> > 'recover database until <time string>' command.
> >
> > If ALL you have is a consistent backup at the 27th, I can't see how you
 can
> > provoke recovery, though.
> >
> > Regards
> > HJR
> > --
> > =============================!!=============================
> > The views expressed are my own only, and definitely NOT those of Oracle
> > Corporation
> > =============================!!=============================
> >
> >
> > "Rolf Sapler" <bud_socks_at_gmx.net> wrote in message
> > news:9fid7c$cb0$01$1_at_news.t-online.com...
> > > Hi there,
> > >
> > > i need to restore a db from a ArchServ NT-Backup.
> > >
> > > This backup was taken on 01/27.
> > >
> > > Furthermore i need to roll forward till 01/29. All necessary
 offline-redos
> > > up to
> > > 01/30 are available without interruption.
> > >
> > > How can i do a point in time recovery up to the desired time (01/29,
 06.00h)
> > > ?
> > > Is it possible at all ?
> > >
> > >
> > > Thanks for help
> > >
> > > Rolf
> > >
> > >
> > >
> >
> >
>
>
Received on Tue Jun 05 2001 - 16:26:07 CDT