Restoring from a Specific Backup
You can restore a specific backup and perform recovery to that backup on an Oracle Database Exadata Cloud Service database deployment by using the Oracle Database Cloud Service console or, if desired, by using one of the ways listed in Other Ways to Restore from a Specific Backup at the end of this topic.
Restoring from a Specific Backup by Using the Oracle Database Cloud Service Console
-
Go to the Backup page of the deployment you want to restore and recover:
-
Open the Oracle Database Cloud Service console.
For detailed instructions, see Accessing the My Services Dashboard and the Oracle Database Cloud Service Console.
-
Click the database deployment you want to restore and recover.
The Oracle Database Cloud Service Overview page is displayed.
-
Click the Administration tile.
The Oracle Database Cloud Service Backup page is displayed.
-
-
In the list of backups, locate the backup you want to restore from.
-
Click the action menu (
) that is associated with the backup you want to restore from. Choose Recover and then confirm the action.
The restoration and recovery process performs these steps:
-
Shut down the database
-
Prepare for recovery
-
Perform the recovery
-
Restart the database after recovery
-
Other Ways to Restore from a Specific Backup
-
You can use the
bkup_api
utility. See Restoring from a Specific Backup by Using the bkup_api Utility. -
You can use Oracle Recovery Manager (RMAN) to manually restore a database on Exadata Cloud Service. See Manually Restoring from a Backup.
Restoring from a Specific Backup by Using the bkup_api Utility
You can use the bkup_api
utility to restore and recover using a specific backup of a complete database or a specific pluggable database (PDB):
-
Connect as the
opc
user to a compute node that is associated with the database deployment. In a Data Guard configuration, connect to the compute node hosting the primary database.For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).
-
Start a root-user command shell:
$ sudo -s #
-
List the available backups by using the following
bkup_api
command:# /var/opt/oracle/bkup_api/bkup_api list --dbname=dbname
where
dbname
is the database name for the database that you want to recover.If you want to list the available backups for a specific PDB, then add the
––pdb=pdbname
option, wherepdbname
is the PDB name. -
Commence the recovery by using the following
bkup_api
command:# /var/opt/oracle/bkup_api/bkup_api recover_start -b backup-tag --dbname=dbname
where
backup-tag
is the tag for the specific backup that you want to use anddbname
is the database name for the database that you want to recover.If you want to recover a specific PDB, then add the––pdb=pdbname
option, wherepdbname
is the PDB name.Note:
-
It is recommended to perform a complete database backup after every PDB recovery.
-
PDB recovery does not restore database files (control files, spfiles, data files and so on). Therefore, if a file is missing you must recover the entire database.
If you want to restore system and database configuration files included in the backup, then add the
--cfgfiles
option. Without this option, only the database is restored. -
-
After you enter a
bkup_api recover_start
command, the recovery process runs in the background. To check the progress of the recovery process, enter the followingbkup_api
command:# /var/opt/oracle/bkup_api/bkup_api recover_status --dbname=dbname
-
Exit the root-user command shell and disconnect from the compute node:
# exit $ exit