HOW TO CHECK WHETHER PHYSICAL STANDBY IS IN SYNC WITH THE PRIMARY OR NOT AND RESOLVED GAP ?

Updated: Feb 9, 2020

Step by Step Process to Resolve gap on the Standby database.

Summary 1. Check the name and status of database. 2. Check for GAP on standby 3. Check redo received on standby 4. Check redo applied on standby 5. Identify missing archive log files 6. Copy archive log files 7. Register archive log files with standby 8. Restart the managed recovery operations

*********************************************************************************************************

Step 1: Check the status of the database on both servers. On Primary Server.

SQL> select name, open_mode, database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ———- —————- MYDB READ WRITE PRIMARY