Using SnapManager for Oracle to restore backups from secondary storage

Contributors akseldavis

Administrators can restore protected backups from secondary storage and can choose how they want to copy the data back to the primary storage.

Before you attempt to restore the backup, check the properties of the backup and ensure that the backup is freed on the primary storage system and is protected on secondary storage.

  1. From the SnapManager for Oracle Repository tree, right-click the backup you want to restore, and select Restore.

  2. In the Restore and Recovery Wizard Welcome page, click Next.

  3. In the Restore Configuration Information page, click Complete Datafile/Tablespace Restore with Control Files.

  4. Click Allow shutdown of database if necessary, and then click Next.

    SnapManager changes the database state, if necessary. For example, if the database is offline and it needs to be online, SnapManager forces it online.

  5. At the Recovery Configuration Information page, click All Logs. Then, click Next.

    SnapManager restores and recovers the database to the last transaction and applies all required logs.

  6. In the Restore Source Location Configuration page, select the ID of the protected backup source and click Next.

  7. In the Volume Restore Configuration Information page, click Attempt volume restore to attempt volume restore.

  8. Click Fallback to file-based restore.

    This allows SnapManager to use the file-based restore method if the volume restore method cannot be completed.

  9. To see the eligibility checks for fast restore and information about mandatory and overridable checks, click Preview.

  10. At the Perform Operation page, verify the information you have supplied and click Restore.

  11. To view details about the process, click Operation Details.