Duplicating an Oracle Database

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

Procedure

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

   The database overview page appears.

2. On the Instances tab, click the instance.

   The instance properties 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 option.

6. From the Restore type list, select 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. To change the number of streams to use, in the Number of streams box, enter the number of streams.

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

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

12. To apply the archive files to the data files for the Recover to selection, from the Recover to type list select the type of recovery and enter any related values.

13. To create the duplicate database without connecting to the target database, under Advanced options select the Skip target connection check box.

14. To use the recovery catalog, move the Use recovery catalog toggle to the right, and then select a saved credential.

15. To specify pre or post recovery scripts, do the following under Pre or Post options:

    1. Type the path to the script.

    2. To run a script as a specific user, move the Run as user toggle to the right and then select a saved credential.

16. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       • You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       • Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

17. To customize the script for this restore operation, click PREVIEW.
    The preview window appears.

    1. To customize the script, click CUSTOMIZE.
       The Customize script window appears.
    2. On the Ctrl/SP file script or on the Database script tab, modify the script.
    3. Click SUBMIT to submit the modified script.

18. If you did not customize the script, click SUBMIT.

Related Topics

Viewing and Editing a Database Restore Schedule for Oracle