Use the following steps to restore tables to a different database on the same host.
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.
In order to successfully import the tables, you must have a user that has the dba privilege, or the user must own the full table. You cannot have a user with the sysbackup privilege for the import.
On Windows configurations, the Oracle home user that you use for the Oracle instance must have the same credentials and password as the local administrator, when the local administrator is configured for the Commvault Oracle instance properties.
Before You Begin
Add the destination instance name to the Listener.ora and Tnsnames.ora files.
Procedure
-
From the CommCell Browser, expand Client Computers > client > Oracle RAC.
-
Right-click the instance, point to All Tasks, and then click Browse and Restore.
-
Select Latest Backup, select the Table View check box, and then click View Content.
-
Select the tables and click Recover All Selected.
-
On the Table Restore Options dialog box, on the Table Restore tab, in the Staging Path box type the location where the auxiliary instance will be created.
-
On the Table Restore Options dialog box, navigate to the Advanced Options tab.
-
Select the Import to a different DB option.
-
In the Enter Import Oracle Instance: box, type the destination instance name.
-
In the Select a Client box, select the source client.
-
-
Click OK.