Restoring from the Most Recent Backup

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

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

Note:

Currently, using the console to restore from the most recent backup is not supported for database deployments hosting an Oracle Data Guard configuration.

1. Go to the Backup page of the deployment you want to restore and recover:

   1. Open the Oracle Database Classic Cloud Service console.

      For detailed instructions, see Accessing the Oracle Database Classic Cloud Service Console.

   2. Click the database deployment you want to restore and recover.

      The Oracle Database Classic Cloud Service Overview page is displayed.

   3. Click the Administration tile.

      The Oracle Database Classic 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 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 from the Most Recent Backup

• You can use the dbaascli utility on database deployments hosting a single-instance database. See Restoring from the Most Recent Backup by Using the dbaascli Utility.

• You can use the raccli utility on database deployments hosting an Oracle Real Application Clusters (RAC) database. See Restoring from the Most Recent Backup by Using the raccli Utility.

Restoring from the Most Recent Backup by Using the dbaascli Utility

You can use the dbaascli utility to restore from the most recent backup and perform complete recovery on a database deployment hosting a single-instance database:

Note:

Beginning in version 18.4.6, the default behavior of the dbaascli orec subcommand changed. The command now downloads only the backup data. Use the new -cfgfiles option to also download the configuration files.

1. Connect as the opc user to the compute node.

   For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

2. Start a root-user command shell:

   $ sudo -s
   #

3. Restore the most recent backup and perform complete recovery using the orec subcommand of the dbaascli utility:

   # dbaascli orec --args -latest
   

   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 instance after recovery

4. Exit the root-user command shell:

   # exit
   $

Restoring from the Most Recent Backup 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 the most recent backup and perform complete recovery on a database deployment hosting an Oracle Real Application Clusters (RAC) database:

1. Connect as the opc user to the compute node.

   For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

2. Restore the most recent backup and perform complete recovery using the create recovery subcommand of the raccli utility:

   $ raccli create recovery -latest
   

   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 instances after recovery