Performing SAP for Oracle Database Copy

Updated

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. You can also run a data copy operation to restore the database to a new computer or SID.

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.

After the restore, you can recover the database to a point other than the current time, if the current database is inconsistent.

When you choose the option to recover from the latest backup time with a secondary copy, the software considers only the time from the latest job that is available on the secondary copy, even when the primary copy or other copies have a more recent backup job.

Before You Begin

Prepare for a Database Copy for SAP for Oracle

Set the database to the correct mode:

Is the control file included in the restore?

Mode to put the database in

Yes

NOMOUNT

No

MOUNT

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance that contains the data that you want to restore.

    The instance page appears.

  3. In the Recovery points section, select the date for the backup that you want to restore, and then click Restore.

    The Backup content page appears.

  4. Select the content to restore, and then click Restore.

    The Restore options dialog box appears.

  5. On the Database copy tab, specify the following:

    1. From the Destination server list, select the server to restore the data to.

    2. From the Destination instance list, select the instance to restore the data to.

    3. In Number of streams, enter the number of streams to use for the restore.

    4. Under Recover to, specify whether to restore to the current time or to a point in time.

  6. Click Submit.