High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

switchover_status is RESOLVABLE GAP but there are no gaps and redo is being applied

Our 12.1.0.2.0 physical standby database was down for about 5 days and after starting it back up it and after a few hours I checked the status. Everything appears to be caught up with redo applying and all archive redo logs transferred to the physical standby database. The following query shows a status of RESOLVABLE GAP (query is run on primary database):

select switchover_status from v$database;

There are no errors and no gaps anywhere except from the switchover status. I've tried restarting the redo apply services on the physical standby and switched log files various times. I'm not sure how to get from RESOLVABLE GAP to TO STANDBY.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center