Hello
It's been a while since I worked with Oracle so please help me out with this question I have :
Situation :
We take an Oracle full online backup by setting the database in 'hot backup' mode and then copy all relevant files (datafiles etc) using OS copy command.
Let's assume this complete backup procedure takes 1 hour to complete : starting at 2 AM and ending at 3 AM. At 3 AM we put the database back to normal mode.
The database runs in archive log mode off course.
Question :
Is it possible to restore this database and then perform a recovery to a point-in-time that falls within the backup window ? For example , do a restore and subsequent recovery to 2.30 AM and then open the database ?
Thanks
Filip