How to resolve archivelog gap || Physical Standby || Oracle DataGuard || Oracle DBA

In this tutorial we are going to show about Oracle standby database archive log gap resolving

Task-01:Check DB Name and Database role both DC & DR

SELECT NAME,
OPEN_MODE,
DATABASE_ROLE
FROM v$database;

Task-02:Check current status of database environment

SELECT client_process,
process,
sequence#,
status
FROM v$managed_standby;

Task-03:Check error in data guard environment

SELECT DEST_NAME,
STATUS,
DATABASE_MODE,
ARCHIVED_SEQ#,
APPLIED_SEQ#,
ERROR,
GAP_STATUS
FROM v$archive_dest_status
WHERE dest_id = 3

[narendrastudy]

Explanation is good, but don't use background music, it's not value adding anything to the knowledge. We are here to learn something, background music is most distracting thing