Excluding Read-Only Oracle RAC Tablespaces During a Restore

By default, the read-only tablespaces are not verified for consistency and are restored from the backup. You can skip the consistent tablespaces and restore the tablespaces that are not consistent or missing. This will save the time taken for the restore.

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.

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

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

9. On the Stream tab, double click the number of streams to use for each Oracle RAC instance in the Stream column, and enter the number of streams.

10. Click OK to start the restore.