跪求informix 修复工具:tbzone,谢谢!
本帖最后由 H13900000000 于 2011-09-08 15:16 编辑数据库挂起无法修复,跪求informix 修复工具:tbzone,谢谢!
相关日志:
$ onstat -l
IBM Informix Dynamic Server Version 9.40.UC2 -- Fast Recovery (CKPT REQ) -- Up 00:01:10 -- 1186324 Kbytes
Blocked:CKPT
Physical Logging
Buffer bufusedbufsizenumpages numwrits pages/io
P-20 64 0 0 0.00
phybegin physize phypos phyused %used
3:53 900000 663118 92 0.01
Logical Logging
Buffer bufusedbufsizenumrecsnumpages numwrits recs/pages pages/io
L-113 64 0 0 0 0.0 0.0
Subsystem numrecsLog Space used
Buffer Waiting
Bufferioproc flags
L-1 879a3858 0x1 0
addressnumber flags uniqid begin size used %used
879e1ca8 6 U-B----4174 3:901303 250 250 100.00
879e1ce8 1 U-B----4175 3:900053 250 250 100.00
879e1d28 2 U-B----4176 3:900303 250 250 100.00
879e1d68 3 U-B----4177 3:900553 250 250 100.00
879e1da8 9 U-B----4178 3:902053 250 250 100.00
879e1de8 10 U-B----4179 3:902303 250 250 100.00
879e1e28 28 U-B----4180 3:906803 250 250 100.00
879e1e68 29 U-B----4181 3:907053 250 250 100.00
879e1ea8 30 U-B----4182 3:907303 250 250 100.00
879e1ee8 31 U-B----4183 3:907553 250 250 100.00
879e1f28 32 U-B----4184 3:907803 250 250 100.00
879e1f68 33 U-B----4185 3:908053 250 250 100.00
879e1fa8 34 U-B----4186 3:908303 250 250 100.00
8779aaf0 35 U-B----4187 3:908553 250 250 100.00
8779ab30 4 U-B----4188 3:900803 250 250 100.00
8779ab70 5 U-B----4189 3:901053 250 250 100.00
8779abb0 7 U-B----4190 3:901553 250 250 100.00
8779abf0 8 U-B----4191 3:901803 250 250 100.00
8779ac30 13 U-B----4192 3:903053 250 250 100.00
8779ac70 14 U-B----4193 3:903303 250 250 100.00
8779acb0 17 U-B----4194 3:904053 250 250 100.00
8779acf0 18 U-B----4195 3:904303 250 250 100.00
8779ad30 19 U-B----4196 3:904553 250 250 100.00
8779ad70 22 U-B----4197 3:905303 250 250 100.00
8779adb0 23 U-B----4198 3:905553 250 250 100.00
8779adf0 24 U-B----4199 3:905803 250 250 100.00
8779ae30 94 U-B----4200 3:923303 250 250 100.00
8779ae70 95 U-B----4201 3:923553 250 250 100.00
8779aeb0 96 U-B----4202 3:923803 250 250 100.00
8779aef0 97 U-B----4203 3:924053 250 250 100.00
8779af30 98 U-B----4204 3:924303 250 250 100.00
8779af70 99 U-B----4205 3:924553 250 250 100.00
8779afb0 100 U-B----4206 3:924803 250 250 100.00
879d2830 101 U-B----4207 3:925053 250 250 100.00
879d2870 102 U-B----4208 3:925303 250 250 100.00
879d28b0 103 U-B----4209 3:925553 250 250 100.00
879d28f0 104 U-B----4210 3:925803 250 250 100.00
879d2930 105 U-B----4211 3:926053 250 250 100.00
879d2970 25 U-B----4212 3:906053 250 250 100.00
879d29b0 26 U-B----4213 3:906303 250 250 100.00
879d29f0 116 U-B----4214 3:928803 250 250 100.00
879d2a30 117 U-B----4215 3:929053 250 250 100.00
879d2a70 118 U-B----4216 3:929303 250 250 100.00
879d2ab0 119 U-B----4217 3:929553 250 250 100.00
879d2af0 120 U-B----4218 3:929803 250 250 100.00
879d2b30 121 U-B----4219 3:930053 250 250 100.00
879d2b70 122 U-B----4220 3:930303 250 250 100.00
879d2bb0 123 U-B----4221 3:930553 250 250 100.00
879d2bf0 124 U-B----4222 3:930803 250 250 100.00
879d2c30 125 U-B----4223 3:931053 250 250 100.00
879d2c70 126 U-B----4224 3:931303 250 250 100.00
879d2cb0 127 U-B----4225 3:931553 250 250 100.00
879d2cf0 128 U-B----4226 3:931803 250 250 100.00
879d2d30 129 U-B----4227 3:932053 250 250 100.00
879d2d70 130 U-B----4228 3:932303 250 250 100.00
879d2db0 131 U-B----4229 3:932553 250 250 100.00
879d2df0 132 U-B----4230 3:932803 250 250 100.00
879d2e30 133 U-B----4231 3:933053 250 250 100.00
879d2e70 134 U-B----4232 3:933303 250 193 77.20
879d2eb0 135 U---C-L4233 3:933553 250 250 100.00
879d2ef0 27 U-B----4099 3:906553 250 250 100.00
879d2f30 20 U-B----4100 3:904803 250 250 100.00
879d2f70 21 U-B----4101 3:905053 250 250 100.00
879d2fb0 15 U-B----4102 3:903553 250 250 100.00
87fa8018 16 U-B----4103 3:903803 250 250 100.00
87fa8058 11 U-B----4104 3:902553 250 250 100.00
87fa8098 12 U-B----4105 3:902803 250 250 100.00
87fa80d8 36 U-B----4106 3:908803 250 250 100.00
87fa8118 37 U-B----4107 3:909053 250 250 100.00
87fa8158 38 U-B----4108 3:909303 250 250 100.00
87fa8198 39 U-B----4109 3:909553 250 250 100.00
87fa81d8 40 U-B----4110 3:909803 250 250 100.00
87fa8218 41 U-B----4111 3:910053 250 250 100.00
87fa8258 54 U-B----4112 3:913303 250 250 100.00
87fa8298 55 U-B----4113 3:913553 250 250 100.00
87fa82d8 56 U-B----4114 3:913803 250 250 100.00
87fa8318 57 U-B----4115 3:914053 250 250 100.00
87fa8358 58 U-B----4116 3:914303 250 250 100.00
87fa8398 59 U-B----4117 3:914553 250 250 100.00
87fa83d8 79 U-B----4118 3:919553 250 250 100.00
87fa8418 80 U-B----4119 3:919803 250 250 100.00
87fa8458 81 U-B----4120 3:920053 250 250 100.00
87fa8498 82 U-B----4121 3:920303 250 250 100.00
87fa84d8 83 U-B----4122 3:920553 250 250 100.00
87fa8518 84 U-B----4123 3:920803 250 250 100.00
87fa8558 85 U-B----4124 3:921053 250 250 100.00
87fa8598 86 U-B----4125 3:921303 250 250 100.00
87fa85d8 87 U-B----4126 3:921553 250 250 100.00
87fa8618 88 U-B----4127 3:921803 250 250 100.00
87fa8658 89 U-B----4128 3:922053 250 250 100.00
87fa8698 106 U-B----4129 3:926303 250 250 100.00
87fa86d8 107 U-B----4130 3:926553 250 250 100.00
87fa8718 108 U-B----4131 3:926803 250 250 100.00
87fa8758 109 U-B----4132 3:927053 250 250 100.00
87fa8798 110 U-B----4133 3:927303 250 250 100.00
87fa87d8 111 U-B----4134 3:927553 250 250 100.00
87fa8818 112 U-B----4135 3:927803 250 250 100.00
87fa8858 113 U-B----4136 3:928053 250 250 100.00
87fa8898 114 U-B----4137 3:928303 250 250 100.00
87fa88d8 115 U-B----4138 3:928553 250 250 100.00
87fa8918 90 U-B----4139 3:922303 250 250 100.00
87fa8958 91 U-B----4140 3:922553 250 250 100.00
87fa8998 92 U-B----4141 3:922803 250 250 100.00
87fa89d8 93 U-B----4142 3:923053 250 250 100.00
87fa8a18 60 U-B----4143 3:914803 250 250 100.00
87fa8a58 61 U-B----4144 3:915053 250 250 100.00
87fa8a98 62 U-B----4145 3:915303 250 250 100.00
87fa8ad8 63 U-B----4146 3:915553 250 250 100.00
87fa8b18 64 U-B----4147 3:915803 250 250 100.00
87fa8b58 65 U-B----4148 3:916053 250 250 100.00
87fa8b98 66 U-B----4149 3:916303 250 250 100.00
87fa8bd8 67 U-B----4150 3:916553 250 250 100.00
87fa8c18 70 U-B----4151 3:917303 250 250 100.00
87fa8c58 71 U-B----4152 3:917553 250 250 100.00
87fa8c98 68 U-B----4153 3:916803 250 250 100.00
87fa8cd8 69 U-B----4154 3:917053 250 250 100.00
87fa8d18 42 U-B----4155 3:910303 250 250 100.00
87fa8d58 43 U-B----4156 3:910553 250 250 100.00
87fa8d98 44 U-B----4157 3:910803 250 250 100.00
87fa8dd8 72 U-B----4158 3:917803 250 250 100.00
87fa8e18 73 U-B----4159 3:918053 250 250 100.00
87fa8e58 74 U-B----4160 3:918303 250 250 100.00
87fa8e98 75 U-B----4161 3:918553 250 250 100.00
87fa8ed8 76 U-B----4162 3:918803 250 250 100.00
87fa8f18 77 U-B----4163 3:919053 250 250 100.00
87fa8f58 78 U-B----4164 3:919303 250 250 100.00
87fa8f98 47 U-B----4165 3:911553 250 250 100.00
87fa8fd8 48 U-B----4166 3:911803 250 250 100.00
87fa9018 49 U-B----4167 3:912053 250 250 100.00
87fa9058 50 U-B----4168 3:912303 250 250 100.00
87fa9098 51 U-B----4169 3:912553 250 250 100.00
87fa90d8 52 U-B----4170 3:912803 250 250 100.00
87fa9118 53 U-B----4171 3:913053 250 250 100.00
87fa9158 45 U-B----4172 3:911053 250 250 100.00
87fa9198 46 U-B----4173 3:911303 250 250 100.00
135 active, 135 total
onstat -d
$ onstat -d
IBM Informix Dynamic Server Version 9.40.UC2 -- Fast Recovery (CKPT REQ) -- Up 00:02:36 -- 1186324 Kbytes
Blocked:CKPT
Dbspaces
addressnumber flags fchunk nchunksflags owner name
8779a7d8 1 0x20001 1 1 N informix rootdbs
87fa9b08 2 0x60001 2 3 NB informix datadbs
87fa9c58 3 0x20001 3 1 N informix logdbs
87fa9da8 4 0x42001 4 1 N TB informix tempdbs
880a6018 5 0x20001 7 1 N informix gapsdbs
5 active, 2047 maximum
Chunks
addresschunk/dbsoffset size free bpages flags pathname
8779a928 1 1 0 100000 97020 PO--/dbdata/ids940data/rootdbs
87fa91d8 2 2 0 3000000 39 PO-B/dbdata/ids940data/datadbs
87fa9360 3 3 0 1000000 66197 PO--/dbdata/ids940data/logdbs
87fa94e8 4 4 0 2000000 0 PD-B/dbdata/ids940data/tempdbs
87fa9670 5 2 0 3000000 1110489 PO-B/dbdata/ids940data/datadbs1
87fa97f8 6 2 0 1000000 999997 PO-B/dbdata/ids940data/datadbs2
87fa9980 7 5 128 500000 180538 PO--/dbdata/ids940data/datadbsgaps
7 active, 2047 maximum
Expanded chunk capacity mode: disabled
ontape -s -L 0也不行,onmode -Z 也不行。。
加逻辑日志或扩表空间也不行。 昨天才处理了一起这样的情况,只能截日志了,我用的是HP下的7.31的工具,在你的平台下用不了的! ...你那个tempdbs宕了吧。。
把参数改到rootdbs上再启动下。。 回复 1# H13900000000
试试oninit -p? 昨天才处理了一起这样的情况,只能截日志了,我用的是HP下的7.31的工具,在你的平台下用不了的!
yunzhongyue 发表于 2011-09-08 15:43 http://bbs.chinaunix.net/images/common/back.gif
temp表空间挂了也可以截日志么,这是什么个原理? 本帖最后由 yunzhongyue 于 2011-09-18 12:06 编辑
没仔细看,以为是别的问题呢!
页:
[1]