Restore and Recover Autonomous Database on Dedicated Exadata Infrastructure

You can restore and recover an Autonomous Database on Dedicated Exadata Infrastructure from its Details page.

Note:

In an Autonomous Data Guard setup, database restore is not allowed if the standby database is in snapshot standby role. You must convert the standby Autonomous Container Database (ACD) to physical standby role to restore this database. See Convert Snapshot Standby to Physical Standby for instructions.

To restore and recover your database to a point in time, do the following:

Required IAM Policies

use autonomous-databases

read autonomous-backups

Procedure

To restore and recover your database, do the following:

  1. Go to the Details page of the Autonomous Database you want to restore and recover.

    Note:

    For databases that use Autonomous Data Guard, go to the Details page of the primary database.

    For instructions, see View Details of an Autonomous Database on Dedicated Exadata Infrastructure.

  2. On Oracle Public Cloud, click Restore under More actions, and on Exadata Cloud@Customer, click Restore under Actions.
  3. In the Restore prompt, choose from the following options:
    • Enter Timestamp: Choose this option if you want to restore a backup with a specific timestamp.

      After selecting this option, you must enter the timestamp in the Enter Timestamp field.

    • Select Backup: This option lets you select a backup from the list of backups. You can limit the number of backups you see by specifying a period using the From and To calendar fields.

      After selecting this option, you must select a backup from the list that shows up.

    • Enter SCN: Choose this option if you want to restore the database to a specific System Change Number (SCN). After selecting this option, you must enter the SCN in the Enter SCN field.
  4. Click Restore.

    Note:

    Restoring a database puts it in the unavailable state during the restore operation. You cannot connect to the database in this state. The only lifecycle management operation supported in unavailable state is terminate.

    The Details page shows Lifecycle State: Restore In Progress.

  5. When the restore operation finishes your database is opened in the same state as before restoration. For all three types of restore (by SCN, by timestamp or by using specific backup) an SCN will be returned when the restore is completed.

Note:

  • When your database is restored, the value of the ADMIN user password is also restored. Therefore, it may have an old value that you no longer remember. You can set the password to a new value as described in Unlock or Change the ADMIN Database User Password.
  • After restoring your database, all backups between the date the restore completes and the date you specified for the restore operation - the restore time - are invalidated. You cannot initiate further restore operations to any point in time between the restore time and restore completion time. You can only initiate new restore operations to a point in time older than the restore time or more recent than the time when the actual restore succeeded.

Related Topics