概述:dataguard的管理可以是sqlplus、dgbroker和EM等工具进行管理,本文配置dg broker来管理dg的switch over 和 fast failover;
实验:
主备库开启dg broker 特性功能
SQL> show parameter dg
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
cell_offloadgroup_name string
dg_broker_config_file1 string /u01/app/oracle/product/11.2.0
/db_1/dbs/dr1CUBE.dat
dg_broker_config_file2 string /u01/app/oracle/product/11.2.0
/db_1/dbs/dr2CUBE.dat
dg_broker_start boolean FALSE
SQL> alter system set dg_broker_start=true;
System altered.
dgbroker配置:
[oracle@cube ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> CREATE CONFIGURATION 'DRSolution' AS PRIMARY DATABASE IS 'CUBE' CONNECT IDENTIFIER IS CUBE;
Configuration "DRSolution" created with primary database "CUBE"
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxPerformance
Databases:
CUBE - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> ADD DATABASE 'JAKKI' as CONNECT IDENTIFIER IS JAKKI;
Database "JAKKI" added
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxPerformance
Databases:
CUBE - Primary database
JAKKI - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> SHOW DATABASE VERBOSE 'CUBE';
Database - CUBE
Role: PRIMARY
Intended State: OFFLINE
Instance(s):
CUBE
Properties:
DGConnectIdentifier = 'cube'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure &