Restoring to a Specific Point in Time
You can restore from a backup and perform recovery to a specific point in time on an Oracle Database Classic Cloud Service database deployment by using the Oracle Database Classic Cloud Service console or, if desired, by using one of the ways listed in Other Ways to Restore to a Specific Point in Time at the end of this topic.
Restoring to a Specific Point in Time by Using the Oracle Database Classic Cloud Service Console
Note:
Currently, using the console to restore to a specific point in time is not supported for database deployments hosting an Oracle Data Guard configuration.
-
Go to the Backup page of the deployment you want to restore and recover:
-
Open the Oracle Database Classic Cloud Service console.
For detailed instructions, see Accessing the Oracle Database Classic Cloud Service Console.
-
Click the database deployment you want to restore and recover.
The Oracle Database Classic Cloud Service Overview page is displayed.
-
Click the Administration tile.
The Oracle Database Classic Cloud Service Backup page is displayed.
-
-
Click Recover.
The Database Recovery overlay is displayed.
-
In the list of recovery options, select Date and Time or System Change Number (SCN) to indicate how you want to specify the end point of the recovery operation. Then, enter the appropriate value.
Note:
If specified, the recovery date and time values are subject to the UTC time zone. -
Click Recover.
The restore and recover process performs these steps:
-
Shuts down the database
-
Extracts and restores configuration files
-
Prepares for recovery
-
Performs the recovery
-
Restarts the database after recovery
-
Other Ways to Restore to a Specific Point in Time
-
For database deployments hosting single-instance databases, you can use the
dbaascli
utility. See Restoring to a Specific Point in Time by Using the dbaascli Utility. -
For database deployments hosting Oracle Real Application Clusters (RAC) databases, you can use the
raccli
utility. See Restoring to a Specific Point in Time by Using the raccli Utility.
Restoring to a Specific Point in Time by Using the dbaascli Utility
Note:
Beginning in version 18.4.6, the default behavior of thedbaascli orec
subcommand changed. The command now downloads only the backup data. Use the new -cfgfiles
option to also download the configuration files.
You can use the dbaascli
utility to restore from a backup and perform recovery to a specific point in time on a database deployment hosting a single-instance database or a Data Guard configuration.
Restoring to a Specific Point in Time by Using the raccli Utility
This topic does not apply to Oracle Cloud Infrastructure or to Oracle Cloud at Customer.
You can use the raccli
utility to restore from a backup and perform recovery to a specific point in time on a database deployment hosting an Oracle Real Application Clusters (RAC) database: