oracle12c的dg配置,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 '' AS PRIMARY DATABASE IS '' CONNECT IDENTIFIER IS ;

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 as connect identifier is ;

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