Restoring an Oracle RAC Database to a Different Location (Out of Place)

Updated

You can restore Oracle RAC data to a new host, or to a new host and a new database.

Data Available to Restore

You can restore any of the following data:

  • The database and control file

  • The database

  • The control file

  • Individual tablespaces and the control file

  • Individual tablespaces

Before You Begin

Set the database to the correct mode defined in the table.

Control file in the restore

Required database mode

Control file is included in the restore

NOMOUNT

Control file not included in the restore

MOUNT

Procedure

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

    The Instances page appears.

  2. Click the instance.

    The instance page appears.

  3. On the Overview tab, in the Recovery points section, select the backup to restore, and then click Restore.

    The Backup content page appears.

  4. Select the data that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  5. Select the Out of place tab.

  6. From the Destination server list, select the host to restore to.

  7. From the Destination instance list, select the instance to restore to.

  8. To change the number of streams to use for the restore, in the Number of streams box, enter the number of streams to use.

  9. To redirect the database or individual table spaces, do the following:

    1. Click Redirect options.

      The Redirect path options dialog box appears.

    2. To redirect the database, click Database, and then enter the full path for the new location of the database.

    3. To redirect individual tablespaces and datafiles, click Tablespaces and datafiles. For each tablespace that you want to redirect:

      1. Expand the tablespace.

      2. In the Datafiles box, change the path to the new location.

    4. To redirect the temporary tablespaces, move the Redirect temporary tablespaces toggle to the right, and then enter the full path for the new location.

    5. To change the characteristics of the online redo logs, move the Online redo logs toggle to the right, and then enter the information for the redo logs.

    6. Click Save.

  10. Select the data that you want to restore.

    These options only appear if you chose to restore all the tablespaces.

    • To restore the database or individual tablespaces, select the Database check box and clear the Control file check box.

    • To restore the control file, clear the Database check box and select the Control file check box.

    • To restore the SP file, clear the Database check box and select the SP File check box.

    • To restore the log files, clear the Database check box.

  11. Choose if you want to apply the archive files to the data files or if you want to only restore the archive log files:

    • To apply the archive files to the data files select Recover to, and then specify how you want to apply the archive files to the data files.

    • To only restore the archive log, select Restore archive log, and then do the following:

      1. Choose the archive log type and specify the start and end information for that type.

      2. In the Target directory box, enter the full path to the directory.

  12. To automatically move the database or selected tablespaces to the correct offline mode before the restore, select the Switch Database Mode check box.

  13. Click Submit.