Re: recovery

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 24 Feb 2003 00:08:54 +1000
Message-ID: <mq36a.54198$jM5.136354@newsfeeds.bigpond.com>

"Oradba Linux" <oradba_linux_at_attbi.com> wrote in message news:pan.2003.02.21.00.06.27.256761_at_attbi.com...
> I have a hot backup of the database from last night . I want to do
> a point in time recovery of a tablespace say from 5 hours after
> hot backup was completed . How do i now find out all the archive
> logs that are required to recover the database to that point in
> time . backup started around 2am and finished at 3am . Want to
> recover the tablespace upto 8am this morning . Can i find out all
> sequence numbers needed from the alert log
>
>

Check out v$log_history .....

Cheers

Richard Received on Sun Feb 23 2003 - 08:08:54 CST