Wednesday, December 31, 2014

11g DATAGURARD BROKER DGMGRL CONFIGURATION STEPS

Enterprise Manager Grid Control GUI or Command line interface can be used to configure Guard Broker. The following demonstration uses the command line version.
ASSUMPTION
There exists a function physical standby database ( i.e  The redo log shipping/transport is happening and the transported logs are being applied to make the standby database in sync with the production.)
Primary Database: PROD
Standby Database: PRODSTDBY

STEP 1. ON BOTH THE PRIMARY AND STANDBY DATABASES START THE DATAGUARD BROKER PROCESS

SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;
System altered.

STEP 2. EDIT THE listener.ora ON BOTH THE PRIMARY AND STANDBY NODES TO CONTAIN THE STATIC ENTRY FOR DBMGRL

Ensure that the GLOBAL_DBNAME is set to db_unique_name_DGMGRL.db_domain
SID_LIST_LISTENER =
  (SID_LIST =
 (SID_DESC =
        (GLOBAL_DBNAME = PROD_dgmgrl)
        (ORACLE_HOME = /u01/oracle/product/11.2.0.3/db_1)
            (SID_NAME = PROD)
        )
    )

STEP 3. CREATE THE CONFIGURATION

PROD:/u01/oracle$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - 64bit Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.


Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/xxxxxxx
Connected.
DGMGRL> CREATE CONFIGURATION 'ORIGINDR'
> AS
> PRIMARY DATABASE IS 'PROD'
> CONNECT IDENTIFIER IS 'PRODSTDBY'
> ;
Configuration "ORIGINDR" created with primary database "PROD"

STEP 4. ADD THE STANDBY DATABASE TO THE CONFIGURATION

DGMGRL> ADD DATABASE
> 'PRODSTDBY'
> AS
> CONNECT IDENTIFIER IS 'PRODSTDBY'
> ;
Database "PRODSTDBY" added

DGMGRL> SHOW CONFIGURATION

Configuration

  Name:                ORIGINDR
  Enabled:             NO
  Protection Mode:     MaxAvailability
  Databases:
    PROD - Primary database
    PRODSTDBY - Physical standby database

Fast-Start Failover: DISABLED


Current status for "ORIGINDR":

DISABLED

STEP 5. ENABLE THE CONFIGURATION

DGMGRL> ENABLE CONFIGURATION
Enabled.
DGMGRL> SHOW CONFIGURATION
Configuration
  Name:                ORIGINDR
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Databases:
    PROD - Primary database
    PRODSTDBY - Physical standby database

Fast-Start Failover: DISABLED


Current status for "ORIGINDR":

SUCCESS

No comments:

Post a Comment