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/