Viewing On-Premises Database Protection Summary

View the latest protection summary of an on-premises Oracle Database.

1. Use SQLcl to log in to the database as the SYSBACKUP user.

   /opt/oracle/sqlcl/bin/sql -name <DB_UNIQUE_NAME>_rcv_conn

   In this example, you log in to the database c1db1.

   /opt/oracle/sqlcl/bin/sql -name c1db1_rcv_conn

2. Run the rcv show database command.

   SQL> rcv show database

   Review the sample output. This sample output indicates the Protected health status for the c1db1 database.

   2025-08-15 10:42:56: DB Unique Name:    c1db1
   2025-08-15 10:42:56: Health:            Protected
   2025-08-15 10:42:56: Health Details:    Protected Database is Healthy. Last updated on Fri Aug 15 14:34:28 UTC 2025
   ...

   Note
   
   

   The protected database Health indicates one of these values:

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