Oracle 11g Dataguard Physical standby configuration (iii) Dataguard broker configuration

1. Main Library Broker Configuration

1) Query Switchover status

Sql> select Database_role,switchover_status from V$database;

Database_role Switchover_status

---------------- --------------------

PRIMARY to STANDBY

2) Query Dg_broker_start parameters

Sql> Show parameter Dg_broker_start;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Dg_broker_start Boolean FALSE

Sql> alter system set Dg_broker_start = true;

3) Listener file to add static monitoring

$ cat/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Add the following content to

Sid_list_listener =

(Sid_list =

(Sid_desc =

(Global_dbname = ORCL)

(Oracle_home =/u01/app/oracle/product/11.2.0/db_1)

(Sid_name = ORCL)

)

(Sid_desc =

(Global_dbname = ORCL_DGB)

(Oracle_home =/u01/app/oracle/product/11.2.0/db_1)

(Sid_name = ORCL)

)

(Sid_desc =

(Global_dbname = ORCL_DGMGRL)

(Oracle_home =/u01/app/oracle/product/11.2.0/db_1)

(Sid_name = ORCL)

)

)

Description

# Global_dbname has a fixed format:<db_unique_name>_dgmgrl.<db_domain>.

# After the modification is complete, the listener must be restarted.

Reboot Monitor

$ lsnrctl Reload

View listening status

$ LSNRCTL Status

Lsnrctl for Linux:version 11.2.0.3.0-production on 1 July-August-2013 19:56:44

Copyright (c) 1991, Oracle. All rights reserved.

Connecting to (Description= (address= (protocol=tcp) (host=192.168.233.200) (port=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version Tnslsnr for Linux:version 11.2.0.3.0-production

Launch date 1 July-August-2013 19:05:06

Uptime 0 days 0 hours 51 minutes 38 seconds

Trace level off

Security On:local OS Authentication

SNMP off

Listener parameter File/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener log File/u01/app/oracle/diag/tnslsnr/master/listener/alert/log.xml

Monitor Endpoint Summary ...

(Description= (address= (protocol=tcp) (host=192.168.233.200) (port=1521))

(Description= (address= (PROTOCOL=IPC) (key=extproc1521))

Service summary.

The service "ORCL" contains 2 instances.

Instance "ORCL", State UNKNOWN, contains 1 handlers for this service ...

Instance "ORCL", State READY, contains 1 handlers for this service ...

The service "Orclxdb" contains 1 instances.

Instance "ORCL", State READY, contains 1 handlers for this service ...

The service "ORCL_DGB" contains 1 instances.

Instance "ORCL", State UNKNOWN, contains 1 handlers for this service ...

The service "ORCL_DGMGRL" contains 1 instances.

Instance "ORCL", State UNKNOWN, contains 1 handlers for this service ...

Command execution succeeded

2. Standby Broker Configuration

1) Query Switchover status

Sql> select Database_role,switchover_status from V$database;

Database_role Switchover_status

---------------- --------------------

Physical STANDBY not allowed

2) Query Dg_broker_start parameters

Sql> Show parameter Dg_broker_start;

Sql> alter system set Dg_broker_start = true;

3) Listener file to add static monitoring

$ cat/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

LISTENER =

(Description_list =

(DESCRIPTION =

(address = (PROTOCOL = TCP) (HOST = 192.168.233.150) (PORT = 1521))

(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/