Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recovering offline redos
Thanks to all,
problem solved !
R.
"Mark D Powell" <mark.powell_at_eds.com> schrieb im Newsbeitrag
news:178d2795.0106050501.5fed348_at_posting.google.com...
> "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
>
> I suggest you look at the SQL manual under 'recover clause'
> Alter database automatic recover until time 'yyyy-mm-dd:hh:MI:SS';
>
> But before you try this I suggest you review the Backup and Recovery
> manual chapeter on point in time recovery. It is a pretty straight
> forward process. We usually do not use the automatic feature since we
> rarely have enough space to have all the archived redo logs available
> in the correct location. When it prompts us we use the time to
> uncompress and relocate logs as necessary then hit enter when we have
> a series of logs ready.
>
> -- Mark D Powell --
Received on Tue Jun 05 2001 - 11:23:29 CDT