> 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

Performing a Point-in-Time Restore of an Oracle Archive

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

Use a point-in-time restore to revert the database to a state before an undesired transaction or before a point of failure.

This procedure restores the archive to a database.

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.

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 then click Restore.

    The Restore Options dialog box appears.

  5. On the General tab:

    1. From the Destination client list, select the client.

    2. From the Database Name list, select the 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, select the Import data into source table 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...