重建 Dataguard Broker及配置FSFO

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)

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)
)
)