Apply Transaction Logs to an Oracle Database on a recovered QR Volume with Archive Log Backups

Before starting restore operations, review these prerequisites and operational procedures.

• Review the information in Using Transaction/Archive Logs with Recovered QR Volumes.
• You have installed the Oracle iDataAgent and QR Agent on the same client.
• You have a snapshot engine, such as QSnap.
• You have performed any one of the following tasks for the Oracle instance:
  • Full QR Volume Creation only
  • QR Incremental Updates using a schedule
  • Full QR Volume Creation with logs backup
  • QR Incremental Updates as well as logs backup

Required Capability: See Capabilities and Permitted Actions

To recover a database from a QR Volume with archive log backups.

1. Perform a QR Recovery to recover the point-in-time Oracle data from your QR Volumes. Refer to Recovering QR Volumes for procedures on performing a QR Recovery.
2. After recovering the point-in-time Oracle data from your QR Volumes, access the CommCell Console, right-click the instance of the Oracle iDataAgent, click All Tasks and then click Restore.
3. From the Oracle Restore Options (General) dialog box, select Restore Archive Log and clear the Restore Data checkbox. Click Advanced.
4. From the Restore tab of the Oracle Advanced Restore Options dialog box, under the Restore Archive Log - By Log Time options, clear the Start checkbox then click End and select the date and time that the most recent archive log backup completed. Click OK.
5. When restoring encrypted data, refer to Data Encryption.
6. Start or schedule the restore. The restore job will begin and you can track the status of the job in the Job Controller window. After the job completes, all the archive logs are restored to the specified point-in-time.
7. After the archive logs have been restored, right-click the instance of Oracle iDataAgent, click All Tasks and then click Restore.
8. From the Oracle Restore Options (General) dialog box, select Recover and clear the Restore Data checkbox. Click Advanced.
9. From the Recover tab of the Oracle Advanced Restore Options dialog box, under the Recover options, click Point in Time and select the date and time equal to the last logs backup time. Click OK.
10. Start or schedule the restore. The recovery job will begin and you can track the status of the job in the Job Controller window. After the job completes, the database will be recovered to the specified time, and the state of the Oracle database will change from MOUNTED to OPEN. This will result in all the archived logs being applied towards the instance.

    If the database recovery fails with an error indicating that it was unable to find an archive log then continue on with this procedure, otherwise this task is complete.

11. Right-click the instance of Oracle iDataAgent, click All Tasks and then click Restore.
12. From the Oracle Restore Options (General) dialog box, select Recover and clear the Restore Data checkbox. Click Advanced.
13. From the Recover tab of the Oracle Advanced Restore Options dialog box, under the Recover options, click Point in Time then select the date and time to which you want to recover the database.
14. From the Options tab of the Oracle Advanced Restore Options dialog box, select No Re-do Logs and then click OK.
15. Optionally for Oracle RAC, from the Oracle Restore Options (Stream) dialog box, set the instance restore order per stream allotment.
16. Start or schedule the restore. The recovery job will begin and you can track the status of the job in the Job Controller window. After the job completes, the Oracle database will be recovered to the specified time, and the state of the Oracle database will change from MOUNTED to OPEN.