Oracle Database Restore

Use the following procedure as a guideline for restoring the Oracle database after a database failure.

Depending on the type of failure event you have experienced, you can either restore the most current copy of the database, or an historic version of the database. The recommended procedure is to restore the most recent copy of the database first. This will provide the least amount of data loss.

However, in a data corruption event, the most current backed up version may be corrupted. This is dependent on when the corruption occurred and whether the corrupted data has already been backed up. You may need to perform several restores, current then historic, until you restore a version from before the corruption occurred.

To restore the Oracle database

1. Stop the Oracle Instance. Refer to your Oracle documentation for details.

2. If you are planning to restore the Oracle database over the Internet, suspend backup for the computer that is running the Oracle database you are restoring.

   Important: The purpose of suspending backup is to make the process of restoring the Oracle database easier in the event you need to perform iterative restores due to corruption. However, suspending backup means that all backup is suspended until you resume it. If this is an issue for you, please contact Customer Service for assistance. 

   This step is only recommended if you are restoring over the Internet. If you select Automatic delivery and we decide to restore your data over the Internet, then we will suspend your backup at that time if it is deemed appropriate.

3. Follow the steps in Restoring Files and Directories, or Databases to restore the Oracle database using MyLiveVault. When requesting the restore it is important to do the following:

   • When specifying the files and directories to restore, ensure that you select all the files comprising the Oracle database.

   • Only select the Network delivery option if you are sure that you have sufficient bandwidth and the connection stability to restore your data. Otherwise an additional restore using media may be required, delaying your restore.

   • If you choose Network delivery, set the following restore options:

     • Choose the Auto rename the existing file option.

     • Choose the Restore the original NTFS security descriptors option.

4. If your data is restored on media, after you receive the media with your restored data, refer to the media restore steps to restore the data from the media to your computer. During the media restore, set the following restore options:

   • Choose the Auto rename the existing file option.

   • Choose the Restore the original NTFS security descriptors option.

5. After the restore is complete, restart the Oracle Instance. It should recover itself from the data provided in the restore. Refer to your Oracle documentation for details.

6. Verify that the restore was successful, for example, your database is no longer corrupted. If the restore was successful, go to the next step. If you need to restore a different version, perform this procedure again choosing an older version.

7. Resume backup if it was suspended for this restore procedure.

Related Information

Oracle Database Backup Configuration