How To Restore an Oracle Autonomous Database?

Hello,

In this blog post, I will describe how to restore an Autonomous Database from a backup using the Oracle Cloud Infrastructure Console. You can use any existing manual or automatic backup to restore your database, or you can restore and recover your database to any point in time in the 60-day retention period of your automatic backups. For point-in-time restores, you specify a timestamp, and your database decides which backup to use for the fastest restore/recovery.

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, find the database that you wish to restore.
4- Click the name of the Autonomous Database to display the database details.
5- Click the Restore button to open the restore dialog.

5- Click Select Backup.
6- Specify the date range for a list of backups to display.
7- Click Restore.
8- In the Autonomous Database detail page you can monitor the status of restore operation.

9- Click “Restore Autonomous Database” link under Work Request.

10- You can see log messages of restore process.

Let me show the necessary steps of an Autonomous Database using point-in-time restore.

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, find the database that you wish to restore.
4- Click the name of the Autonomous Database to display the database details.
5- Click the Restore button to open the restore dialog.
6- Click Specify Timestamp.
7- Enter a timestamp. Your Autonomous Database decides which backup to use for faster recovery. The timestamp input allows you to specify precision to the seconds level (YYYY-MM-DD HH:MM:SS GMT).

8- Click Restore.