Check Dataguard found Log Switch gap status in Oracle

 

Found Log Switch Gap status in archive dest status

We are planning to switch-over the database from primary to secondary in Data guard environment. When we are checking the status of following view which tell us that we are good to go and database is in sync state.

In one status we are getting LOG SWITCH GAP instead of NO GAP.


-- On primary site
Select status,gap_status from v$archive_dest_status where dest_id=2;

STATUS GAP_STATUS
------ --------------------
VALID LOG SWITCH GAP


Solution
To make this status to NO GAP, we have to fire the switch logfile command.

Alter system switch logfile;


Verify the status after switch logfile:

Select status,gap_status from v$archive_dest_status where dest_id=2;

STATUS  GAP_STATUS
------  --------------------
VALID   NO GAP