Oracle 12C dgbroker 配置

关于DGbroker的配置网上有太多资料了,此处在不做详细介绍配置,贴一片metalink上的文章共大家参考学习。
1. Prerequisits,

Start the Dataguard broker DMON process. ----------启动dg_broker

On Primary and Standby,


SQL> alter system set dg_broker_start=true sid='*'; 

 

2. Connect to DGMGRL    ---------------------------连接dgmgrl,进行配置

Primary,

$dgmgrl 
DGMGRL>connect sysdg
password: *****


3. Create configuration,   ----------------------------创建配置

 

DGMGRL> CREATE CONFIGURATION '<configuration name>' AS PRIMARY DATABASE IS '<primary db_unique_name>' CONNECT IDENTIFIER IS <primary connect string>;

ex,

DGMGRL> CREATE CONFIGURATION '12c' AS PRIMARY DATABASE IS 'boston' CONNECT IDENTIFIER IS boston;

 


NOTE : If create configuration fails with ORA-16698 refer to
Note 1582179.1: Create Configuration Failing with ORA-16698


Verify configuration,

DGMGRL> show configuration;

Configuration - 12c

  Protection Mode: MaxPerformance
  Databases:
  boston - Primary database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED


4. Add Standby,    -------------------------------添加备用环境

DGMGRL>  add database <standby db_unique_name> as connect identifier is <standby connect string>;

ex,


DGMGRL>  add database chicago as connect identifier is chicago;

 

DGMGRL> show configuration;

Configuration - 12c

  Protection Mode: MaxPerformance
  Databases:
  boston  - Primary database
    chicago - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

5. Enable Configuration,

DGMGRL> enable configuration;


6. Verify configuration,

DGMGRL> show configuration;

Configuration - 12c

  Protection Mode: MaxPerformance
  Databases:
  boston  - Primary database
    chicago - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

 

DGMGRL> show database boston;

Database - boston

  Role:              PRIMARY
  Intended State:    TRANSPORT-ON
  Instance(s):
    boston

Database Status:
SUCCESS


DGMGRL>  show database chicago;

Database - chicago

  Role:              PHYSICAL STANDBY
  Intended State:    APPLY-ON
  Transport Lag:     0 seconds (computed 1 second ago)
  Apply Lag:         0 seconds (computed 1 second ago)
  Apply Rate:        2.54 MByte/s
  Real Time Query:   ON
  Instance(s):
    chicago
Database Status:
SUCCESS

 

 

Datagurd configuration details recorded in binary file,

 

SQL> show parameter config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_1/dbs/dr1boston.dat
dg_broker_config_file2               string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_1/dbs/dr2boston.dat

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28612416/viewspace-2120010/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/28612416/viewspace-2120010/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值