HDR备服务器数据库不能启动
主服务器状态$ 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:06Maximum server connections 0
17:01:06Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0
17:01:06Checkpoint Completed:duration was 0 seconds.
17:01:06Tue Dec 13 - loguniq 10, logpos 0x6bc018, timestamp: 0x5218a Interval: 464
17:01:06Maximum server connections 0
17:01:06Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0
17:01:08Physical Restore of rootdbs, plogdbs, llogdbs, datadbs Completed.
17:01:08Checkpoint Completed:duration was 0 seconds.
17:01:08Tue Dec 13 - loguniq 10, logpos 0x6bc018, timestamp: 0x5219e Interval: 464
17:01:08Maximum server connections 0
17:11:16DR: Reservation of the last logical log for log backup turned off
17:11:16DR: new type = secondary, primary server name = onzhufuwuqi
17:11:16DR: Trying to connect to primary server = onzhufuwuqi
17:11:16DR: Cannot connect to primary server
17:11:16DR: Turned off on secondary server
17:11:17Cannot create SMX pipes
备服务器数据库一直处于下面的状态
IBM Informix Dynamic Server Version 11.50.FC3 -- Fast Recovery (Sec) -- Up 00:10:46 -- 149188 Kbytes
看报错信息是连不上主服务器,可是也ping的通主服务器
$ 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信任关系也已经建立了
$ rsh 172.21.2.210 hostname
zhufuwuqi
请哪位老大帮忙看一下原因,谢谢!在线等~ 17:11:16DR: Trying to connect to primary server = onzhufuwuqi
17:11:16DR: Cannot connect to primary server
看下两边的sqlhosts文件是否包含对方～～端口设置是否正确～ 主服务器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 rlogin zhufuwuqi 成功不？ 不成功~
$ 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内容都是
$ vi /etc/hosts.equiv
zhufuwuqi
beifuwuqi 不成功~
$ rlogin zhufuwuqi
connect to address 172.21.2.210 port 543: Connection refused
Trying k ...
hyong_uestc 发表于 2011-12-13 10:06 http://bbs.chinaunix.net/images/common/back.gif
hdr 需要的是rlogin的成功。。看你的系统应该是linux，尝试安装rsh-server这个包后再试下。。。若是已经安装，再看下防火墙有没有关闭543的端口。。。 rlogin已成功
$ 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
$
但是还是显示连不上
$ 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:32DR: DRAUTO is 0 (Off)
18:52:32DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
18:52:32Event notification facility epoll enabled.
18:52:33IBM Informix Dynamic Server Version 11.50.FC3 Software Serial Number AAA#B000000
18:52:34IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
18:52:34Started 1 B-tree scanners.
18:52:34B-tree scanner threshold set at 5000.
18:52:34B-tree scanner range scan size set to -1.
18:52:34B-tree scanner ALICE mode set to 6.
18:52:34B-tree scanner index compression level set to med.
18:52:34Physical Recovery Started at Page (2:3281).
18:52:34Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
18:52:34DR: Trying to connect to primary server = onzhufuwuqi
18:52:34DR: Cannot connect to primary server
18:52:34DR: Turned off on secondary server
18:52:35Cannot create SMX pipes
18:52:35Dataskip is now OFF for all dbspaces
18:52:35Restartable Restore has been ENABLED
18:52:35Recovery Mode 主机再执行下onmode -d primary onbeifuwuqi
然后备机执行onmode -d secondary onzhufuwuqi 还是一样
$ onmode -d secondary onzhufuwuqi
$ onstat -
IBM Informix Dynamic Server Version 11.50.FC3 -- Fast Recovery (Sec) -- Up 00:00:44 -- 149188 Kbytes
$ onstat -
IBM Informix Dynamic Server Version 11.50.FC3 -- Fast Recovery (Sec) -- Up 00:00:45 -- 149188 Kbytes
$ 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:43Maximum server connections 0
19:10:43Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0
19:10:43Checkpoint Completed:duration was 0 seconds.
19:10:43Tue Dec 13 - loguniq 10, logpos 0x712018, timestamp: 0x53738 Interval: 478
19:10:43Maximum server connections 0
19:10:43Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0
19:10:44Physical Restore of rootdbs, plogdbs, llogdbs, datadbs Completed.
19:10:44Checkpoint Completed:duration was 0 seconds.
19:10:44Tue Dec 13 - loguniq 10, logpos 0x712018, timestamp: 0x5374c Interval: 478
19:10:44Maximum server connections 0
19:11:12DR: Reservation of the last logical log for log backup turned off
19:11:12DR: new type = secondary, primary server name = onzhufuwuqi
19:11:12DR: Trying to connect to primary server = onzhufuwuqi
19:11:12DR: Cannot connect to primary server
19:11:12DR: Turned off on secondary server
19:11:12Cannot create SMX pipes
$ 重建下HDR试下。。