> CommCell Console > Backup and Restore Agents > Archive Agents > Database Archive > Oracle Database Archiving > Oracle Archiving Restores > Restores of Archives in the Native Format or Parquet Format

Restoring Oracle Archives Using a Different Destination (Staging) Database

Applies to: Archives that are in the native format or parquet format

You can restore the data to the source (production) database by using a staging database instead of the archive database.

You can use any of the following databases as the destination:

  • The archive database

  • The production database

  • A database other than the archive or production database

There may be times when all parent tables must be in the restore.

Note

When you have an archive in the parquet format, the number of archived rows that the browse window displays is equal to the rows that match the archive criteria, and any additional rows that are selected as part of the foreign key relationship.

Before You Begin

  1. Ensure that all the archive database prerequisites are met. For more information, see Prerequisites.

  2. Configure an instance on the staging database. For more information, see Instances for Oracle.

Procedure

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

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

    The Browse and Restore Options dialog box appears.

  3. Click View Content.

  4. On the Current Selected pane, select the data that you want to restore.

    • To restore one data version, select the table to restore in the right pane and click Recover All Selected.

    • To restore multiple data versions:

      1. Right click the table to restore in the right pane and select View All Versions.

      2. On the All versions of dialog box.

      3. To restore all listed versions, click Restore All.

      4. To restore a particular version, select the version and click Restore.

    The Restore Options dialog box appears.

  5. On the General tab, provide the destination host information:

    1. From the Destination Client list, select the staging database host.

    2. From the Database Name list, select the staging database name.

    3. In the Connect Details boxes, type the string that you use to connect to the staging database.

    4. To redirect the data, in the Redirect Path box, type the new path.

      Note: This is mandatory when you restore a backup that has the Parquet format.

  6. If the archive is in the native format, do the following:

    1. Click Advanced.

      The Advanced Restore Options dialog box appears.

    2. On the Import Options tab, specify the restore options:

      • To restore the data to the source (production) table, select the Import data into source table check box.

      • To include all parent tables, select the Include all parent tables in the restore check box.

      • To include all child tables, select the Include all child tables in the restore check box.

    3. Click OK.

      The Restore Options dialog box appears.

  7. On the Job Initiation tab, specify whether to run the restore now or if it will be scheduled.

    Note: If you selected Schedule, set up the schedule.

    For information on configuring a restore schedule, see Schedule Restore.

  8. Click OK to close the Restore Options dialog box.

Page contents

×

Loading...