Loading...

Deleting Existing Tables during an Oracle RAC Restore

By default, the restore operation will overwrite the existing tables in the destination database during the restore. You can also configure the restore operation to delete the existing tables before performing the restore.

Manually drop/delete the existing tables at the destination instance and then import the tables.

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

Procedure

  1. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.
  2. Select Latest Backup check the Table View check box and click View Content.
  3. Select the tables and click Recover All Selected.
  4. On the Table Restore Options dialog box, navigate to the Table Restore tab.
    • In the Staging Path box, type the location where the auxiliary instance will be created.
  5. On the Table Restore Options dialog box, navigate to the Advanced tab.
    • In the Staging Path box, type the location where the auxiliary instance will be created.
    • Select Import to Source DB option.
    • Select the Drop Table for Import check box.
  6. Click OK.

Last modified: 9/12/2018 6:25:35 PM