isitdevops.com/databases

DGMGRL> SHOW DATABASE ‘pc00prmy’ ‘StatusReport’;
DGMGRL> SHOW DATABASE ‘pc00prmy’ ‘LogXptStatus’;
DGMGRL> SHOW DATABASE ‘pc00prmy’ ‘InconsistentProperties’;
DGMGRL> SHOW DATABASE ‘pc00prmy’ ‘InconsistentLogXptProps’;
DGMGRL> SHOW CONFIGURATION;
DGMGRL> SHOW DATABASE ‘pc00prmy’;
DGMGRL> SHOW DATABASE verbose ‘pc00prmy’;

SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE WHERE TYPE = ‘STANDBY’;
SQL> SELECT GROUP#, DBID, ARCHIVED, STATUS FROM V$STANDBY_LOG;
if archived=yes and status=active, redo log is currently being written to.
if archived=no and status=active, redo log is waiting to be archived.
SQL> SELECT DEST_ID, VALID_TYPE, VALID_ROLE, VALID_NOW FROM V$ARCHIVE_DEST;

TRACE

ALTER SYSTEM SET LOG_ARCHIVE_TRACE=trace_level, trace is written to the DIAGNOSTIC_DEST location.
trace level:
0=disabled
1=track archiving of redo logs
2=tracks archival status per archived redo log destination
4=track archival operational phase
8=tracks archived redo log destination activity
16=tracks detailed archived redo log destination activity
32=tracks archived redo log destination parameter modifications
64=tracks ARCn process state activity
128=tracks FAL server process activity
256=reserved
512=tracks async LGWR activity
1024=tracks RFS physical client
2048=tracks ARCn or RFS heartbeat
4096=tracks real-time apply activity
8192=tracks redo apply activity (media recovery or physical standby)

SELECT PROCESS, STATUS, GROUP#, THREAD#, SEQUENCE# FROM V$MANAGED_STANDBY ORDER BY PROCESS, GROUP#, THREAD#, SEQUENCE#;

SELECT NAME, VALUE, TIME_COMPUTED FROM V$DATAGUARD_STATS;

SELECT TIMESTAMP, FACILITY, DEST_ID, MESSAGE_NUM, ERROR_CODE, MESSAGE FROM V$DATAGUARD_STATUS ORDER BY TIMESTAMP;

SELECT PRIMARY_XID, TYPE, MINIG_STATUS, APPLY_STATUS FROM V$LOGSTDBY_TRANSACTION;