Loading...

Excluding Tablespaces from a Restore

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

Procedure

  1. From the CommCell Browser, go to Client Computers > RAC client.
  2. Right-click the instance, point to All Tasks, and then click Browse and Restore.
  3. In the Browse and Restore Options dialog box, select Latest Backup and click View Content.
  4. Select the database, then select Recover All Selected.
  5. On the Oracle Restore Options dialog box, click RMAN Duplicate DB, then click Next.

    The Oracle RMAN Duplicate DB Options window appears.

  6. In 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 Oracle Duplicate Options dialog box, navigate to the Duplicate DB Options tab:
    1. Select the Duplicate To Skip TableSpace check box.
    2. Click Add.
    3. In the Table Spaces box, select the tablespaces to exclude from the duplicate database.
    4. Click OK.
  11. Click OK to close the Oracle Duplicate Options dialog box.
  12. Click OK to start the restore.

Last modified: 6/6/2019 11:27:16 PM