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!

On Jun 25, 9:09*pm, The Magnet <a... (AT) unsu (DOT) com> wrote:
Yes.


David Fitzjarrell

On Jun 26, 10:37*am, ddf <orat... (AT) msn (DOT) com> wrote:
Well, that may be confusing. The "Yes" is that the recovery will stop
at 2 PM.


David Fitzjarrell

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

Yes you can,
Jim