Restore and Recover Your Autonomous Transaction Processing Dedicated Database

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

  1. Go to the Details page of the Autonomous Transaction Processing dedicated database you want to restore and recover.


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

    For instructions, see View Details of an Autonomous Transaction Processing Dedicated Database.

  2. On the Details page, select Actions and then select Restore.
  3. In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
    • SPECIFY TIMESTAMP: Enter a timestamp to restore to in the ENTER TIMESTAMP calendar field.
    • SELECT BACKUP: Select a backup from the list of backups. Limit the number of backups you see by specifying a period using the FROM and TO calendar fields.
  4. Click Restore.


    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.


  • 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 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.