centos 6.6 hadr db2-10.5.1 express-c



123为主 128 为辅助

主备都做

mkdir /data

chmod 777 /data

mkdir /data/logpath

chmod 777 /data/logpath

 

db2set DB2_HADR_ROS=1
db2set DB2_STANDBY_ISO=UR
db2 update db cfg for zsgjj using logretain on 
db2 update db cfg for zsgjj using trackmod on  
db2 update db cfg for zsgjj using logindexbuild on
db2 update db cfg for zsgjj using indexrec restart
db2 update db cfg for zsgjj using logarchmeth1 DISK:/data/logpath

备份数据库，在备机上restore
db2 restore db zsgjj from /home/db2inst1 taken at 20160209002815 replace history file

在主机上
db2 UPDATE ALTERNATE SERVER FOR DATABASE zsgjj USING HOSTNAME 192.168.1.128 PORT 50000

在备机上

db2 UPDATE ALTERNATE SERVER FOR DATABASE zsgjj USING HOSTNAME  192.168.1.123 PORT 50000

步骤 对应数据
=========================================================================
在主机上

db2 UPDATE DB CFG FOR zsgjj USING HADR_LOCAL_HOST 192.168.1.123
db2 UPDATE DB CFG FOR zsgjj USING HADR_LOCAL_SVC 55001
db2 UPDATE DB CFG FOR zsgjj USING HADR_REMOTE_HOST 192.168.1.128
db2 UPDATE DB CFG FOR zsgjj USING HADR_REMOTE_SVC 55002
db2 UPDATE DB CFG FOR zsgjj USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR zsgjj USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR zsgjj USING HADR_TIMEOUT 120
db2 CONNECT TO zsgjj
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 UNQUIESCE DATABASE
db2 CONNECT RESET

在备机上
db2 UPDATE DB CFG FOR zsgjj USING HADR_LOCAL_HOST 192.168.1.128
db2 UPDATE DB CFG FOR zsgjj USING HADR_LOCAL_SVC 55002
db2 UPDATE DB CFG FOR zsgjj USING HADR_REMOTE_HOST 192.168.1.123
db2 UPDATE DB CFG FOR zsgjj USING HADR_REMOTE_SVC 55001
db2 UPDATE DB CFG FOR zsgjj USING HADR_REMOTE_INST  db2inst1
db2 UPDATE DB CFG FOR zsgjj USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR zsgjj USING HADR_TIMEOUT 120

步骤

 启动HADR
先备机上启动
db2 DEACTIVATE DATABASE zsgjj
db2 START HADR ON DATABASE zsgjj AS STANDBY

在主机上
db2 DEACTIVATE DATABASE zsgjj
db2 START HADR ON DATABASE zsgjj AS PRIMARY

杯具-备机接过

db2 takeover hadr on zsgjj  by force  

测试ok！

猴年春节快乐！