We are performing everyday full backups (plus archivelogs) using rman on our Oracle9i RAC database (in archivelog mode). The backup takes around 3 hours to complete. After we start the backup we wait for about 1 hour and then start transacting on the database through our application. Is it possible to take that backup and restore on a different database to the point in time when the backup started (or at any time within the first 1 hour window) assuming we take a backup of the controlfile at some point before or after the backup?
Is it possible to take that backup and restore on a different database to the point in time when the backup started
You will need the previous backup plus all archivelogs to restore/recover to that point in time (PIT).
The easiest would be to do an rman duplicate and take a PIT at the moment the hotbackup does the second archivelog backup run started.
There are plenty of examples in this forum on how to do a duplicate.