informix的一个chunk宕了，无法恢复为PO，删除也不行，各位高手看看如何解决？
数据库版本：7.31.UD6W5查看数据库状态，发现chunk6状态为PD！
% onstat -d
Informix Dynamic Server Version 7.31.UD6W5 -- On-Line -- Up 01:38:37 -- 87320 Kbytes
Dbspaces
addressnumber flags fchunk nchunksflags owner name
dfb2c158 1 1 1 1 N informix rootdbs
dfb2c8c8 2 1 2 1 N informix phydbs
dfb2c988 3 1 3 1 N informix logdbs
dfb2ca48 4 2001 4 1 N T informix tempdbs
dfb2cb08 5 1 5 2 N informix workdbs
5 active, 2047 maximum
Chunks
addresschk/dbs offset size free bpages flags pathname
dfb2c218 1 1 25 100000 98913 PO- /dev/vgsmp/rlvrootdbs
dfb2c3a0 2 2 25 511500 261447 PO- /dev/vgsmp/rlvphydbs
dfb2c4a8 3 3 25 511500 11447 PO- /dev/vgsmp/rlvlogdbs
dfb2c5b0 4 4 25 250000 249947 PO- /dev/vgsmp/rlvtempdbs1
dfb2c6b8 5 5 25 102350024448 PO- /dev/vgsmp/rlvworkdbs1
dfb2c7c0 6 5 25 10235000 PD- /dev/vgscp/rlvworkdbs2
6 active, 2047 maximum
方法1：尝试改变该chunk状态到PO，但失败！
% onspaces -s workdbs -p /dev/vgscp/rlvworkdbs2 -o 50
Warning:Bringing chunk back online.
Do you really want to continue? (y/n)y
Verifying physical disk space, please wait ...
Cannot change chunk status.
ISAM error: Primary and Mirror chunks are bad
方法2：该chunk数据无用，想drop掉该chunk，同样失败！
% onspaces -d workdbs -p /dev/vgscp/rlvworkdbs2 -o 50
WARNING:Dropping a chunk.
Do you really want to continue? (y/n)y
Chunk not dropped.
ISAM error: Primary and Mirror chunks are bad onspaces -d workdbs -p /dev/vgscp/rlvworkdbs2 -o 50 -f
加-f试一下..BTW:LZ是HW的吧..:mrgreen: 如果不用,考虑把现在的库导出来...然后删除workdbs,重建,再导入库.... chunk满了
回复 #4 tienan 的帖子
free 为0不一定是满了,,也有可能是CHUNK坏了.....不可用.. HW直接找800啊 请说明chunk down的时间和原因，只有对症才能下药。如果该chunk没有包含有用数据，可以考虑备份现有数据，然后重建实例
页:
[1]