Oo烟花火 发表于 2012-03-23 17:45

!!紧急求助!oninit -v时,有几个表空间坏掉导致启动不起来了。如何绕过这个错误继

Initializing dbspaces...succeeded
Opening 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.

Oo烟花火 发表于 2012-03-23 18:22

我已经把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.

liaosnet 发表于 2012-03-23 18:35

关键dbspace的chunk不能offline,不然还是起不来。。

看你这个,数据库应该已经启来了,只是需要对这个chunk进行恢复。。。

Oo烟花火 发表于 2012-03-23 18:46

没有启动起来哦:
onstat -d
shared memory not initialized for INFORMIXSERVER 'cq_dev'

Oo烟花火 发表于 2012-03-23 18:56

详细的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

Oo烟花火 发表于 2012-03-23 21:08

我对比了一下正常流程,应该是到了
Checking database partition index
这一步的时候出错了。求解!!!

liaosnet 发表于 2012-03-23 21:09

回复 6# Oo烟花火


    从备份中恢复吧~(先确认下所有的chunk对应的文件都正常)

Oo烟花火 发表于 2012-03-23 21:10

怎么恢复呢?如何备份的?

Oo烟花火 发表于 2012-03-23 21:23

测试的服务器貌似没有设置备份……

ontape 指向 /dev/null   了……

hugolin168 发表于 2012-03-26 10:30

打800吧。。
页: [1] 2
查看完整版本: !!紧急求助!oninit -v时,有几个表空间坏掉导致启动不起来了。如何绕过这个错误继