Restoring from a Specific Backup

Note:

Currently, restoring from a specific backup is not supported for database deployments that use Oracle Real Application Clusters (RAC).

You can restore a specific backup and perform recovery to that backup 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 a Specific Backup at the end of this topic.

Restoring from a Specific Backup by Using the Oracle Database Cloud Service Console

Note:

Currently, using the console to restore from a specific 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. In the list of backups, locate the backup you want to restore from.

  3. Click the action menu (Menu icon) that is associated with the backup you want to restore from. Choose Recover and then confirm the action.

    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 a Specific Backup

Restoring from a Specific Backup by Using the dbaascli Utility

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.

You can use the dbaascli utility to restore from a specific backup and perform recovery to that backup on a database deployment hosting a single-instance database or a Data Guard configuration of single-instance databases.

  1. Connect as the opc user to the compute node. In a Data Guard configuration, connect to the compute node hosting the primary database.
  2. Start a root-user command shell:
    $ sudo -s
    #
  3. List the available backups using the orec subcommand of the dbaascli utility.
    • For normal backups:

      # dbaascli orec --args -list
      

      A list of available backups displays; for example:

      Backup Tag          Completion Tag       Config File Location
      --------------------------------------------------------------------
      TAG20140626T191645  06/26/2014 19:16:45
      
      TAG20140626T195118  06/26/2014 19:51:18  .../ORCL/oscfgfiles/2014_06_26/oscfgfiles_20140626_1951.tar.gz
                                               .../ORCL/ohcfgfiles/2014_06_26/ohcfgfiles_20140626_1951.tar.gz
      
      Config files relative path to: /u03/app/oracle/fast_recovery_area
      
    • For long-term backups:

      # dbaascli orec --args -keep -list
      

      A list of available long-term backups displays; for example:

      TAG20120117T065489
      TAG20110117T077324
      TAG20100117T023955
      
  4. Restore the specific backup you want using the orec subcommand:
    • For normal backups:

      # dbaascli orec --args -pitr backup-tag
      
    • For long-term backups:

      # dbaascli orec --args -keep -tag backup-tag
      

    where backup-tag is the tag of the backup you want to restore.

    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

    In a Data Guard configuration, after the restore and recovery operation is complete, a message indicating that you need to run the duplicate command on the standby instance is displayed. Perform all of the following steps to complete the operation on the standby database. In a single-instance database you only need to perform the next step.

  5. Exit the root-user command shell and disconnect from the compute node:
    # exit
    $ exit
  6. In the Data Guard configuration, connect to the standby instance's compute node as the opc user.
  7. Start a root-user command shell:
    $ sudo -s
    #
  8. Run the duplicate option of orec.
    # dbaascli orec --args -duplicate
    
  9. Exit the root-user command shell and disconnect from the compute node:
    # exit
    $ exit