Restore and Recover an Entire Database in ARCHIVELOG Mode to the Current Time

The following procedure describes the steps involved in restoring and recovering a database running in ARCHIVELOG mode, with lost data files and control files.

This procedure restores and recovers the database as follows:

• From an online backup
• With the control file(s) (since they no longer exist)
• To the current time and to the original host
• Using the Recovery Catalog

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore.

Required Capability: See Capabilities and Permitted Actions

To restore and recover Restore an entire database in ARCHIVELOG mode to the current time:

1. From the CommCell Browser, right-click the instance that contains the database you want to restore and recover, click All Tasks and then click Restore.
2. From the Oracle Restore Options (General) dialog box, select the following options:
   • Select the name of the client computer with the database you want to restore in the Destination Client box (if it is not already selected).
   • Select the Restore Control File option.
   • Select the Restore Data and Recover options.
   • Select the entire database in The Latest Database View pane (if it is not already selected).
   • Verify that the Status of the database is displayed as STARTED; if necessary click on the Refresh button to refresh the status.
3. Click the Advanced button and verify the following options are selected in the identified tab for the Oracle Advanced Restore Options dialog box:
   • Restore Control File (if you do not have one) in Ctrl & SP Files
   • Restore Data - From the Latest Backup in Restore
   • Recover - Current Time in Recover
4. Click OK in the Oracle Advanced Restore Options window.
5. When restoring encrypted data, refer to Data Encryption.
6. Optionally for Oracle RAC, from the Oracle Restore Options (Stream) dialog box, set the instance restore order per stream allotment.
7. Begin or schedule the restore.

   Before the restore job is run, the system will check whether the database is in the correct mode for this type of restore. If it is not, a message dialog will inform you of this and offer to automatically switch the database into the valid mode. When this happens, either click Yes on the message dialog to have the system automatically switch the database to the valid mode and continue the restore, or click No to manually switch the database to the valid mode before proceeding.

8. While the job is running you can right-click the job in the Job Controller and select Details to view information on the job. After the data has been restored, you will see a job completion message in the Job Controller and Event Viewer.

   The system automatically resets the logs and the database. Before you can restore and recover the database to the current time, it is good practice to perform another full backup and wait for it to complete successfully.

NOTES

• If you restore the control file, then you have to perform a full database backup. This is because restoring the control file will destroy all previous backups.