Re: RMAN Recovery

From: jim <jimb77_at_hotmail.com>
Date: 28 Jun 2009 14:23:32 GMT
Message-ID: <4a477ce4$0$19273$e4fe514c_at_dreader28.news.xs4all.nl>



On Thu, 25 Jun 2009 19:09:51 -0700, The Magnet wrote:

> We had a developer make some changes to production. Idiot.
>
> Anyhow, we have a complete backfrom from about 9:00am. There were some
> changes arounf 12:00 which are fine. The developer made changes at 3:30
> and messed everything up.
>
> We are runnnig RMAN. So, I did some looking around and just want to
> make sure we have the right commands so we can restore the database
> until about 3:00pm. Would this do it? (Note we have set the time back
> on the server to perform some application specific recovery).
>
> RUN
> {
> SET UNTIL TIME 'Jun 15 2009 14:00:00'; RESTORE DATABASE;
> RECOVER DATABASE;
> }
>
> Will that perform the recovery and STOP at 2:00pm? Or will it restore
> and recover until the most recent change in the archive logs?
>
> Thanks!

Yes you can,
Jim Received on Sun Jun 28 2009 - 09:23:32 CDT

Original text of this message