Excluding Tablespaces from a Restore

While creating a duplicate database, you can exclude selected tablespaces from the duplicate database.

Procedure

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

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. On the General tab, select the Destination Client from the list.

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

8. Select Duplicate To. In the Pfile box, type the name of the startup parameter file for the duplicate database, or browse to the location.

9. Click Advanced.

   The Oracle Duplicate Options dialog box appears.

10. On the Duplicate DB Options tab, select the Duplicate To Skip Tablespace check box, and then click Add.

11. In the tablespaces box, select the tablespaces to exclude from the duplicate database, and then click OK.

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

13. Click OK to start the restore.