DGMGRL> disable FAST_START FAILOVER; Disabled. DGMGRL> SHOW CONFIGURATION;
sys@LIMING> show parameter dg_broker_config_file
NAME TYPE VALUE
dg_broker_config_file1 string /u01/app/oracle/product/11.2.0 /db_1/dbs/dr1LIMING.dat dg_broker_config_file2 string /u01/app/oracle/product/11.2.0 /db_1/dbs/dr2LIMING.dat
rm dr1LIMING.dat rm dr2LIMING.dat
dgmgrl sys/passwd@DB_LIMING
CREATE CONFIGURATION ‘PRODCONF’ AS PRIMARY DATABASE IS ‘LIMING’ CONNECT IDENTIFIER IS DG_LIMING;
ADD DATABASE ‘LMSTD’ AS CONNECT IDENTIFIER IS DG_LMSTD MAINTAINED AS PHYSICAL;
这里的参数要说明一下.add database ‘LMSTD′ ,这儿的LMSTD是指database的db_unique_name,而AS CONNECT IDENTIFIER IS DG_LMSTD 这里的LMSTD是指tnsname.ora连接到standby database的net service name.
ENABLE CONFIGURATION;
SHOW CONFIGURATION;
DGMGRL> edit database ‘LIMING’ set property ‘logxptmode’=‘sync’;
Property “logxptmode” updated
DGMGRL> edit database ‘LMSTD’ set property ‘logxptmode’=‘sync’;
DGMGRL> edit configuration set protection mode as maxavailability;
DGMGRL> enable fast_start failover;
DGMGRL> show database verbose “LMSTD”
Database - LMSTD
Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds Apply Lag: 0 seconds Real Time Query: OFF Instance(s): LMSTD
Database Warning(s): ORA-16819: fast-start failover observer not started
可是我们发现DGMGRL告警了，那是因为我们没有启动观察器（observer）的原因
解决：官方文档摘录
How to run Observer process as a background process (文档 ID 1084681.1)
start the dgmgrl process with nohup command, eg:#!/bin/ksh
Script to start observer via DGMGRL
nohup dgmgrl -logfile /tmp/dgmgrl.log <<eof connect sys/passwd@connect_string start observer EOF
chmod +x observer.sh
./observer.sh &
From 11.2 onwards, one can use the following command to start observer:
% dgmgrl -logfile /tmp/observer.log sys/idPocRiuZZK4a1G@DB_LIMING “start observer” &
tns配置信息 DG_LIMING= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=dbserver12)(PORT=1521)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=LIMING.LK) ) ) DG_LMSTD= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=dbserver13)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=LMSTD.LK) ) )
