Create an Oracle Restore Job Definition

Restore Oracle environments from snapshots using an Oracle Restore job definition. IBM Spectrum Protect Plus creates a vSnap clone from the version selected during the job definition creation and creates an NFS share. The IBM Spectrum Protect Plus agent then mounts the share on the Oracle server where the restore is to be performed. In the case of Oracle RAC, the restore is performed on all nodes in the cluster.

BEFORE YOU BEGIN:

  • Create and run an Oracle Backup job. See Create an Oracle Backup Job Definition.
  • Review Oracle requirements. See Oracle Requirements.
  • Before an IBM Spectrum Protect Plus user can perform backup and restore operations, roles and resource groups must be assigned to the user. Grant users access to resources and backup and restore operations through the Accounts pane. See Access.

ORACLE DATABASE CONSIDERATIONS:

  • Point-in-time recovery is not supported when one or more datafiles are 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 related to autoextensibility and maximum size. When a database is restored from this restore point, IBM Spectrum Protect Plus cannot recreate the tempfiles with the original settings because they are unknown. Instead, IBM Spectrum Protect Plus creates tempfiles with default settings "AUTOEXTEND ON" and "MAXSIZE 32767M". The settings can then be manually updated as desired after the restore completes.

To create an Oracle Restore job definition:

  1. From the navigation menu, expand Manage Protection, then expand Applications. Expand Oracle, then click Restore.
  2. In the Restore pane, review the available restore points of your Oracle instances. Use the search function to search for available restore points and toggle the displayed restore points through the View filter.
  3. To select the latest restore point, click Add to Restore List Add to Restore List icon at the resource level. Then, from the Select a site drop-down menu, select the site associated with the backup storage server you want to recover from. To restore a specific restore point from a specific site, expand a resource in the Restore pane, then click the Add to Restore List Add to Restore List icon icon associated with the restore point. Note that adding a combination of latest restore points and specific restore points to the Restore List is not supported. Click the Remove Remove icon icon to remove restore points from the Restore List.
  4. To run the job now using default options, click Restore. To schedule the job to run using default options, click Manage Jobs and define a trigger for the job definition.
  5. To edit options before creating the job definition, click Options. Set the job definition options.
  6. Destination
  7. Set the restore destination.
  8. Restore to original location - Select to restore to the original server.
  9. Restore to alternate location - Select to restore to a local destination different from the server, then select the alternate location from available servers.
  10. Click the New Database Name field to enter an optional alternate name for the database.
  11. Restore Type
  12. Set the Oracle Restore job to run in Test or Production mode by default. Once the job is created, it can be run in Test or Production mode through the Job Sessions pane.
  13. Recovery Options
  14. Recover until end of backup - Restore the selected database to the state at the time the backup was created.
  15. Recover until specific point in time - When log backup is enabled through an Oracle Backup job definition, point-in-time restore options will be available when creating an Oracle Restore job definition.
  16. To configure a point-in-time recovery by a specific date and time, select By Time. Select a date through the calendar interface and a time through the hour and minutes drop-down menus, then click Save.
  17. To configure a point-in-time recovery by System Change Number, select By SCN. Enter a System Change Number in the available field, then click Save.
  18. IBM Spectrum Protect Plus finds the restore points that directly proceed and follow the selected point-in-time. During the recovery, the older data backup volume and the newer log backup volume are mounted. A temporary restore point is created if the point-in-time is after the last backup.
  19. Application Options
  20. Overwrite existing database - Enable to allow the restore job to overwrite the selected database. By default this option is disabled.
  21. Maximum Parallel Streams per Database - Set the maximum data stream from the backup storage per database. This setting applies to each database in the job definition. Note that multiple databases can still be restore in parallel if the value of the option is set to 1. Multiple parallel streams may improve restore speed, but high bandwidth consumption may affect overall system performance.
  22. This option is only applicable when restoring an Oracle database to its original location using its original database name.
  23. Advanced Options
  24. Set the advanced job definition options:
  25. Run cleanup immediately on job failure - Enable to automatically clean up allocated resources as part of a restore if the recovery fails.
  26. Allow session overwrite - Select this option to replace an existing database with the same name during recovery. When an Instant Disk Restore is performed for a database and another database with the same name is already running on the destination host/cluster, IBM Spectrum Protect Plus shuts down the existing database before starting up the recovered database. If this option is not selected, the restore job fails when IBM Spectrum Protect Plus encounters an existing running database with the same name.
  27. Continue with restores of other selected databases even if one fails - Toggle the recovery of a resource in a series if the previous resource recovery fails. If disabled, the Restore job stops if the recovery of a resource fails.
  28. Init Params - This option controls the initialization parameters used to start up the recovered database in Oracle Test and Production workflows.
  29. Source: This is the default option. IBM Spectrum Protect Plus uses the same initialization parameters as the source database, but with the following changes:
      • Parameters that contain paths such as control_files, db_recovery_file_dest, or log_archive_dest_* are updated to reflect the new paths based on the renamed mount points of the recovered volumes.
      • Parameters such as audit_file_dest and diagnostic_dest are updated to point to the appropriate location under the Oracle Base directory on the destination server if the path differs from the source server.
      • The db_name and db_unique_name are updated to reflect the new name of the database if a new name is specified.
      • The db_name and db_unique_name are updated to reflect the new name of the database if a new name is specified.
      • Cluster-related parameters such as instance_number, thread, and cluster_database are set automatically by IBM Spectrum Protect Plus depending on the appropriate values for the destination.
  30. Template: Customize the initialization parameters by specifying a template file containing the initialization parameters that IBM Spectrum Protect Plus should use.
  31. The specified path must be to a plain text file that exists on the destination server and is readable by the IBM Spectrum Protect Plus user. The file must be in Oracle pfile format, consisting of lines in the form name = value. Comments beginning with the # character are ignored.
  32. IBM Spectrum Protect Plus reads the template pfile and copies the entries to the new pfile that will be used to start up the recovered database. However, the following parameters in the template are ignored. Instead, IBM Spectrum Protect Plus sets their values to reflect appropriate values from the source database or to reflect new paths based on the renamed mount points of the recovered volumes.
      • control_files
      • db_block_size
      • db_create_file_dest
      • db_recovery_file_dest
      • log_archive_dest
      • spfile
      • undo_tablespace
  33. Additionally, cluster-related parameters like instance_number, thread, and cluster_database are set automatically by IBM Spectrum Protect Plus depending on the appropriate values for the destination.
  34. Protocol Priority (Instant Access only) - If more than one storage protocol is available, select the protocol to take priority in the job. Available protocols include iSCSI and Fibre Channel.
  35. Script Settings
  36. In the Pre-Script and/or Post-Script section, select an uploaded script. Select the Use Script Server check box to select a script server where the script will run. To select an Application Server where the script will run, clear the Use Script Server check box. Scripts and script servers are configured through the Jobs and Monitoring > Script pane. See Configure Scripts.
  37. Pre-scripts and post-scripts are scripts that can be run before or after a job runs at the job-level. Windows-based machines support Batch and PowerShell scripts while Linux-based machines support shell scripts.
  38. Continue job/task on script error - When enabled, if a Pre-script completes with a non-zero return code, the backup or restore is attempted and the Pre-script task status returns COMPLETED. When disabled, the backup or restore is not attempted, and the Pre-script task status returns FAILED. If a Post-script completes with a non-zero return code, the Post-script task status returns COMPLETED. When disabled, the Post-script task status returns FAILED.
  39. Click Save to save the policy options.
  40. To run the job now, click Restore. To schedule the job click Manage Jobs and define a trigger for the job definition.

 


IBM Spectrum Protect Plus 10.1.2

Licensed Material - Property of IBM Corp. © IBM Corporation and other(s) 2018. IBM is a registered trademark of the IBM Corporation in the United States, other countries, or both. | 8/23/2018