JavaScript must be enabled to correctly display this content
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:
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.
On Oracle Public Cloud, click
Restore under More actions,
and on Exadata Cloud@Customer, click
Restore under Actions.
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.
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.
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.