Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RMAN Recovery

0 views
Skip to first unread message

The Magnet

unread,
Jun 25, 2009, 10:09:51 PM6/25/09
to

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!

ddf

unread,
Jun 26, 2009, 11:37:54 AM6/26/09
to

Yes.


David Fitzjarrell

ddf

unread,
Jun 26, 2009, 11:39:23 AM6/26/09
to
> 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

jim

unread,
Jun 28, 2009, 10:23:32 AM6/28/09
to

Yes you can,
Jim

0 new messages