Data Guard
How to list applied archivelogs on an Oracle Data Guard standby
List archivelogs marked applied on an Oracle Data Guard standby with thread, sequence, and time range from GV$ARCHIVED_LOG.
How to stop managed recovery (MRP) on an Oracle Data Guard standby
Cancel Oracle Data Guard managed recovery (MRP) on a physical standby with ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL.
How to start managed recovery (MRP) on an Oracle Data Guard standby
Start Oracle Data Guard managed recovery (MRP) in real-time apply mode with USING CURRENT LOGFILE DISCONNECT.
How to check Data Guard status messages and recent errors in Oracle
Read Oracle Data Guard status messages from V$DATAGUARD_STATUS, filtered to the last 10 minutes for quick incident triage.
How to check Data Guard transport and apply lag in Oracle
Show Oracle Data Guard transport lag and apply lag values from V$DATAGUARD_STATS.
How to check the redo apply gap on an Oracle Data Guard standby
Compare last received vs last applied sequence per thread on an Oracle Data Guard standby, with RAC-aware host and timestamp variants.
How to check the archive log gap on an Oracle Data Guard standby
List missing archivelog sequences on an Oracle Data Guard standby from V$ARCHIVE_GAP.
How to check Data Guard apply rate in Oracle
Show the current active and average redo apply rate (MB/sec) from V$RECOVERY_PROGRESS on an Oracle Data Guard physical standby.
How to check Oracle Data Guard parameters
Show the Oracle Data Guard-related init.ora parameters — LOG_ARCHIVE_DEST_n, FAL_SERVER, FAL_CLIENT, name conversions, and standby file management.
How to check managed standby process status in Oracle Data Guard
Show Oracle Data Guard managed standby processes (MRP, RFS, LNS, ARCH) with status, thread, sequence, and current block from V$MANAGED_STANDBY.
How to check standby redo log groups in Oracle Data Guard
List Oracle standby redo log groups with sequence, size, and member paths from V$STANDBY_LOG.