Posts

Showing posts from February, 2022

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 ----------...