One of my Dataguard Server is out of sync and even its is resolvable gap but i want to know the error which causing the issue. So that i know the root cause to avoid that problem in future.
Error
select status,gap_Status from v$archive_Dest_Status where dest_id=2;STATUS GAP_STATUS--------- ------------------------ERROR RESOLVABLE GAP Solution: To get the error detail:
SELECT dest_id, status, error, destinationFROM v$archive_destWHERE dest_id = 2;Check detailed status
SELECT dest_id, status, gap_status, errorFROM v$archive_dest_statusWHERE dest_id = 2;Check managed recovery
SELECT process, status, sequence#FROM v$managed_standby;RESOLVABLE GAP:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;