【HADR】搭建实战

Summary:

简单的HADR，只用一台虚拟机，两个实例间搭建。工作量不大，一般5分钟左右能够完成。
步骤：
1.设定归档模式
2.使用备份建立standby数据库
3.设定hadr相关的参数
4.启动并测试

测试环境：

OS：Red hat 6

Server： 192.168.122.17

Primary instance: hadr1pri

Primary service/port: 43099

Standby instance: hadr1std

Standby service/port: 44099

DB name: ORG

--注意，切勿使用与DBM SVCENAME 太接近的端口，因为实例会默认使用那端口之后的连续几个端口，所以应尝试更远一些的端口

vi /etc/services

DB2_hadrpri     60008/tcp

DB2_hadrpri_1   60009/tcp

DB2_hadrpri_2   60010/tcp

DB2_hadrpri_END 60011/tcp

DB2_hadrstd     60012/tcp

DB2_hadrstd_1   60013/tcp

DB2_hadrstd_2   60014/tcp

DB2_hadrstd_END 60015/tcp

43099    43099/tcp

44099   44099/tcp

搭建开始

step 1: 创建组和用户

create primary instance id
To create groups on Linux operating systems, enter the following commands:

groupadd -g  db2iadm2

groupadd -g  db2fadm2

groupadd -g  dasadm2

Create users for each group:

useradd -u  -g db2iadm2 -m -d /home/hadrpri  hadrpri

useradd -u  -g db2fadm2 -m -d /home/hadrfenc  hadrfenc

useradd -u  -g dasadm2 -m -d /home/hadrdas hadrdas

create standby instance id
To create groups on Linux operating systems, enter the following commands:

useradd -u 1020 -g db2iadm2 -m -d /home/hadr1std hadr1std

useradd -u 1019 -g db2fadm2 -m -d /home/hadr1sfc hadr1sfc

useradd -u 1018 -g dasadm2 -m -d /home/std1das std1das

step 2:创建实例

cd /opt/IBM/db2/V9.7/instance

./db2icrt -s ese -u hadr1fc  hadr1pri

./db2icrt -s ese -u hadr1sfc hadr1std

step3: 主节点归档模式设置，备节点使用restore方式创建数据库，主备节点HADR设置

--在Primary：

--启用归档模式

--启用LOGINDEXBUILD，以便日志有关索引的操作   

db2 update db cfg for org  using LOGRETAIN on

db2 update db cfg for org using LOGINDEXBUILD on 

--Backup DB

db2 backup db org to /data

----在standby

--启动数据

--使用primary db 的备份文件进行数据库恢复

db2start

db2 restore db org from   /home/hadrstd  taken at 20150120040252 on /home/hadrstd dbpath on /home/hadrstd

--这时候standby的数据库应该是roll-forward pedning的状态，切勿手动roll-forward
db2 connect to org

SQL1117N A connection to or activation of database "SAMPLE" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019

--在Primary：

db2 update dbm cfg using svcename DB2_hadrpri

db2 update db cfg for org using hadr_local_svc 41099

db2 update db cfg for org using hadr_remote_host 192.168.122.17

db2 update db cfg for org using hadr_local_host 192.168.122.17

db2 update db cfg for org using hadr_remote_svc 42099

db2 update db cfg for org using hadr_remote_inst hadrstd

db2 update db cfg for org using hadr_syncmode sync

db2 connect to org

db2 quiesce database immediate force connections

db2 unquiesce database

db2 connect reset

--在Standby：

db2 update dbm cfg using svcename DB2_hadrstd

db2 update db cfg for org using hadr_remote_host 192.168.122.17

db2 update db cfg for org using hadr_local_svc 42099

db2 update db cfg for org using hadr_local_host 192.168.122.17

db2 update db cfg for org using hadr_remote_svc 41099

db2 update db cfg for org using hadr_remote_inst hadrpri

db2 update db cfg for org using hadr_syncmode sync

db2 update db cfg for org using HADR_TIMEOUT 3

db2 update db cfg for org using HADR_PEER_WINDOW 120

4.启动并测试

--先启动standby
    --在Standby：
    db2 start hadr on db sample as standby
    DB20000I The START HADR ON DATABASE command completed successfully.

    --这时候应该是remote catchup pending的状态：

[hadrstd@oc0644314035 db2dump]$ db2pd -d org -hadr

Database Partition 0 -- Database ORG -- Standby -- Up 0 days 00:00:05 -- Date 2015-01-20-22.00.09.169952

HADR Information:

Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)

Standby RemoteCatchupPending Sync 0 0

ConnectStatus ConnectTime Timeout
Disconnected Tue Jan 20 22:00:05 2015 (1421809205) 120

LocalHost LocalService
192.168.122.17 42099

RemoteHost RemoteService RemoteInstance
192.168.122.17 41099 hadrstd

PrimaryFile PrimaryPg PrimaryLSN
S0000000.LOG 0 0x0000000002728010

StandByFile StandByPg StandByLSN StandByRcvBufUsed

--再启动Primary
--在Primary：
[hadr1pri@oc0644314035 data]$ db2 start hadr on database org as primary

DB20000I The START HADR ON DATABASE command completed successfully.

[hadrstd@oc0644314035 ~]$ db2pd -d org -hadr

Database Partition 0 -- Database ORG -- Standby -- Up 0 days 00:11:53 -- Date 2015-01-21-00.59.58.732725

HADR Information:

Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)

Standby Peer Sync 0 0

ConnectStatus ConnectTime Timeout
Connected Wed Jan 21 00:48:39 2015 (1421819319) 3

PeerWindowEnd PeerWindow

Wed Jan 21 01:01:57 2015 (1421820117) 120

LocalHost LocalService
192.168.122.17 42099

RemoteHost RemoteService RemoteInstance
192.168.122.17 41099 hadrpri

PrimaryFile PrimaryPg PrimaryLSN
S0000001.LOG 0 0x0000000002728010

StandByFile StandByPg StandByLSN StandByRcvBufUsed

S0000001.LOG 0 0x0000000002728010 0%

--可以看到一旦Primary也起来了，hadr的状态就会变成peer

--这时候尝试手动归档，看日志是否能够顺利传递到standby
[hadr1pri@oc0644314035 data]$ db2 archive log for DB sample

DB20000I The ARCHIVE LOG command completed successfully.

--在Standby进行role 切换

[hadrstd@oc0644314035 ~]$ db2 takeover hadr on database org

DB20000I The TAKEOVER HADR ON DATABASE command completed successfully.

[hadrstd@oc0644314035 ~]$ db2pd -d org -hadr

Database Partition 0 -- Database ORG -- Active -- Up 0 days 00:12:16 -- Date 2015-01-21-01.00.21.098460

HADR Information:

Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)

Primary Peer Sync 0 0

ConnectStatus ConnectTime Timeout
Connected Wed Jan 21 00:48:39 2015 (1421819319) 3

PeerWindowEnd PeerWindow

Wed Jan 21 01:02:20 2015 (1421820140) 120

LocalHost LocalService
192.168.122.17 42099

RemoteHost RemoteService RemoteInstance
192.168.122.17 41099 hadrpri

PrimaryFile PrimaryPg PrimaryLSN
S0000001.LOG 0 0x0000000002728010

StandByFile StandByPg StandByLSN
S0000001.LOG 0 0x0000000002728010

References

搭建案例：

http://guoyanxi.iteye.com/blog/1173906

http://blog.csdn.net/dream19881003/article/details/7417285

自己总结的ISSUES

http://www.cnblogs.com/DBA-Ivan/p/4260264.html

Issues：

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014850278

http://bytes.com/topic/db2/answers/496482-unable-start-hadr-reason-code-7-a

http://www.dbforums.com/showthread.php?1665366-DB2-9-7-HADR-setup

巴特西

【HADR】搭建实战

最新文章

热门文章