Loading...

Performing a SAP for Oracle Database Copy

Perform a SAP for Oracle Database Copy when the original database host has been damaged or destroyed, and you need to restore the data to a different host from the backup.

The SnapProtect software automatically selects the SAP for Oracle Database Copy feature when:

  • The destination client is different and the destination instance is the same
  • The destination client is different and the destination instance is different
  • The destination client is the same and the destination instance is different

Note: The existing log and data summary files are overwritten. Detail files that have the same name as the ones you are restoring are overwritten.

Best Practice: You can use this procedure to restore the database to a new machine or to a new SID.

Before You Begin

  1. Perform a full backup with an online or offline subclient.
  2. Verify the following in both the source and destination hosts:
    1. The connection specifications (host, service name, port) in the tnsnames.ora file on both the source and destination hosts must be different.
    2. There must be enough disk space on the destination host for the restored database.
    3. The source and destination hosts must have the same:
      • Operating systems
      • Oracle version
      • Processor (32-bit or 64-bit)
  3. The following Oracle initialization files must be present on the destination client:
    • init<SID>.ora
    • init<SID>.sap
    • spfile<SID>.ora
  4. On the destination host, install the SAP on Oracle application and then create an empty instance. The SAPDATA_HOME path on the destination host can be the same path or a different path from the source, but the directory structure inside the SAPDATA_HOME path must be the same.
  5. On the destination host, create a SAP for Oracle instance in the CommCell Console.

    Note: You must have the source and destination hosts configured as clients in the same CommCell Console.

  6. On the destination host, create the SPFILE (spfile<SID>.ora) from the Oracle initialization file. Go to the $ORACLE_HOME (for UNIX configurations) or %ORACLE_HOME%\database (on Windows configuration) and type the following command:

    Note: Do not modify this file after you create it.

    ssqlplus / as sysdba
    SQL> startup nomount pfile= init .ora;
    SQL> create spfile from pfile;

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box is displayed.

  6. On the General tab:
    1. From the Destination Client list, select a client computer.

      When you select a client computer that is different from the source computer,  the software automatically makes all checkboxes in the Restore Options section unavailable and automatically selects the Database Copy check box.

    2. From the Destination Instance list, select the instance that the software uses for the restore.

      When you select a client computer that is the same from the source computer and an instance that is different from the source instance,  the software automatically makes all checkboxes in the Restore Options section unavailable and automatically selects the Database Copy check box.

    3. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  7. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. On the Options tab:
    • Select the Open DB check box.
    • Select Yes from the Reset Logs list.
    • When you restore from an offline backup, select the Reset Database check box.
  9. Optional: To recover the database to a point-in-time, on the Options tab:
    • Select the Point-in-time option.
    • Select the date to recover the database to from the calendar.
    • Type the time to recover the database to, in the date box.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.