Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recovery
Grab all of the archived redo log files +1 with a create time >= time
you started backup and <= the time to which you wish to recover. The +1
is to cover the log that was active at the point in time to which you
wish to recover.
-- AjA Oradba Linux wrote:Received on Fri Feb 21 2003 - 11:05:31 CST
> 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
>
>