Setting up a Data Guard Broker

Setting up a Data Guard Broker

Raul Pessoa, MBA Raul Pessoa, MBA

Raul Pessoa, MBA

Senior Database Administrator | Oracle, SQL Server, PostgreSQL

发布日期: 2022年12月1日
+ 关注
No alt text provided for this image

Check the current state of DG Broker on Primary Database 

SQL> show parameter DG_BROKER_START

NAME                                 TYPE        VALUE
---------------------------------- ----------- ------------------------------
dg_broker_start                    boolean     FALSE

Check the current state of DG Broker on Standby Database 

SQL> show parameter DG_BROKER_STAR

NAME                                 TYPE        VALUE
---------------------------------- ----------- ------------------------------
dg_broker_start                    boolean     FALSET

Verify GAP

On Primary

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
OPEN         orcl             PRIMARY          MAXIMUM PERFORMANCE

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            35

On Standby

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
OPEN         orcldr           PHYSICAL STANDBY MAXIMUM PERFORMANCE

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            35

Enable DG Broker

On Primary

SQL> alter system set dg_broker_start=true

System altered.

SQL> show parameter dg_broker_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
dg_broker_config_file1               string      +DATA/orcl/dgb_file1.dat
dg_broker_config_file2               string      +FRA/orcl/dgb_file2.dat

On Standby

SQL> alter system set dg_broker_start=true

System altered.

SQL> show parameter dg_broker_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
dg_broker_config_file1               string      +DATA/orcldr/dgb_file1.dat
dg_broker_config_file2               string      +FRA/orcldr/dgb_file2.date

Append to LISTENER.ORA

On Primary

SID_LIST_LISTENER=
 (SID_LIST=
? (SID_DESC=
?  (GLOBAL_DBNAME=orcl_DGMGRL)
?  (ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db)
?  (SID_NAME=orcl01)
  )
 )

On Standby

SID_LIST_LISTENER=
 (SID_LIST=
? (SID_DESC=
  ?(GLOBAL_DBNAME=orcldr_DGMGRL)
  ?(ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db)
  ?(SID_NAME=orcldr1)
  )
?)

Create DG Broker configuration 

[oracle@GreenNode ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/Banana@orcl
Connected.

DGMGRL> create configuration 'orcl' as primary database is 'orcl' connect identifier is orcl;

Configuration "orcl" created with primary database "orcl"

DGMGRL> show configuration;

Configuration - orcl

  Protection Mode: MaxPerformance
  Databases:
    orcl - Primary database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL> add database 'orcldr' as connect identifier is orcldr maintained as physical;
Database "orcldr" added

DGMGRL> show configuration;

Configuration - orcldr

  Protection Mode: MaxPerformance
  Databases:
    orcl   - Primary database
    orcldr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL> enable configuration;
Enabled.

DGMGRL> show configuration;

Configuration - orcl

  Protection Mode: MaxPerformance
  Databases:
    orcl    - Primary database
    orcldr  - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL>

要查看或添加评论，请登录

Raul Pessoa, MBA的更多文章

社区洞察

其他会员也浏览了