Performing SAP for Oracle Database Copy


If an original database host is damaged or destroyed, and you need to restore the data to a different host from the backup, you can restore to a database copy. You can also perform a database copy to restore the database to a new computer or SID.

Important: When you restore to a database copy, the following files are overwritten:

  • Log files

  • Data summary files

  • Detail files that have the same names as the files that you are restoring

If you use the most recent backup for the database copy, the software considers only the time from the most recent 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






  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.

What to Do Next

After the restore is complete, if the current database is not consistent, you can restore the database to a point other than the current time.