DB2 V10.5 1主2从 HADR配置

字数 6415阅读 2703评论 0赞 1

<div>参考http://www.ibm.com/developerworks/cn/data/library/techarticle/dm-1206xuj2/index.html</div><div># </div><div><b>机器IP</b>：</div><div>M3  10.123.18.243</div><div>M4  10.123.18.244</div><div>M5  10.123.18.245</div><div><br></div><div><br></div><div><b>用户，准备：</b></div><div>groupadd -g 999 dasadm1</div><div>groupadd -g 998 db2fgrp1</div><div>groupadd -g 997 db2grp1</div><div>useradd -u 1004 -g db2grp1 -d  /home/db2insta db2insta</div><div>useradd -u 1003 -g db2fgrp1 -d /home/db2fenc1 db2fenc1</div><div>useradd -u 1002 -g dasadm1 -d  /home/dasusr1 dasusr1</div><div>/opt/ibm/db2/V10.5/instance/db2icrt -a server  -u db2insta db2insta</div><div>  </div><div>vi /etc/services </div><div>DB2_db2insta_pri      55003/tcp</div><div>DB2_db2insta_2nd      55004/tcp</div><div>DB2_db2insta_3rd      55005/tcp</div><div><br></div><div>mkdir -p /db2data</div><div>mkdir -p /db2log/actlog/</div><div>mkdir -p /db2log/arclog</div><div>mkdir -p /db2diag/db2dump/</div><div>chown db2insta:db2grp1 -R /db2data</div><div>chown db2insta:db2grp1 -R /db2log/actlog/</div><div>chown db2insta:db2grp1 -R /db2log/arclog</div><div>chown db2insta:db2grp1 -R /db2diag/db2dump/</div><div><br></div><div><br></div><div><b>建立测试库</b></div><div>在M1上操作(建库,开归档,备份)</div><div>db2 update dbm cfg using SVCENAME 50000</div><div>db2set db2comm=tcpip</div><div>db2set DB2_STANDBY_ISO=UR</div><div>db2set DB2_HADR_ROS=ON</div><div>db2 " create db  MYDB automatic storage yes on /db2data dbpath on  /db2data   USING  CODESET UTF-8 TERRITORY CN PAGESIZE 16384" </div><div>db2 connect to MYDB</div><div>db2 update db cfg using NEWLOGPATH /db2log/actlog/</div><div>db2 update db cfg using LOGARCHMETH1 DISK:/db2log/arclog</div><div>db2 update db cfg using NUM_LOG_SPAN 40</div><div>db2 update db cfg using MAX_LOG 20</div><div>db2 update dbm cfg using DIAGPATH /db2diag/db2dump/</div><div>db2stop </div><div>#OFFLINE BACKUP</div><div>db2 "backup db MYDB to /dev/null "</div><div>db2 connect to MYDB</div><div>[db2insta@m3 ~]$ db2 "backup db  MYDB online to /tmp/"</div><div><span style="font-size: 14px; line-height: 1.8em;">Backup successful. The timestamp for this backup image is : 20150121215739</span></div><div><span style="font-size: 14px; line-height: 1.8em;">scp /tmp/MYDB.0.db2insta.DBPART000.20150121215739.001 到M4,M5</span></div><div> </div><div><span style="font-size: 14px; line-height: 1.8em;"><br></span></div><div><b><span style="font-size: 14px; line-height: 1.8em;"># </span><span style="font-size: 14px; line-height: 1.8em;">分别还原数据库(</span><span style="font-size: 14px; line-height: 1.8em;">M4，M5上)</span></b></div><div><span style="font-size: 14px; line-height: 1.8em;">db2 "restore database  MYDB FROM /tmp  taken at 20150121215739"</span></div><div>db2 "rollforward db MYDB query status "</div><div>                                 Rollforward Status</div><div><br></div><div> Input database alias                   = MYDB</div><div> Number of members have returned status = 1</div><div><br></div><div> Member ID                              = 0</div><div> Rollforward status                     = DB  pending</div><div> Next log file to be read               = S0000000.LOG</div><div> Log files processed                    =  -</div><div> Last committed transaction             = 2015-01-22-02.57.42.000000 UTC</div><div> </div><div> <b># HADR配置</b></div><div><div># 在 M3 上</div><div> db2 "UPDATE DB CFG FOR MYDB USING </div><div>     HADR_TARGET_LIST  M4:DB2_db2insta_2nd|M5:DB2_db2insta_3rd</div><div>     HADR_REMOTE_HOST  M4 </div><div><span class="Apple-tab-span" style="white-space:pre">	</span> HADR_REMOTE_INST  db2insta</div><div>     HADR_REMOTE_SVC   DB2_db2insta_2nd </div><div>     HADR_SYNCMODE     sync      </div><div>     HADR_LOCAL_HOST   M3 </div><div>     HADR_LOCAL_SVC    DB2_db2insta_pri"</div><div># 在 M4 上</div><div> db2 "UPDATE DB CFG FOR MYDB USING </div><div>    HADR_TARGET_LIST   M3:DB2_db2insta_pri|M5:DB2_db2insta_3rd </div><div>    HADR_REMOTE_HOST   M3 </div><div>    HADR_REMOTE_INST   db2insta</div><div>    HADR_REMOTE_SVC    DB2_db2insta_pri </div><div>    HADR_SYNCMODE      sync</div><div>    HADR_LOCAL_HOST    M4 </div><div>    HADR_LOCAL_SVC     DB2_db2insta_2nd "</div><div># 在 M5 上</div><div>db2 "UPDATE DB CFG FOR MYDB USING </div><div>     HADR_TARGET_LIST  M4:DB2_db2insta_2nd|M3:DB2_db2insta_pri </div><div>     HADR_REMOTE_HOST  M3 </div><div><span class="Apple-tab-span" style="white-space:pre">	</span> HADR_REMOTE_INST  db2insta </div><div>     HADR_REMOTE_SVC   DB2_db2insta_pri </div><div>     HADR_SYNCMODE     superasync      </div><div>     HADR_LOCAL_HOST   M5 </div><div>     HADR_LOCAL_SVC    DB2_db2insta_3rd "</div></div><div><br></div><div><b> #启动HADR</b></div><div><span style="font-size: 14px; line-height: 1.8em;"># 在 M4 上</span></div><div> db2 START HADR ON DB MYDB AS STANDBY </div><div><span style="font-size: 14px; line-height: 1.8em;"> # 在 M5 上</span></div><div> db2 START HADR ON DB MYDB AS STANDBY </div><div><span style="font-size: 14px; line-height: 1.8em;"> # 在 M3 上</span></div><div> db2 START HADR ON DB MYDB AS PRIMARY </div><div><br></div><div>检查HADR状态</div><div><span style="font-size: 14px; line-height: 1.8em;"># 在 M3上</span></div><div> db2 "select HADR_ROLE, STANDBY_ID, HADR_STATE, </div><div>            varchar(PRIMARY_MEMBER_HOST,20) as PRIMARY_HOST, </div><div>            varchar(STANDBY_MEMBER_HOST,20) as STANDBY_HOST </div><div>     from table (mon_get_hadr(NULL))"</div><div><br></div><div>HADR_ROLE     STANDBY_ID HADR_STATE              PRIMARY_HOST         STANDBY_HOST        </div><div>------------- ---------- ----------------------- -------------------- --------------------</div><div>PRIMARY                1 PEER                    M3                   M4                  </div><div>PRIMARY                2 REMOTE_CATCHUP          M3                   M5     </div><div><br></div><div><br></div><div><br></div><div><b>配置期间遇到的问题</b></div><div>报错1：</div><div>EduStartup, probe:21180</div><div>MESSAGE : ZRC=0x878001AC=-2021654100=HDR_ZRC_CONFIG_INVALID_HOST_IN_TARGETLIST</div><div>          "Some entry in HADR_TARGET_LIST cannot be resolved into valid TCP/IP address or port."</div><div>DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes</div><div> sqlcaid : SQLCA     sqlcabc: 136   sqlcode: 1766   sqlerrml: 0</div><div> sqlerrmc:  </div><div>报错2：</div><div>FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSpawnEdus, probe:25100</div><div>MESSAGE : ZRC=0x8280001A=-2105540582=HDR_ZRC_NO_STANDBY</div><div>          "Comm time-out in unforced HADR primary start, to avoid split-brain"</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>  </div><div>这2次报错均与hosts文件有关,</div><div>1. /etc/hosts 文件忘记写M5的IP</div><div>2. hosts文件配置了 10.123.18.xxx localhost M3 ，去掉改行就行了</div><div>发现端口绑定在127地址下</div><div>[db2insta@m4 ~]$ netstat -an |grep -i 55004</div><div>tcp        0      0 127.0.0.1:55004         0.0.0.0:*                   LISTEN<span class="Apple-tab-span" style="white-space:pre">	</span></div><div>3. linux 下注意开放端口，简单粗暴的做法是关闭iptables<span class="Apple-tab-span" style="white-space:pre">	</span>  </div><div> chkconfig iptables off;service iptables stop</div><div><br></div><div> </div><div><br></div>

数据库安装 HADR

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

DB2 V10.5 1主2从 HADR配置

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料