!!紧急求助!oninit -v时,有几个表空间坏掉导致启动不起来了。如何绕过这个错误继
Initializing dbspaces...succeededOpening primary chunks...Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsproddbs'.
Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsacctdbs'.
Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsinterfacedbs'.
Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsbilldbs'.
Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tscashbilldb'.
succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded
WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors. 我已经把etc/onconfig 的DATASKIP 参数改成 ALL 了,还是照样启动不起来。查看online.log有:
18:18:15IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000
18:18:15Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsproddbs'.
18:18:15Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsacctdbs'.
18:18:15Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsinterfacedbs'.
18:18:15Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsbilldbs'.
18:18:15Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tscashbilldb'.
18:18:18IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
18:18:18Started 1 B-tree scanners.
18:18:18B-tree scanner threshold set at 5000.
18:18:18B-tree scanner range scan size set to -1.
18:18:18B-tree scanner ALICE mode set to 6.
18:18:18B-tree scanner index compression level set to med.
18:18:18Physical Recovery Started at Page (1:4162).
18:18:18Physical Recovery Complete: 497 Pages Examined, 496 Pages Restored.
18:18:18Assert Warning: pthdrpage:ptalloc:bad bfget
18:18:18IBM Informix Dynamic Server Version 11.50.FC9
18:18:18 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7243
18:18:18 Results: Cannot use TBLSpace page for TBLSpace 17825793
18:18:18 Action: Run 'oncheck -pt 17825793'
18:18:18stack trace for pid 17171338 written to /informix/tmp/af.4164dea
18:18:18 See Also: /informix/tmp/af.4164dea
18:18:18pthdrpage:ptalloc:bad bfget
18:18:19Assert Failed: Chunk 28 is being taken OFFLINE.
18:18:19IBM Informix Dynamic Server Version 11.50.FC9
18:18:19 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7267
18:18:19 Results: Cannot Open DBspace 17.
18:18:19 Action: Restore space containing this chunk from the archive. 关键dbspace的chunk不能offline,不然还是起不来。。
看你这个,数据库应该已经启来了,只是需要对这个chunk进行恢复。。。 没有启动起来哦:
onstat -d
shared memory not initialized for INFORMIXSERVER 'cq_dev' 详细的online.log信息:
18:52:52IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000
18:52:52Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsproddbs'.
18:52:52Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsacctdbs'.
18:52:52Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsinterfacedbs'.
18:52:52Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsbilldbs'.
18:52:52Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tscashbilldb'.
18:52:55IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
18:52:55Started 1 B-tree scanners.
18:52:55B-tree scanner threshold set at 5000.
18:52:55B-tree scanner range scan size set to -1.
18:52:55B-tree scanner ALICE mode set to 6.
18:52:55B-tree scanner index compression level set to med.
18:52:55Physical Recovery Started at Page (1:4162).
18:52:55Physical Recovery Complete: 497 Pages Examined, 496 Pages Restored.
18:52:55Assert Warning: pthdrpage:ptalloc:bad bfget
18:52:55IBM Informix Dynamic Server Version 11.50.FC9
18:52:55 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7243
18:52:55 Results: Cannot use TBLSpace page for TBLSpace 17825793
18:52:55 Action: Run 'oncheck -pt 17825793'
18:52:55stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:52:55 See Also: /informix/tmp/af.4165607
18:52:55pthdrpage:ptalloc:bad bfget
18:52:55Assert Failed: Chunk 28 is being taken OFFLINE.
18:52:55IBM Informix Dynamic Server Version 11.50.FC9
18:52:55 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7267
18:52:55 Results: Cannot Open DBspace 17.
18:52:55 Action: Restore space containing this chunk from the archive.
18:52:55stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:52:56 See Also: /informix/tmp/af.4165607, shmem.4165607.0
18:53:05Chunk 28 is being taken OFFLINE.
18:53:05Assert Warning: Chunk 28 is being taken OFFLINE.
18:53:05IBM Informix Dynamic Server Version 11.50.FC9
18:53:05 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rsmirror.c Line: 1900
18:53:05 Results: Dynamic Server will block at next checkpoint
18:53:05 Action: Shutdown (onmode -k) or override (onmode -O)
18:53:05stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:05 See Also: /informix/tmp/af.4165607
18:53:06Chunk 28 is being taken OFFLINE.
18:53:06Cannot Open DBspace 17.
18:53:06Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:06IBM Informix Dynamic Server Version 11.50.FC9
18:53:06 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7243
18:53:06 Results: Cannot use TBLSpace page for TBLSpace 18874369
18:53:06 Action: Run 'oncheck -pt 18874369'
18:53:06stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:06 See Also: /informix/tmp/af.4165607
18:53:07pthdrpage:ptalloc:bad bfget
18:53:07Assert Failed: Chunk 29 is being taken OFFLINE.
18:53:07IBM Informix Dynamic Server Version 11.50.FC9
18:53:07 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7267
18:53:07 Results: Cannot Open DBspace 18.
18:53:07 Action: Restore space containing this chunk from the archive.
18:53:07stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:07 See Also: /informix/tmp/af.4165607
18:53:10Chunk 29 is being taken OFFLINE.
18:53:10Assert Warning: Chunk 29 is being taken OFFLINE.
18:53:10IBM Informix Dynamic Server Version 11.50.FC9
18:53:10 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rsmirror.c Line: 1900
18:53:10 Results: Dynamic Server will block at next checkpoint
18:53:10 Action: Shutdown (onmode -k) or override (onmode -O)
18:53:10stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:11 See Also: /informix/tmp/af.4165607
18:53:11Chunk 29 is being taken OFFLINE.
18:53:11Cannot Open DBspace 18.
18:53:11Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:11IBM Informix Dynamic Server Version 11.50.FC9
18:53:11 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7243
18:53:11 Results: Cannot use TBLSpace page for TBLSpace 19922945
18:53:11 Action: Run 'oncheck -pt 19922945'
18:53:11stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:11 See Also: /informix/tmp/af.4165607
18:53:12pthdrpage:ptalloc:bad bfget
18:53:12Assert Failed: Chunk 30 is being taken OFFLINE.
18:53:12IBM Informix Dynamic Server Version 11.50.FC9
18:53:12 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7267
18:53:12 Results: Cannot Open DBspace 19.
18:53:12 Action: Restore space containing this chunk from the archive.
18:53:12stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:12 See Also: /informix/tmp/af.4165607
18:53:15Chunk 30 is being taken OFFLINE.
18:53:16Assert Warning: Chunk 30 is being taken OFFLINE.
18:53:16IBM Informix Dynamic Server Version 11.50.FC9
18:53:16 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rsmirror.c Line: 1900
18:53:16 Results: Dynamic Server will block at next checkpoint
18:53:16 Action: Shutdown (onmode -k) or override (onmode -O)
18:53:16stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:16 See Also: /informix/tmp/af.4165607
18:53:16Chunk 30 is being taken OFFLINE.
18:53:16Cannot Open DBspace 19.
18:53:16Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:16IBM Informix Dynamic Server Version 11.50.FC9
18:53:16 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7243
18:53:16 Results: Cannot use TBLSpace page for TBLSpace 20971521
18:53:16 Action: Run 'oncheck -pt 20971521'
18:53:16stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:16 See Also: /informix/tmp/af.4165607
18:53:17pthdrpage:ptalloc:bad bfget
18:53:17Assert Failed: Chunk 31 is being taken OFFLINE.
18:53:17IBM Informix Dynamic Server Version 11.50.FC9
18:53:17 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7267
18:53:17 Results: Cannot Open DBspace 20.
18:53:17 Action: Restore space containing this chunk from the archive.
18:53:17stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:18 See Also: /informix/tmp/af.4165607
18:53:20Chunk 31 is being taken OFFLINE.
18:53:21Assert Warning: Chunk 31 is being taken OFFLINE.
18:53:21IBM Informix Dynamic Server Version 11.50.FC9
18:53:21 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rsmirror.c Line: 1900
18:53:21 Results: Dynamic Server will block at next checkpoint
18:53:21 Action: Shutdown (onmode -k) or override (onmode -O)
18:53:21stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:21 See Also: /informix/tmp/af.4165607
18:53:21Chunk 31 is being taken OFFLINE.
18:53:21Cannot Open DBspace 20.
18:53:22Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:22IBM Informix Dynamic Server Version 11.50.FC9
18:53:22 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7243
18:53:22 Results: Cannot use TBLSpace page for TBLSpace 22020097
18:53:22 Action: Run 'oncheck -pt 22020097'
18:53:22stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:22 See Also: /informix/tmp/af.4165607
18:53:22pthdrpage:ptalloc:bad bfget
18:53:22Assert Failed: Chunk 32 is being taken OFFLINE.
18:53:22IBM Informix Dynamic Server Version 11.50.FC9
18:53:22 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rspartn.c Line: 7267
18:53:23 Results: Cannot Open DBspace 21.
18:53:23 Action: Restore space containing this chunk from the archive.
18:53:23stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:23 See Also: /informix/tmp/af.4165607
18:53:26Chunk 32 is being taken OFFLINE.
18:53:26Assert Warning: Chunk 32 is being taken OFFLINE.
18:53:26IBM Informix Dynamic Server Version 11.50.FC9
18:53:26 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(46, fast_rec, 70000004034aa90, 1)
File: rsmirror.c Line: 1900
18:53:26 Results: Dynamic Server will block at next checkpoint
18:53:26 Action: Shutdown (onmode -k) or override (onmode -O)
18:53:26stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:26 See Also: /informix/tmp/af.4165607
18:53:27Chunk 32 is being taken OFFLINE.
18:53:27Cannot Open DBspace 21.
18:53:27Logical Recovery Started.
18:53:2710 recovery worker threads will be started.
18:53:27Assert Warning: Error during recovery left index inconsistent.
18:53:27IBM Informix Dynamic Server Version 11.50.FC9
18:53:27 Who: Session(7, informix@localhost, 0, 700000040389e90)
Thread(55, xchg_1.5, 70000004034f488, 1)
File: rskey.c Line: 1645
18:53:27 Results: Index 'sysadmin:"informix".mon_table_names#mon_table_names_idx1' is now unusable
18:53:27 Action: Run 'oncheck -cI sysadmin:"informix".mon_table_names#mon_table_names_idx1'
18:53:27stack trace for pid 17498650 written to /informix/tmp/af.41f5627
18:53:28 See Also: /informix/tmp/af.41f5627
18:53:28Error during recovery left index inconsistent.
18:53:31Rollforward of log record failed. iserrno = 105
18:53:31Log Record: log = 447, pos = 0x67bbc4, type = OLDRSAM:ADDITEM(28), trans = 19
18:53:31Rollforward of log record failed. iserrno = 105
18:53:31Log Record: log = 447, pos = 0x67bbc4, type = OLDRSAM:ADDITEM(28), trans = 19
18:53:31Assert Warning: Error during recovery left index inconsistent.
18:53:31IBM Informix Dynamic Server Version 11.50.FC9
18:53:31 Who: Session(7, informix@localhost, 0, 700000040389e90)
Thread(59, xchg_1.9, 700000040351568, 1)
File: rskey.c Line: 1645
18:53:31 Results: Index 'prod:"informix".pricing_plan_group# 1364_7161' is now unusable
18:53:31 Action: Run 'oncheck -cI prod:"informix".pricing_plan_group# 1364_7161'
18:53:31stack trace for pid 17498650 written to /informix/tmp/af.423562b
18:53:32 See Also: /informix/tmp/af.423562b
18:53:32Error during recovery left index inconsistent.
18:53:35Rollforward of log record failed. iserrno = 105
18:53:35Log Record: log = 447, pos = 0xb190ac, type = OLDRSAM:ADDITEM(28), trans = 95
18:53:35Rollforward of log record failed. iserrno = 105
18:53:35Log Record: log = 447, pos = 0xb190ac, type = OLDRSAM:ADDITEM(28), trans = 95
18:53:37Rollforward of log record failed. iserrno = 126
18:53:37Log Record: log = 447, pos = 0xb19050, type = OLDRSAM:HINSERT(40), trans = 95
18:53:37Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:37IBM Informix Dynamic Server Version 11.50.FC9
18:53:37 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(50, xchg_1.0, 70000004034cb70, 1)
File: rspartn.c Line: 7243
18:53:37 Results: Cannot use TBLSpace page for TBLSpace 2098040
18:53:37 Action: Run 'oncheck -pt 2098040'
18:53:37stack trace for pid 17498650 written to /informix/tmp/af.41a5631
18:53:37 See Also: /informix/tmp/af.41a5631
18:53:37pthdrpage:ptalloc:bad bfget
18:53:40Rollforward of log record failed. iserrno = 135
18:53:40Log Record: log = 447, pos = 0xb1a1e8, type = OLDRSAM:ADDITEM(28), trans = 95
18:53:40Rollforward of log record failed. iserrno = 135
18:53:40Log Record: log = 447, pos = 0xb1a1e8, type = OLDRSAM:ADDITEM(28), trans = 95
18:53:40Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:40IBM Informix Dynamic Server Version 11.50.FC9
18:53:40 Who: Session(7, informix@localhost, 0, 700000040389230)
Thread(53, xchg_1.3, 70000004034e418, 1)
File: rspartn.c Line: 7243
18:53:40 Results: Cannot use TBLSpace page for TBLSpace 2098343
18:53:40 Action: Run 'oncheck -pt 2098343'
18:53:40stack trace for pid 17498650 written to /informix/tmp/af.41d5634
18:53:40 See Also: /informix/tmp/af.41d5634
18:53:41pthdrpage:ptalloc:bad bfget
18:53:43Rollforward of log record failed. iserrno = 135
18:53:43Log Record: log = 447, pos = 0xb1a230, type = OLDRSAM:ADDITEM(28), trans = 95
18:53:43Rollforward of log record failed. iserrno = 135
18:53:43Log Record: log = 447, pos = 0xb1a230, type = OLDRSAM:ADDITEM(28), trans = 95
18:53:43Assert Failed: INFORMIX-OnLine Must ABORT
Critical media failure.
18:53:43IBM Informix Dynamic Server Version 11.50.FC9
18:53:43 Who: Session(7, informix@localhost, 0, 700000040389e90)
Thread(57, xchg_1.7, 7000000403504f8, 1)
File: rsmirror.c Line: 1832
18:53:43stack trace for pid 17498650 written to /informix/tmp/af.421562f
18:53:44 See Also: /informix/tmp/af.421562f, shmem.421562f.0
18:53:53rsmirror.c, line 1832, thread 57, proc id 17498650, INFORMIX-OnLine Must ABORT
Critical media failure..
18:53:53PANIC: Attempting to bring system down
18:53:58Checkpoint Completed:duration was 0 seconds.
18:53:58Fri Mar 23 - loguniq 32, logpos 0x74018, timestamp: 0x368a1e32 Interval: 1602 我对比了一下正常流程,应该是到了
Checking database partition index
这一步的时候出错了。求解!!! 回复 6# Oo烟花火
从备份中恢复吧~(先确认下所有的chunk对应的文件都正常) 怎么恢复呢?如何备份的? 测试的服务器貌似没有设置备份……
ontape 指向 /dev/null 了…… 打800吧。。
页:
[1]
2