Duplicating an Oracle RAC Database

You can create a duplicate Oracle RAC database for purposes such as testing or demonstrations.

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. Click the Out of place tab.

6. Click RMAN duplicate.

7. From the Destination server list, select the server to duplicate the database to.

8. From the Destination instance list, select the instance to duplicate the database to.

9. In the Number of streams box, type the number of streams to use for the restore.

10. To create a duplicate standby database, select Duplicate for standby.

11. 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.

12. Select the database Recover to option. These options control how the archive files are applied to the data files.

    • To recover to the latest backup job completion time, select Most recent backup.

    • To recover the database to the current time, select Current Time.

    • To recover to a point-in-time, select Point in Time, and then enter the date and time.

    • To recover to a System Change Number, select SCN, and then type the SCN.

      The SCN tracks the timing of transactions in the database. The SCNs are stored in the control files and the datafile headers. You can recover the database to the last existing SCN number in the control file, which is the last consistent database state.

13. Click Submit.