Viewing the Protection Details of a Database
A protected database is an Oracle Cloud database that uses Recovery Service for backups and data protection. Use this procedure to review the details of a protected database resource.
- Log in to your OCI tenancy.
- Do one of the following to view the protected database details page:
- In the navigation menu, click Oracle Database, select the relevant database service, and navigate to the required database system page. Choose a compartment containing the database you want to view, and click the name of the required database.
In the Backup Destination field, click the Autonomous Recovery Service link.
- In the navigation menu, click Oracle Database, and select Database Backups. Under Protected Databases, find the protected database you want to access, and then click the name to display the details.
Consider the following examples:Exadata VM Clusters:Under Oracle Exadata Database Service on Dedicated Infrastructure, click Exadata VM Clusters. In the list of VM clusters, find the VM cluster you want to access and click its highlighted name to view the details page for the cluster. In the Database Details page, under Backup Destination, click Autonomous Recovery Service.
DB Systems:Under Oracle Base Database Service, click DB Systems, find the Exadata DB system you want to access, and then click its name to display details about it. In the Database Details page, under Backup Destination, click Autonomous Recovery Service .
- In the navigation menu, click Oracle Database, select the relevant database service, and navigate to the required database system page. Choose a compartment containing the database you want to view, and click the name of the required database.
- Review the fields displayed in the Protected database information section:
- 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.
- Health - Indicates the protection status of the database in Recovery
Service. The allowed values are: Protected, Warning, and Alert.
- Space usage
- Space used for recovery window: The amount of storage space that is currently used to meet the recovery window goal for the protected database.
- 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
- Next scheduled backup: The date and time of the next scheduled backup
- Protected database:
- Database details: The Oracle Cloud database that is being protected by Recovery Service. Click 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.
- Compartment: The compartment that contains the protected database.
- 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.
- OCI Show: Click Show to view the OCID of the protected database
- OCI Copy: Click 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
- Protection summary:
- Click Metrics to view the default metric charts that help you to monitor the protected database. See, Available Metrics: oci_recovery_service.
- Click Network Details to view and manage the Recovery Service subnets associated with the protected database.
- Click Work requests to view the work requests associated with the protected database.
- Select the Tags section to view the tags applied to the protected database resource item.
Parent topic: Backing Up Oracle Cloud Databases to Recovery Service