Duplicating an Oracle Database from an Active Database with a Configured Instance

Create a duplicate database for testing and demonstrations.

When you duplicate a database from an active database, no backup is required. The duplicate database is a copy of the current data on the target database.

A duplicate (auxiliary) database is a copy or a subset of the target database with a unique DBID. It is independent of the primary database, and can be registered in the same recovery catalog as the primary database.

If you are restoring from a lower version of Oracle to a higher version, use the STARTUP UPGRADE command. After STARTUP UPGRADE, refer to the Oracle documentation for detailed instructions.

Before You Begin

• Obtain a password to connect to the source database.

• The source database must be in ARCHIVELOG mode if it is open. When the source database is in NOARCHIVELOG mode, perform a clean shut down and place it in MOUNT mode.

• You must use the same SYSDBA password on the source database and the duplicate database instance.

• If the duplicate database instance is on the local host, provide a net service name to connect RMAN to the duplicate database instance.

• On the destination host, add an instance on the CommCell Console.

• Optional: To mask the data, create a masking policy. For more information, see Managing Oracle Data-Masking Policies.

Procedure

1. From the CommCell Browser, go to Client Computers > client > Oracle.

2. Right-click the instance, then go to All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. Select Latest Backup, and then click the View Content button.

4. Select the database, and then click the Recover All Selected button.

   The Oracle Restore Options dialog box appears.

5. Click RMAN Duplicate DB, and then click Next.

   The Oracle RMAN Duplicate DB Options dialog box appears.

6. To obtain the latest database status, click Refresh.

7. In the Duplicate To box select the destination instance.

8. Select Duplicate To.

   1. To skip the read-only tables, select the Skip Read Only check box.

   2. To open the database in restricted mode, select the Open Restricted check box.

   3. In the Pfile box, type the name of the startup parameter file for the duplicate database, or browse to the location.

9. Select the Duplicate from Active Database check box.

10. Click Advanced.

    The Oracle Duplicate Options dialog box appears.

11. Optional: Have the Commvault software mask the data on the destination.

    1. On the General tab, select the Mask Sensitive Data check box.

    2. From the Data Masking Policy list, select the policy to mask the data.

12. On the Copy Precedence tab, select the Restore from Copy Precedence check box and enter a copy precedence number.

13. Optional: If you do not want to use the DB_FILE_NAME_CONVERT option to restore all the data and temp files to a different directory structure from the source database, on the Redirect tab, select the redirected data:

    1. To redirect all data files, select Redirect All Table Spaces/Database to and type the path or Browse to it.

       • Alternatively, click the Redirect checkbox and select individual table spaces and type the path in the New Path box or Browse to it.

       • To redirect multiple table spaces simultaneously, click Find & Replace and replace the existing path with the new path.

    2. To redirect temporary tablespaces, select Redirect Temp Table Spaces To and type the path or Browse to it.

14. Optional: If you want to create online redo logs for the duplicate database, on the Duplicate DB Options tab, select Duplicate to Log File.

    1. Select the Group option to use and specify redo log files by using group members and click Add, or the File option to specify redo log files by using a file, and click Add.

    2. If you selected the File option, in the Spec Dialog for Oracle Redo Log File box:

       • Type the redo log file name or browse to the location.

       • In the Size box, type the size of the online redo log file.

       • In the SizeSpec list, select the size specification of the file.

       • To allow the database to reuse an existing file, select the Reuse check box.

    3. If you selected the Group option, in the Spec Dialog for Oracle Redo Log Group box:

       • In the Size box, type the size of the online redo log file.

       • In the SizeSpec list, select the size specification of the file.

       • To allow the database to reuse an existing file, select the Reuse check box.

15. Click OK to close the Oracle Duplicate Options dialog box.

    The Oracle RMAN Duplicate DB Options dialog box appears.

16. Optional: View or customize the RMAN script that is automatically generated from the selected options. For more information, see Viewing Oracle Restore RMAN Scripts and Customizing Oracle Restore RMAN Scripts.

17. Click OK to start the restore.