Re: RMAN Recovery
From: ddf <oratune_at_msn.com>
Date: Fri, 26 Jun 2009 08:39:23 -0700 (PDT)
Message-ID: <88a3d187-679b-40ef-90dd-574e09ef4677_at_f32g2000vbf.googlegroups.com>
On Jun 26, 10:37 am, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Date: Fri, 26 Jun 2009 08:39:23 -0700 (PDT)
Message-ID: <88a3d187-679b-40ef-90dd-574e09ef4677_at_f32g2000vbf.googlegroups.com>
On Jun 26, 10:37 am, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Well, that may be confusing. The "Yes" is that the recovery will stop at 2 PM.
David Fitzjarrell Received on Fri Jun 26 2009 - 10:39:23 CDT