Restore Oracle database

Contributors netapp-soumikd

You can only restore the Oracle database to the same SnapCenter Server host, same SVM, or to the same database host. For a RAC database, the data will be restored to the on-premises node where the backup was created.

Only full database with control file restore is supported. If the archive logs are not present in the AFS, you should specify the location that contains the archive logs required for recovery.

Steps

  1. In Cloud Manager UI, click Backup & Restore > Applications.

  2. In the Filter By field, select the filter Type and from the drop-down select Oracle.

  3. Click View Details corresponding to the database that you want to restore and click Restore.

  4. On the Restore Type page, perform the following actions:

    1. Select Control files if you want to restore control file along with full database.

    2. Select Change database state if needed for restore and recovery to change the state of the database to the state required to perform restore and recovery operations.

      The various states of a database from higher to lower are open, mounted, started, and shutdown. You must select this check box if the database is in a higher state but the state must be changed to a lower state to perform a restore operation. If the database is in a lower state but the state must be changed to a higher state to perform the restore operation, the database state is changed automatically even if you do not select the check box.

      If a database is in the open state, and for restore the database needs to be in the mounted state, then the database state is changed only if you select this check box.

  5. On the Recovery Scope page, perform the following actions:

    1. Specify the recovery scope.

      If you…​ Do this…​

      Want to recover to the last transaction

      Select All Logs.

      Want to recover to a specific System Change Number (SCN)

      Select Until SCN (System Change Number).

      Want to recover to a specific data and time

      Select Date and Time.

      You must specify the date and time of the database host’s time zone.

      Do not want to recover

      Select No recovery.

      Want to specify any external archive log locations

      If the archive logs are not present in the AFS, you should specify the location that contains the archive logs required for recovery.

    2. Select the check box if you want to open the database after recovery.

      In a RAC setup, only the RAC instance that is used for recovery is opened after recovery.

  6. Review the details and click Restore.