Restoring from the Most Recent Backup

You can restore the most recent backup and perform complete recovery on an Oracle Database 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

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 Cloud Service console.

      For detailed instructions, see Accessing 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 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

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

Not Oracle Cloud InfrastructureNot Oracle Cloud at Customer 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.
  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