DG Broker setup


DG Broker setup by Alok

Primary Database: prim_alok
Standby Database: stanby_alok
On both Primary as well as Standby database start the Data Guard Broker process
SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;
 
System altered.
Edit the listener.ora on both nodes to add a static entry for DGMGRL
This is to prevent the ORA-12154 error which can be observed on startup of the standby database after performing a switchover.
Ensure that the GLOBAL_DBNAME is set to db_unique_name_DGMGRL.db_domain
SID_LIST_LISTENER =
  (SID_LIST =
 (SID_DESC =
        (GLOBAL_DBNAME = prim_alok_dgmgrl)
        (ORACLE_HOME = /u01/oracle/product/11.1.0/db_1)
        (SID_NAME = genoa1)
        )
)
Create the configuration
genoa1:/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/xxxx
Connected.
DGMGRL> CREATE CONFIGURATION 'GenesisDR'
> AS
> PRIMARY DATABASE IS 'prim_alok'
> CONNECT IDENTIFIER IS 'prim_alok'
> ;
Configuration "GenesisDR" created with primary database "prim_alok"
Add the Standby database to the configuration
DGMGRL>  ADD DATABASE
> 'stanby_alok'
> AS
> CONNECT IDENTIFIER IS 'stanby_alok'
> ;
Database "stanby_alok" added
 
DGMGRL> SHOW CONFIGURATION
 
Configuration
  Name:                GenesisDR
  Enabled:             NO
  Protection Mode:     MaxAvailability
  Databases:
    prim_alok - Primary database
    stanby_alok - Physical standby database
 
Fast-Start Failover: DISABLED
 
Current status for "GenesisDR":
DISABLED
Enable the configuration
DGMGRL> ENABLE CONFIGURATION
Enabled.
 
DGMGRL> SHOW CONFIGURATION
 
Configuration
  Name:                GenesisDR
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Databases:
    prim_alok - Primary database
    stanby_alok - Physical standby database
 
Fast-Start Failover: DISABLED
 
Current status for "GenesisDR":
SUCCESS
View the Standby and Primary database properties
DGMGRL> show database prim_alok
 
Database
  Name:            prim_alok
  Role:            PRIMARY
  Enabled:         YES
  Intended State:  TRANSPORT-ON
  Instance(s):
    genoa1
 
Current status for "prim_alok":
SUCCESS
 
DGMGRL>  show database stanby_alok
 
Database
  Name:            stanby_alok
  Role:            PHYSICAL STANDBY
  Enabled:         YES
  Intended State:  APPLY-ON
  Instance(s):
    genoa1
 
Current status for "stanby_alok":
SUCCESS
 
DGMGRL> show database verbose  stanby_alok
 
Database
  Name:            stanby_alok
  Role:            PHYSICAL STANDBY
  Enabled:         YES
  Intended State:  APPLY-ON
  Instance(s):
    genoa1
 
  Properties:
    DGConnectIdentifier             = 'stanby_alok'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    FastStartFailoverTarget         = ''
    StatusReport                    = '(monitor)'
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    HostName                        = 'drou037'
    SidName                         = 'genoa1'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drou037)
 
(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=stanby_alok_DGMGRL)(INSTANCE_NAME=genoa1)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    LatestLog                       = '(monitor)'
    TopWaitEvents                   = '(monitor)'
 
Current status for "stanby_alok":
SUCCESS
Change the properties of a configured databaase
DGMGRL> EDIT DATABASE 'prim_alok' SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated
Performing a switchover
Note: In this case, currently the Primary Database is stanby_alok and the Standby database is prim_alok.
DGMGRL> switchover to 'prim_alok'
Performing switchover NOW, please wait...
New primary database "prim_alok" is opening...
Operation requires shutdown of instance "genoa1" on database "stanby_alok"
Shutting down instance "genoa1"...
ORA-01109: database not open
 
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "genoa1" on database "stanby_alok"
Starting instance "genoa1"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "prim_alok"
 
DGMGRL> SHOW CONFIGURATION;
 
Configuration
  Name:                GenesisDR
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Databases:
    prim_alok - Primary database
    stanby_alok - Physical standby database
 
Fast-Start Failover: DISABLED
 
Current status for "GenesisDR":
SUCCESS
Monitoring the Data Guard Broker Configuration
If we receive any error or warnings we cab obtain more information about the same ny running the commands as shown below. In this case there is no output seen because currently we are not experiencing any errors or warning.
DGMGRL> show database prim_alok statusreport
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT
 
DGMGRL>  show database prim_alok logxptstatus
LOG TRANSPORT STATUS
PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME               STATUS
              genoa1            stanby_alok
 
DGMGRL> show database prim_alok InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE

Comments

Post a Comment

Popular posts from this blog

Key points on Read-Only Instance and Read-Only Database

 In Oracle, both Read-Only Instance and Read-Only Database provide mechanisms to limit data modifications, but they are used in different contexts and for different purposes. Here's a comparison: 1. Read-Only Instance Definition : A read-only instance is a configuration in Oracle Real Application Clusters (RAC) where one or more instances of a multi-instance database are set up to operate in read-only mode. This is typically done in environments with high concurrency for both read and write operations. Key Features : Allows real-time query scaling by dedicating specific instances to read-only operations. Write operations are not allowed on the designated read-only instance, but other instances in the cluster can still handle write operations. Useful in RAC configurations for load balancing , where read workloads can be distributed across multiple read-only instances. Instance-specific: The database remains fully functional (read-write) when accessed through other instances. Us...
Read more

Steps to create database link between Oracle database and SQL Server

 Creating a database link between SQL Server and Oracle allows seamless data exchange between the two systems. Here’s a step-by-step guide: Step 1: Install the Required Drivers Install Oracle Database Gateway for SQL Server (ODG4MS). This acts as a bridge between Oracle and SQL Server. Ensure the Oracle Client is installed on the Oracle database server or the server acting as the gateway. Step 2: Configure the Oracle Database Gateway Locate Configuration Files: Navigate to the $ORACLE_HOME/network/admin directory on the Oracle Gateway server. Edit tnsnames.ora: Add an entry for the database link pointing to the SQL Server database: dg4msql =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = <SQL_SERVER_HOSTNAME>)(PORT = 1521))     (CONNECT_DATA = (SID = dg4msql))     (HS=OK)  -- Required for heterogeneous services   )   Edit listener.ora: Update the Oracle listener configuration to recognize the gateway: SID_LIST_LISTENE...
Read more

Oracle 23c AI RMAN New Features....

 Oracle 23c AI (also known as Oracle Database 23c: The Long-Term Release ) introduces several cutting-edge features, enhancements, and optimizations to RMAN (Recovery Manager), ensuring even more robust backup and recovery capabilities. RMAN remains an essential tool for Oracle DBAs, and with 23c, it becomes even more powerful, particularly with AI-assisted capabilities. Below are 10 new features in RMAN in Oracle 23c : 1. AI-Assisted Backup and Recovery Optimization Feature Overview : Oracle 23c introduces AI-driven algorithms that analyze system workload patterns, storage usage, and historical backup performance to optimize backup windows, schedules, and methods. The AI assistant learns from past recovery operations to suggest optimal backup strategies. Benefit : More efficient backups with minimal impact on production, and faster, more predictable recovery times based on learned behavior. 2. Automatic Block Repair with AI Feature Overview : This feature enhances RMAN’s block med...
Read more