Restoring Oracle data
Use a restore job to restore an Oracle environment from snapshots. IBM Spectrum® Protect Plus creates a vSnap clone from the version that is selected during the job definition creation and creates a Network Files System (NFS) share. The IBM Spectrum Protect Plus agent then mounts the share on the Oracle server where the restore job is to be run. For Oracle Real Application Clusters (RAC), the restore job is run on all nodes in the cluster.
Before you begin
- Create and run an Oracle backup job. For instructions, see Backing up Oracle data.
- Before an IBM Spectrum Protect Plus user can restore data, the appropriate roles and resource groups must be assigned to the user. Grant users access to resources and backup and restore operations by using the Accounts pane. For instructions, see Managing user access.
- Point-in-time recovery is not supported if one or more data files were added to the database in the period between the chosen point in time and the time that the preceding backup job ran.
- If an Oracle database is mounted but not opened during a backup job, IBM Spectrum Protect Plus cannot determine the database tempfile settings that are related to autoextensibility and maximum size. When a database is restored from this restore point, IBM Spectrum Protect Plus cannot re-create the tempfiles with the original settings because they are unknown. Instead, tempfiles are created with default settings, AUTOEXTEND ON and MAXSIZE 32767M. After the restore job is completed, you can manually update the settings.
- When restoring from a IBM Spectrum Protect archive, files will be migrated to a staging pool from the tape prior to the job beginning. Depending on the size of the restore, this process could take several hours.
About this task
- Instant access mode
- In instant access mode, no further action is taken after mounting the share. Users can complete any custom recovery by using the files in the vSnap volume.
- Test mode
- In test mode, the agent creates a new database by using the data files directly from the vSnap volume.
- Production mode
- In production mode, the agent first restores the files from the vSnap volume back to primary storage and then creates the new database by using the restored files.
Procedure
To define an Oracle restore job, complete the following steps:
Results
An on-demand job begins after you click Submit, and the onDemandRestore record is added to the Job Sessions pane shortly. To view the progress of the restore operation, expand the job. You can also download the log file by clicking the download icon .
A recurring job will begin at the scheduled start time when you start the schedule in the
page.All running jobs are viewable in the
page.What to do next
Oracle databases are always restored in non-multithreaded mode. If the databases that you restored were originally in multithreaded mode, after the restore operation is completed, you must manually configure credentials and switch the databases to the multithreaded mode.