_____________________________________________________________________________________

Configuring Oracle Data Guard:
http://docs.oracle.com/cd/E11882_01/server.112/e10803/config_dg.htm#HABPT4876
_____________________________________________________________________________________

--- alter create drop
_____________________________________________________________________________________

set pages 1000
set lines 200
_____________________________________________________________________________________

GENERAL INFO
============
v$database: https://docs.oracle.com/cd/E18283_01/server.112/e17110/dynviews_1096.htm

select protection_mode, protection_level, remote_archive, activation#, switchover#, database_role, switchover_status, dataguard_broker, guard_status, force_logging from v$database;


WHO AM I?
=========
column inst_num  heading "Inst Num"   new_value inst_num  format 99999;
column inst_name heading "Instance"   new_value inst_name format a12;
column db_name   heading "DB Name"    new_value db_name   format a12;
column db_uname  heading "Uniqe Name" new_value db_name   format a12;
column dbid      heading "DB Id"      new_value dbid      format 9999999999 just c;

prompt
prompt Current Instance
prompt ~~~~~~~~~~~~~~~~

select d.dbid            dbid
     , d.name            db_name
     , d.db_unique_name  db_uname
     , i.instance_number inst_num
     , i.instance_name   inst_name
  from v$database d,
       v$instance i;


MISCELLANEOUS
=============
select
   d.name,
   d.db_unique_name,
   d.database_role,
   d.open_mode,
   d.log_mode,
   d.dataguard_broker,
   d.guard_status,
   d.flashback_on
   
  from v$database d
;

OR...

col DB_INFO for a50
select 
   'DB-Name.........: ' || name                || chr(10) ||
   'DB-Unique-Name..: ' || db_unique_name      || chr(10) ||
   'DB-Role.........: ' || database_role       || chr(10) ||
   'Open-Mode.......: ' || open_mode           || chr(10) ||
   'Log-Mode........: ' || log_mode            || chr(10) ||
   'DataGuard-Broker: ' || dataguard_broker    || chr(10) ||
   'DataGuard-Status: ' || guard_status        || chr(10) ||
   'Flashback-ON....: ' || flashback_on "DB_INFO"
  from v$database;
_____________________________________________________________________________________

Monitoring Redo Transport Services
http://docs.oracle.com/cd/B28359_01/server.111/b28294/log_transport.htm#BABDGGID

PRIMARY & STANDBY
=================
select max(sequence#) from v$archived_log where dest_id=1;

select max(sequence#), thread# from v$archived_log group by thread#;


PRIMARY
=======
select destination, status, archived_thread#, archived_seq#
from v$archive_dest_status
where status <> 'DEFERRED' and status <> 'INACTIVE';


STANDBY
=======
select local.thread#, local.sequence# from
(select thread#, sequence# from v$archived_log where dest_id=1)
local where
local.sequence# not in
(select sequence# from v$archived_log where dest_id=2 and thread# = local.thread#);
_____________________________________________________________________________________

HOW TO CHECK IF ACTIVE DATA GUARD IS ALREADY ENABLED
====================================================
select 'Using Active Data Guard' ADG
  from v$managed_standby m,
       v$database d
 where m.process like 'MRP%'
   and d.open_mode='READ ONLY';