Skip to main content
NetApp Backup and Recovery
All cloud providers
  • Amazon Web Services
  • Google Cloud
  • Microsoft Azure
  • All cloud providers

Restore Oracle databases with NetApp Backup and Recovery

Contributors netapp-mwallis
PDFs

Restore Oracle databases from snapshot copies, from a backup replicated to secondary storage, or from backups stored in object storage using NetApp Backup and Recovery.

Restore from these locations

You can restore databases from different starting locations:

  • Restore from a primary location (local snapshot)

  • Restore from a replicated resource on secondary storage

  • Restore from an object storage backup

Restore to these points

You can restore data to the original location; restoring to an alternate location is not available in this private preview release.

  • Restore to the original location

How restoring Oracle databases works

When you restore Oracle databases, the following occurs:

  • When you restore a database from a local snapshot, NetApp Backup and Recovery creates a new resource using the data from the backup.

  • When you restore from replicated storage, you can restore it to the original location.

  • When you restore a backup from object storage, you can restore the data to the source storage or to an on-premises ONTAP system and recover the database from there.

From the Restore page (also known as Search & Restore), you can restore a database, even if you don't remember the exact name, the location in which it resides, or the date when it was last in good shape. You can search for the database using filters.

Restore an Oracle database

Depending on your needs, restore an Oracle database to a specific point in time, to a specific system change number (SCN), or to the last good state. You can also simply restore the database from snapshots and skip the automated recovery process. You might want to skip the automated recovery process if you want to perform recovery manually. You can search for the database using its name or with specific filters.

Required Console role
Backup and Recovery super admin or Backup and Recovery restore admin role. Learn about NetApp Console access roles for all services.

Steps

  1. From the NetApp Console menu, select Protection > Backup and Recovery.

  2. From the NetApp Backup and Recovery menu, select Restore.

  3. From the drop-down list to the right of the name search field, select Oracle.

  4. Enter the name of the database you want to restore or filter for the database host where the database that you want to restore is located.

    A list of snapshots appears that match your search criteria.

  5. Select the Restore button for the database that you want to restore.

  6. Choose a restore option:

    Restore to specific point in time

    1. Select Restore to specific point in time.

    2. Select Next.

    3. Choose a date from the dropdown, and select Search.

      A list of matching snapshots on the specified date are displayed.

    Restore to a specific system change number (SCN)

    1. Select Restore to a specific system change number (SCN).

    2. Select Next.

    3. Enter the SCN to use as a restore point, and select Search.

      A list of matching snapshots for the specified SCN are displayed.

    Restore to the latest backup (last good state)

    1. Select Restore to the latest backup.

    2. Select Next.

      The latest full and log backups are displayed.

    Restore from snapshots with no recovery

    1. Select Restore from snapshots with no recovery.

    2. Select Next.

      The matching snapshots are displayed.

  7. Select a snapshot source location.

  8. Select Next to continue to the Restore destination settings page.

    Next, you can choose the destination settings and the pre-restore and post-restore options.

Destination selection

  1. Choose the destination settings and the pre-restore and post-restore options.

Restore to original location

  1. Destination settings:

    • Choose to restore the entire database or only the tablespaces for the database.

    • Control files: Optionally, enable this option to also restore the database control files.

  2. Pre-restore options:

    • Optionally, enable this option and enter the full path for a script that should be run before the restore operation and any arguments that the script takes.

    • Choose a timeout value for the script. If the script fails to execute within this time period, the restore will proceed anyway.

  3. Post-restore options:

    • Postscript: Optionally, enable this option and enter the full path for a script that should be run after the restore operation and any arguments that the script takes.

    • Open the database or container database in READ-WRITE mode after recovery: After the restore operation is complete, Backup and Recovery will enable READ-WRITE mode for the database.

  4. Notification section:

    • Enable email notifications: Select this to receive email notifications about the restore operation and indicate what type of notifications you want to receive.

  5. Select Restore.

Restore to alternate location

Not available for Oracle workloads preview.