Each protected database uniquely identifies an Oracle Cloud database that sends backups to Recovery Service.

When you enable automatic backups for an Oracle Cloud Database and set Autonomous Recovery Service as the backup destination, then Recovery Service creates an associated protected database resource.

Using the Console

1. Perform one of these steps to view the protected database details page:
   • On the Protected databases list page, select the protected database that you want to work with. See Listing Protected Databases for detailed steps to access the list page.
   • Open the navigation menu, select Oracle Database, select the relevant database service, and navigate to the Database information page.

     In the Backups section, select Autonomous Recovery Service in the Backup destination field.

     The Protected database details page displays the information about the protected database.

   • Review these details in the Protected database information tab.
     Protection summary

     • Health - Indicates the protection status of the database in Recovery Service. The allowed values are: Protected, Warning, and Alert.
       • A Protected status indicates that Recovery Service can ensure database recovery to any point in time within the entire recovery window, and the potential data loss exposure since the last backup is less than 10 seconds (if real-time data protection is enabled) or less than 70 minutes (if real-time data protection is disabled).
       • A Warning status indicates that Recovery Service can ensure database recovery within the current recovery window, and the potential data loss exposure since the last backup is greater than 10 seconds (if real-time data protection is enabled) or greater than 70 minutes, (if real-time data protection is disabled).
       • An Alert status indicates that Recovery Service cannot recover the database within the current recovery window, and the latest backup has failed.

       For an Active protected database, its details page automatically refreshes the Health field at an interval of one minute. This ensures that you are viewing the latest Health status.

     • Real-time protection: Indicates whether the real-time redo data is sent from the protected database to Recovery Service. Real-time data protection minimizes the possibility of data loss and enhances data protection. This is an extra-cost option.
     • Data loss exposure: Indicates the time elapsed since the last valid backup or the period of potential data loss exposure.

       For an Active protected database, its details page automatically refreshes the Data loss exposure field at an interval of one minute. This ensures that you are viewing the latest data about a potential data loss exposure.

     • Protection policy: The protection policy that defines the maximum period to retain the backups created for the database.
     • Current recovery window: Indicates how far back in time, starting from the current time, the database can be recovered. If data loss exposure occurs during the said period, then the recovery window decreases by as much. The database can be restored to any point in time, counting backward from the beginning of the data loss exposure period, if any.
     Space usage

     • Recovery window current space used: The amount of storage space that is currently used to meet the recovery window goal for the protected database.
     • Recovery window projected space used for policy: The estimated amount of storage space that is required to meet the recovery window goal as per the retention period defined in the protection policy.
     • Long-term retention current space used: If you have created long-term retention (LTR) backups for the database, then this field displays the amount of storage space that is currently used to store the LTR backups.
     • Protected database size: The size of the database that is being protected.
     Database backup summary

     • Last failed backup: The date and time of the most recent failed backup
     • Last completed backup: The date and time of the most recent successful backup
     • Last backup duration: The time taken to complete the most recent successful backup
     Protected database

     • Database details: The Oracle Cloud database that is being protected by Recovery Service. Select the link to view the associated Database Details page.
     • DB unique name: The user-specified database name and a system-generated suffix. For example: dbtst_phx1cs.
     • Database version: The Oracle database release version.
     General information

     • Subscription: The cloud provider subscription with which the protected database resource is associated. For example, this field displays the Microsoft Azure subscription information for a Oracle Database@Azure service resource linked with this protected database.
     • Backup location: Indicates the backup storage location for the protected database.

       The backup location is controlled by the Store backups in the same cloud provider as the database option in the protection policy linked with the protected database. If the option is enabled, then the protected database backups will be stored in the same cloud location as the database.

       The Backup location field displays one of these values:

       • Google Cloud - Indicates that the protected database is associated with a Oracle Database@Google Cloud service database and its backups are also stored in Google Cloud.
       • Microsoft Azure - Indicates that the protected database is associated with a Oracle Database@Azure service database and its backups are also stored in Microsoft Azure.
       • Oracle Cloud - Indicates that the protected database backups are stored in the Oracle Cloud, which is the default storage location for protected database backups.
     • OCID: Select Copy to copy the OCID of the protected database
     • Compartment: The compartment that contains the protected database resource
     • Backup configuration created: The date and time when the database was configured to backup to Recovery Service
     • Backup configuration updated: The date and time when the database backup configuration was last updated
2. Select the Monitoring tab to view the default metric charts to monitor the protected database. See, Available Metrics: oci_recovery_service for details.
3. Select the Network details tab to view the Recovery Service subnets associated with the protected database.
4. Select the Work requests tab to view the work requests associated with the protected database.
5. Select the Tags section to view the tags applied to the protected database resource item.

Using the CLI

Use the oci recovery protected-database get command and required parameters to get the details of a protected database.

See Autonomous Recovery Service CLI Command Reference for a complete list of parameters and values for CLI commands.

Using the API

Run the GetProtectedDatabase API operation to view the details of a protected database.