When restoring tables to a different host, ensure the following:
-
Both the source and the destination host should have the same database schema.
-
Add the duplicate database instance name in the Listener.ora file on the destination host and Tnsnames.ora files on the destination and source hosts.
-
Add the source database name in the Tnsnames.ora file on the destination host.
-
Ensure that both the source and destination clients use a different connection name in the tnsnames.ora file.
For example:
// db1_table = <--- Name of the source database``db1_table =``(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = M1)(PORT = 1521))``(CONNECT_DATA =``(SERVER = DEDICATED)``(SERVICE_NAME = db1)``)``)``//db1 = <--- Name of the destination database``db1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = M2)(PORT = 1521))``(CONNECT_DATA =``(SERVER = DEDICATED)``(SERVICE_NAME = db1)``)``)
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
Add the destination instance name in 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, navigate to the Table Restore tab, then 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 destination client.
-
-
Click OK.