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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.