Restoring from the Most Recent Backup

You can restore the most recent backup and perform complete recovery 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 the Most Recent Backup at the end of this topic.

Restoring from the Most Recent Backup by Using the Oracle Database Cloud Service Console

1. 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.

2. Click Recover.

   The Database Recovery overlay is displayed.

3. In the list of recovery options, select Latest. Then, click Recover.

   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 the Most Recent Backup

• You can use the bkup_api utility. See Restoring from the Most Recent 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 the Most Recent Backup by Using the bkup_api Utility

You can use the bkup_api utility to restore from the most recent backup and perform complete recovery on a complete database, or recover a specific pluggable database (PDB):

1. 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).

2. Start a root-user command shell:

   $ sudo -s
   #

3. Enter the following bkup_api command:

   # /var/opt/oracle/bkup_api/bkup_api recover_start --latest --dbname=dbname
   

   where 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.

4. 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
   

5. Exit the root-user command shell and disconnect from the compute node:

   # exit
   $ exit