Re: RMAN Recovery

From: ddf <oratune_at_msn.com>
Date: Fri, 26 Jun 2009 08:37:54 -0700 (PDT)
Message-ID: <8d324260-07f8-4d9e-97e0-35a848b253b3_at_o36g2000vbi.googlegroups.com>

On Jun 25, 9:09 pm, The Magnet <a..._at_unsu.com> 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.

David Fitzjarrell Received on Fri Jun 26 2009 - 10:37:54 CDT