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:
1. Open the Oracle Database Cloud Service console.
  
  For detailed instructions, see Accessing the My Services Dashboard and the Oracle Database Cloud Service Console.
2. Click the database deployment you want to restore and recover.
  
  The Oracle Database Cloud Service Overview page is displayed.
3. 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, where pdbname 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 and dbname 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, where pdbname 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 following bkup_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
```