Oracle DataGuard Tips

# Data Gard Issue (Find DB name from primary)
show parameter log_archive_config
archive log list
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
select * from v$dataguard_config;
SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM GV$DATABASE;

set pages 1000
set lines 120
column DEST_NAME format a20
column DESTINATION format a35
column ARCHIVER format a10
column TARGET format a15
column status format a10
column error format a15
select DEST_ID,DEST_NAME,DESTINATION,TARGET,STATUS,ERROR from v$archive_dest
where DESTINATION is NOT NULL;

set linesize 250
column sequence# format 999999999
column name format a100
column applied format a3
column thread# format 9
SELECT thread#,SEQUENCE#,name,APPLIED FROM V$ARCHIVED_LOG where next_time > (sysdate-5/7) order by first_time asc;