<ul><li>To verify if the standby database is in sync with the primary database in Oracle 19c, follow these steps:</li><li>1. Compare Sequence Numbers: Check the latest sequence number generated on the primary database and the latest sequence number applied on the standby database.</li><li>2. Check for Gaps: Ensure there are no missing sequence numbers on the standby database.</li><li>To verify the status of the primary and standby databases:</li><li>- On the primary server, log in and run the SQL query to check the status.</li><li>- On the standby server, log in and execute the same SQL query.</li><li>To verify the gap of the standby:</li><li>- Find the last primary sequence generated.</li><li>- Identify the last standby sequence received.</li><li>- Determine the last standby sequence applied.</li><li>To identify the hostname of the DR server from the primary database:</li><li>- Run the provided query to display the DR server's hostname.</li></ul>

How to Verify Standby Database Sync with Primary Database in 19c

Discover more