> CommCell Console > Backup and Restore Agents > Databases > Oracle RAC > Oracle RAC Restore Operations > Restoring Database Tables

Restoring Oracle RAC Tables Using a User-Defined Auxiliary Instance When the Selected Client Is Not the Source

When the database client selected is different than the source database, select the auxiliary instance and provide a user-defined auxiliary database name. If you do not do this, the auxiliary database will be created on the source client itself and ignore the database client provided.

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.

Setting up the Auxiliary Instance

  1. Copy the init<SID>.ora file from the source database to the auxiliary database instance.

  2. Update the database name and the database file locations in the init<SID>.ora file for the auxiliary database instance.

  3. Add the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters in the init<SID>.ora file. These parameters will redirect the datafiles, temp files, and log files to the auxiliary instance. 

    Windows Clients:
DB_FILE_NAME_CONVERT=('sourcE_of_df_path/','dup_of_df_path/
','source_of_temp_path/','dup_of_temp_path/',...) 
LOG_FILE_NAME_CONVERT=('source_of_log_path/redo','dup_of_log_path/redo') 
UNIX Clients:
DB_FILE_NAME_CONVERT=(source_of_df_path/,dup_of_df_path/
,source_of_temp_path/,dup_of_temp_path/,...) 
LOG_FILE_NAME_CONVERT=(source_of_log_path/redo,dup_of_log_path/redo)

  4. Add the log_archive_dest_1 parameter is added to the init<SID>.ora file on the auxiliary instance.

  5. Restart the Oracle services, if using Windows clients.

  6. Add the destination instance name in the Listener.ora and Tnsnames.ora files. If using a different host, 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. Also, add the original database name in the Tnsnames.ora file on the destination host. 

    DUPDB = (DESCRIPTION = 
(ADDRESS = (PROTOCOL = TCP)(HOST = $[powerpc02])(PORT = $[1521])) 
(CONNECT_DATA = (SERVER = DEDICATED) 
(SERVICE_NAME =$[dupdb]) (UR=A) ) )

  7. Restart the Listener. 

    $lsnrctl reload

  8. Ensure that the auxiliary instance is in NOMOUNT mode. 

    sql> startup nomount;

Procedure

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

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

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

  4. Select the tables and click Recover All Selected.

  5. On the Table Restore Options dialog box, navigate to the Table Restore tab.

    • Select the Auxiliary Instance check ox.

    • In the Database Instance box, type the auxiliary instance name.

    • In the Database Client box, select the destination client for the auxiliary instance.

    • In the PFile box, type the path to the PFile of the auxiliary instance. Alternatively, click Browse to select the path.

    • In the Staging Path box, type the location where the auxiliary instance will be created.

  6. 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 Advanced.

  7. On the Advanced Table Restore Options dialog box, navigate to the Recover tab.

    • Select the Recover check box.

    • Select Point-in-Time option and specify the time range to which the database need to be recovered.

    • In the Select a Client box, select the destination client.

    • Click OK.

  8. Click OK.

×

Loading...