How to setup Active Dataguard and Dataguard Broker
Primary Database : TIGGER DBNAME : TIGGER DB UNIQUE NAME : TIGGER Instances : TIGGER on dgprm.racattack Oracle Home: /u01/app/oracle/product/12.1.0/dbhome_1 GRID Homes: /u01/app/oracle/product/12.1.0/grid Standby Database : TIGGER_STBY DBNAME : TIGGER DB UNIQUE NAME : TIGGER_STBY Instances : TIGGER on dgstby.racattack Oracle Home: /u01/app/oracle/product/12.1.0/dbhome_1 GRID Homes: /u01/app/oracle/product/12.1.0/grid --************************************************* -- Information about Primary Database: --************************************************* set linesize 1000 column host_name format a15 select host_name, instance_name, INSTANCE_ROLE, archiver, version, status, database_status from v$instance / HOST_NAME INSTANCE_NAME INSTANCE_ROLE ARCHIVE VERSION STATUS DATABASE_STATUS --------------- ---------------- ------------------ ------- ----------------- ------------ ----------------- dgprm.racattack tigger PRIMARY_INSTANCE