HDR备服务器数据库不能启动

hyong_uestc

主服务器状态
[informix@zhufuwuqi etc]$ onstat -
IBM Informix Dynamic Server Version 11.50.FC3     -- On-Line (Prim) -- Up 00:00:59 -- 149188 Kbytes
在主服务器上用命令恢复备服务器数据库后,数据库一直处于Fast Recovery状态,用onmode -d secondary onzhufuwuqi 后,查看信息如下
Message Log File: /home/informix/tmp/online.log
17:01:06  Maximum server connections 0
17:01:06  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

17:01:06  Checkpoint Completed:  duration was 0 seconds.
17:01:06  Tue Dec 13 - loguniq 10, logpos 0x6bc018, timestamp: 0x5218a Interval: 464

17:01:06  Maximum server connections 0
17:01:06  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

17:01:08  Physical Restore of rootdbs, plogdbs, llogdbs, datadbs Completed.
17:01:08  Checkpoint Completed:  duration was 0 seconds.
17:01:08  Tue Dec 13 - loguniq 10, logpos 0x6bc018, timestamp: 0x5219e Interval: 464

17:01:08  Maximum server connections 0
17:11:16  DR: Reservation of the last logical log for log backup turned off
17:11:16  DR: new type = secondary, primary server name = onzhufuwuqi
17:11:16  DR: Trying to connect to primary server = onzhufuwuqi
17:11:16  DR: Cannot connect to primary server
17:11:16  DR: Turned off on secondary server
17:11:17  Cannot create SMX pipes
备服务器数据库一直处于下面的状态
IBM Informix Dynamic Server Version 11.50.FC3     -- Fast Recovery (Sec) -- Up 00:10:46 -- 149188 Kbytes
看报错信息是连不上主服务器,可是也ping的通主服务器
[informix@beifuwuqi etc]$ ping 172.21.2.210
PING 172.21.2.210 (172.21.2.210) 56(84) bytes of data.
64 bytes from 172.21.2.210: icmp_seq=1 ttl=64 time=28.8 ms
64 bytes from 172.21.2.210: icmp_seq=2 ttl=64 time=0.154 ms
64 bytes from 172.21.2.210: icmp_seq=3 ttl=64 time=0.149 ms
rsh信任关系也已经建立了
[informix@beifuwuqi etc]$ rsh 172.21.2.210 hostname
zhufuwuqi

请哪位老大帮忙看一下原因,谢谢!在线等~

liaosnet

17:11:16  DR: Trying to connect to primary server = onzhufuwuqi
17:11:16  DR: Cannot connect to primary server


看下两边的sqlhosts文件是否包含对方～～端口设置是否正确～

hyong_uestc

主服务器sqlhosts
onzhufuwuqi     onsoctcp        zhufuwuqi       shop
onbeifuwuqi     onsoctcp        beifuwuqi       shop
备服务器sqlhosts
onbeifuwuqi     onsoctcp        beifuwuqi       shop
onzhufuwuqi     onsoctcp        zhufuwuqi       shop
主备服务器的/etc/services里的端口都是
# Local services
shop            7711/tcp                        # shop

liaosnet

rlogin zhufuwuqi       成功不？

hyong_uestc

不成功~
[informix@beifuwuqi etc]$ rlogin zhufuwuqi
connect to address 172.21.2.210 port 543: Connection refused
Trying krb4 rlogin...
connect to address 172.21.2.210 port 543: Connection refused
trying normal rlogin (/usr/bin/rlogin)
zhufuwuqi: Connection refused
主备服务器的/etc/hosts.equiv内容都是
[informix@beifuwuqi etc]$ vi /etc/hosts.equiv

zhufuwuqi
beifuwuqi

liaosnet

不成功~
$ rlogin zhufuwuqi
connect to address 172.21.2.210 port 543: Connection refused
Trying k ...
hyong_uestc 发表于 2011-12-13 10:06

    hdr 需要的是rlogin的成功。。看你的系统应该是linux，尝试安装rsh-server这个包后再试下。。。若是已经安装，再看下防火墙有没有关闭543的端口。。。

hyong_uestc

rlogin已成功
[informix@beifuwuqi ~]$ rlogin zhufuwuqi
connect to address 172.21.2.210 port 543: Connection refused
Trying krb4 rlogin...
connect to address 172.21.2.210 port 543: Connection refused
trying normal rlogin (/usr/bin/rlogin)
Last login: Tue Dec 13 18:36:20 from beifuwuqi
[informix@zhufuwuqi ~]$
但是还是显示连不上
[informix@beifuwuqi ~]$ onstat -m

IBM Informix Dynamic Server Version 11.50.FC3     -- Fast Recovery (Sec) -- Up 00:00:17 -- 149188 Kbytes

Message Log File: /home/informix/tmp/online.log
18:52:32  DR: DRAUTO is 0 (Off)
18:52:32  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
18:52:32  Event notification facility epoll enabled.
18:52:33  IBM Informix Dynamic Server Version 11.50.FC3     Software Serial Number AAA#B000000
18:52:34  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

18:52:34  Started 1 B-tree scanners.
18:52:34  B-tree scanner threshold set at 5000.
18:52:34  B-tree scanner range scan size set to -1.
18:52:34  B-tree scanner ALICE mode set to 6.
18:52:34  B-tree scanner index compression level set to med.
18:52:34  Physical Recovery Started at Page (2:3281).
18:52:34  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
18:52:34  DR: Trying to connect to primary server = onzhufuwuqi
18:52:34  DR: Cannot connect to primary server
18:52:34  DR: Turned off on secondary server
18:52:35  Cannot create SMX pipes
18:52:35  Dataskip is now OFF for all dbspaces
18:52:35  Restartable Restore has been ENABLED
18:52:35  Recovery Mode

liaosnet

主机再执行下onmode -d primary onbeifuwuqi
然后备机执行onmode -d secondary onzhufuwuqi

hyong_uestc

还是一样

[informix@beifuwuqi ~]$ onmode -d secondary onzhufuwuqi
[informix@beifuwuqi ~]$ onstat -

IBM Informix Dynamic Server Version 11.50.FC3     -- Fast Recovery (Sec) -- Up 00:00:44 -- 149188 Kbytes

[informix@beifuwuqi ~]$ onstat -

IBM Informix Dynamic Server Version 11.50.FC3     -- Fast Recovery (Sec) -- Up 00:00:45 -- 149188 Kbytes

[informix@beifuwuqi ~]$ onstat -m

IBM Informix Dynamic Server Version 11.50.FC3     -- Fast Recovery (Sec) -- Up 00:00:53 -- 149188 Kbytes

Message Log File: /home/informix/tmp/online.log
19:10:43  Maximum server connections 0
19:10:43  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

19:10:43  Checkpoint Completed:  duration was 0 seconds.
19:10:43  Tue Dec 13 - loguniq 10, logpos 0x712018, timestamp: 0x53738 Interval: 478

19:10:43  Maximum server connections 0
19:10:43  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

19:10:44  Physical Restore of rootdbs, plogdbs, llogdbs, datadbs Completed.
19:10:44  Checkpoint Completed:  duration was 0 seconds.
19:10:44  Tue Dec 13 - loguniq 10, logpos 0x712018, timestamp: 0x5374c Interval: 478

19:10:44  Maximum server connections 0
19:11:12  DR: Reservation of the last logical log for log backup turned off
19:11:12  DR: new type = secondary, primary server name = onzhufuwuqi
19:11:12  DR: Trying to connect to primary server = onzhufuwuqi
19:11:12  DR: Cannot connect to primary server
19:11:12  DR: Turned off on secondary server
19:11:12  Cannot create SMX pipes

[informix@beifuwuqi ~]$

liaosnet

重建下HDR试下。。