Skip to main content
BlueXP backup and recovery
All cloud providers
  • Amazon Web Services
  • Google Cloud
  • Microsoft Azure
  • All cloud providers

Restore cloud-native Oracle databases to original location

Contributors netapp-soumikd

In the event of data loss, you can restore the data files, control files, or both to original location and then recover the database.

Before you begin

If the Oracle 21c database is in STARTED state, the restore operation fails. You should run the following command to restore the database successfully.
cp -f <ORACLE_HOME>/jdbc/lib/ojdbc8.jar /opt/NetApp/snapcenter/spl/plugins/sco/lib/ojdbc8-8.jar

Steps

  1. Click icon to select the action corresponding to the database that you want to restore and click Restore.

  2. Select the restore point to which the database should be restored and click Restore to original location.

  3. In the Restore Scope section, perform the following actions:

    If you…​ Do this…​

    Want to restore only the data files

    Select All Data Files.

    Want to restore only the control files

    Select Control Files

    Want to restore both data files and control files

    Select All Data Files and Control Files.

    You can also select Force in-place restore checkbox.

    In Amazon FSx for NetApp ONTAP or Cloud Volumes ONTAP SAN layout, if SnapCenter Plug-in for Oracle finds any foreign files other than Oracle data files on the ASM diskgroup, connect and copy restore method is performed. The foreign files could be one or more of the following types:

    • Parameter

    • Password

    • archive log

    • online log

    • ASM parameter file.

      The Force in-place restore option overrides the foreign files of type parameter, password, and archive log. You should use the latest backup when Force in-place restore option is selected.

  4. In the Recovery Scope section, perform the following actions:

    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 and specify the SCN.

    Want to recover to a specific date and time

    Select Date and Time.

    Do not want to recover

    Select No recovery.

    For the selected recovery scope, in the Archive Log Files Locations field you can optionally specify the location that contains the archive logs required for recovery.

    Select the check box if you want to open the database in READ-WRITE mode after recovery.

  5. Click Next and review the details.

  6. Click Restore.