recovery

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Fri, 21 Feb 2003 00:12:26 GMT
Message-ID: <pan.2003.02.21.00.06.27.256761@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 Received on Thu Feb 20 2003 - 18:12:26 CST