Restoring Tables from an Oracle RAC client to a Non-Oracle RAC Client

You can restore the Oracle RAC tables to a non-Oracle RAC client.

The Commvault software creates an auxiliary instance on a source Oracle RAC node. The tables are imported to a non-Oracle RAC client that you specify (Table Restore Options dialog box, Select a Client list).

Best Practice: Use the Oracle catalog when you perform a table-level restore on Oracle 11g or a more recent version. The restore needs the catalog in order to skip Oracle TTS failures that happen when the target connection occurs.

Before You Begin

1. Configure Oracle Subclients for Table Level Restores.

2. Perform a full backupof the subclient.

3. Verify the following configuration:

   • The source and destination hosts have the same schema

   • The source and destination clients use a different connection name in the tnsnames.ora file

   • The database names in the table are included in the files

     Database Name	tnsnames.ora on source	tnsnames.ora on destination	listner.ora on destination
     duplicate database name	√	√	√
     source database name		√

   Example

   The following are examples of the tnsnames.ora files for the source and destination clients. The source database name is db1_table and the destination database name is db1.

   Source client tnsnames.ora file

   db1_table =
   (DESCRIPTION = 
   (ADDRESS = (PROTOCOL = TCP)(HOST = M1)(PORT = 1521))
   (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = db1)
   )
   )
   

   Destination client tnsnames.ora file

   db1 = 
   (DESCRIPTION = 
   (ADDRESS = (PROTOCOL = TCP)(HOST = M2)(PORT = 1521))
   (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = db1)
   ) 
   )
   

Procedure

1. From the CommCell Browser, expand Client Computers > client > Oracle RAC.

2. Right-click the instance, point to All Tasks and then select Browse and Restore.

3. Select the Table View check box and click View Content.

4. Optional: You can include or exclude any of the following tables in the restore, dependent, referenced and recursively dependent tables.

   Right-click the table, and choose whether to include or exclude dependent or referenced tables.

   Option	Description
   Deselect All Dependent Tables	Exclude all dependent tables
   Select All Dependent Tables	Include all dependent tables
   Deselect All Dependent Tables	Exclude all recursive referenced tables
   Select All Dependent Tables	Include all recursive referenced tables
   Deselect All Referenced Tables	Exclude all referenced tables
   Select All Referenced Tables	Include all referenced tables

5. From the Browse window, select the tables to restore and click Recover All Selected.

   The Table Restore Options dialog box appears.

6. On the General tab, select the Oracle RAC pseudo client from the Destination Client list.

7. On the Stream tab, select a physical Oracle RAC node. Click the Stream column and type the number of streams that the Commvault software uses for the restore.

8. On the Table Restore tab, in the Staging Path box, type the path on the Oracle RAC physical client where the auxiliary instance is created.

9. On the Advanced Options tab:

   1. Select the Import to a Different DB check box.

   2. In the Select a Client list, select a non-Oracle RAC client.

   3. In the Enter Import Oracle Instance box, type the destination instance name.

      Note: this must be the same as the Oracle RAC client instance.

   4. To delete the existing tables on the destination before the restored tables are imported, select the Drop Table for Import check box.

10. Optional: Export table procedures and table additional parameters.

    Select the Use additional export parameters check box and type the parameters to export.

    When you restore Oracle tables, you can restore table objects other than triggers, constraints, indexes, and grants.

    Note: Stored procedures are restored from the schema level. If one table within the schema is selected for restore, all the stored procedures for that schema are restored.

    The object export uses the Data Pump Export utility. If your Oracle version does not support the Data Pump Export utility, you cannot include stored procedures when you export tables.

11. Click OK to close the Table Restore Options dialog box.