��！緊急求助！oninit -v時，有幾個表空間壞掉導致啟動不起來了。如何繞過這個錯誤繼

Oo煙花火

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煙花火

我已經把etc/onconfig 的DATASKIP 參數改成 ALL 了，還是照樣啟動不起來。查看online.log有：
18:18:15  IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000
18:18:15  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsproddbs'.
18:18:15  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsacctdbs'.
18:18:15  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsinterfacedbs'.
18:18:15  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsbilldbs'.
18:18:15  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tscashbilldb'.
18:18:18  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

18:18:18  Started 1 B-tree scanners.
18:18:18  B-tree scanner threshold set at 5000.
18:18:18  B-tree scanner range scan size set to -1.
18:18:18  B-tree scanner ALICE mode set to 6.
18:18:18  B-tree scanner index compression level set to med.
18:18:18  Physical Recovery Started at Page (1:4162).
18:18:18  Physical Recovery Complete: 497 Pages Examined, 496 Pages Restored.
18:18:18  Assert Warning: pthdrpage:ptalloc:bad bfget
18:18:18  IBM 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:18  stack trace for pid 17171338 written to /informix/tmp/af.4164dea
18:18:18   See Also: /informix/tmp/af.4164dea
18:18:18  pthdrpage:ptalloc:bad bfget
18:18:19  Assert Failed: Chunk 28 is being taken OFFLINE.
18:18:19  IBM 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

關鍵dbspace的chunk不能offline，不然還是起不來。。

看你這個，數據庫應該已經啟來了，只是需要對這個chunk進行恢復。。。

Oo煙花火

沒有啟動起來哦：
onstat -d
shared memory not initialized for INFORMIXSERVER 'cq_dev'

Oo煙花火

詳細的online.log信息：
18:52:52  IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000
18:52:52  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsproddbs'.
18:52:52  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsacctdbs'.
18:52:52  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsinterfacedbs'.
18:52:52  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tsbilldbs'.
18:52:52  Bad Primary Chunk '/prodigy/informix/cq_olcashserver/tscashbilldb'.
18:52:55  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

18:52:55  Started 1 B-tree scanners.
18:52:55  B-tree scanner threshold set at 5000.
18:52:55  B-tree scanner range scan size set to -1.
18:52:55  B-tree scanner ALICE mode set to 6.
18:52:55  B-tree scanner index compression level set to med.
18:52:55  Physical Recovery Started at Page (1:4162).
18:52:55  Physical Recovery Complete: 497 Pages Examined, 496 Pages Restored.
18:52:55  Assert Warning: pthdrpage:ptalloc:bad bfget
18:52:55  IBM 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:55  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:52:55   See Also: /informix/tmp/af.4165607
18:52:55  pthdrpage:ptalloc:bad bfget
18:52:55  Assert Failed: Chunk 28 is being taken OFFLINE.
18:52:55  IBM 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:55  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:52:56   See Also: /informix/tmp/af.4165607, shmem.4165607.0
18:53:05  Chunk 28 is being taken OFFLINE.
18:53:05  Assert Warning: Chunk 28 is being taken OFFLINE.
18:53:05  IBM 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:05  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:05   See Also: /informix/tmp/af.4165607
18:53:06  Chunk 28 is being taken OFFLINE.
18:53:06  Cannot Open DBspace 17.
18:53:06  Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:06  IBM 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:06  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:06   See Also: /informix/tmp/af.4165607
18:53:07  pthdrpage:ptalloc:bad bfget
18:53:07  Assert Failed: Chunk 29 is being taken OFFLINE.
18:53:07  IBM 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:07  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:07   See Also: /informix/tmp/af.4165607
18:53:10  Chunk 29 is being taken OFFLINE.
18:53:10  Assert Warning: Chunk 29 is being taken OFFLINE.
18:53:10  IBM 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:10  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:11   See Also: /informix/tmp/af.4165607
18:53:11  Chunk 29 is being taken OFFLINE.
18:53:11  Cannot Open DBspace 18.
18:53:11  Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:11  IBM 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:11  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:11   See Also: /informix/tmp/af.4165607
18:53:12  pthdrpage:ptalloc:bad bfget
18:53:12  Assert Failed: Chunk 30 is being taken OFFLINE.
18:53:12  IBM 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:12  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:12   See Also: /informix/tmp/af.4165607
18:53:15  Chunk 30 is being taken OFFLINE.
18:53:16  Assert Warning: Chunk 30 is being taken OFFLINE.
18:53:16  IBM 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:16  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:16   See Also: /informix/tmp/af.4165607
18:53:16  Chunk 30 is being taken OFFLINE.
18:53:16  Cannot Open DBspace 19.
18:53:16  Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:16  IBM 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:16  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:16   See Also: /informix/tmp/af.4165607
18:53:17  pthdrpage:ptalloc:bad bfget
18:53:17  Assert Failed: Chunk 31 is being taken OFFLINE.
18:53:17  IBM 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:17  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:18   See Also: /informix/tmp/af.4165607
18:53:20  Chunk 31 is being taken OFFLINE.
18:53:21  Assert Warning: Chunk 31 is being taken OFFLINE.
18:53:21  IBM 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:21  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:21   See Also: /informix/tmp/af.4165607
18:53:21  Chunk 31 is being taken OFFLINE.
18:53:21  Cannot Open DBspace 20.
18:53:22  Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:22  IBM 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:22  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:22   See Also: /informix/tmp/af.4165607
18:53:22  pthdrpage:ptalloc:bad bfget
18:53:22  Assert Failed: Chunk 32 is being taken OFFLINE.
18:53:22  IBM 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:23  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:23   See Also: /informix/tmp/af.4165607
18:53:26  Chunk 32 is being taken OFFLINE.
18:53:26  Assert Warning: Chunk 32 is being taken OFFLINE.
18:53:26  IBM 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:26  stack trace for pid 17498650 written to /informix/tmp/af.4165607
18:53:26   See Also: /informix/tmp/af.4165607
18:53:27  Chunk 32 is being taken OFFLINE.
18:53:27  Cannot Open DBspace 21.
18:53:27  Logical Recovery Started.
18:53:27  10 recovery worker threads will be started.
18:53:27  Assert Warning: Error during recovery left index inconsistent.
18:53:27  IBM 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:27  stack trace for pid 17498650 written to /informix/tmp/af.41f5627
18:53:28   See Also: /informix/tmp/af.41f5627
18:53:28  Error during recovery left index inconsistent.
18:53:31  Rollforward of log record failed. iserrno = 105
18:53:31  Log Record: log = 447, pos = 0x67bbc4, type = OLDRSAM:ADDITEM(2, trans = 19
18:53:31  Rollforward of log record failed. iserrno = 105
18:53:31  Log Record: log = 447, pos = 0x67bbc4, type = OLDRSAM:ADDITEM(2, trans = 19
18:53:31  Assert Warning: Error during recovery left index inconsistent.
18:53:31  IBM 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:31  stack trace for pid 17498650 written to /informix/tmp/af.423562b
18:53:32   See Also: /informix/tmp/af.423562b
18:53:32  Error during recovery left index inconsistent.
18:53:35  Rollforward of log record failed. iserrno = 105
18:53:35  Log Record: log = 447, pos = 0xb190ac, type = OLDRSAM:ADDITEM(2, trans = 95
18:53:35  Rollforward of log record failed. iserrno = 105
18:53:35  Log Record: log = 447, pos = 0xb190ac, type = OLDRSAM:ADDITEM(2, trans = 95
18:53:37  Rollforward of log record failed. iserrno = 126
18:53:37  Log Record: log = 447, pos = 0xb19050, type = OLDRSAM:HINSERT(40), trans = 95
18:53:37  Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:37  IBM 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:37  stack trace for pid 17498650 written to /informix/tmp/af.41a5631
18:53:37   See Also: /informix/tmp/af.41a5631
18:53:37  pthdrpage:ptalloc:bad bfget
18:53:40  Rollforward of log record failed. iserrno = 135
18:53:40  Log Record: log = 447, pos = 0xb1a1e8, type = OLDRSAM:ADDITEM(2, trans = 95
18:53:40  Rollforward of log record failed. iserrno = 135
18:53:40  Log Record: log = 447, pos = 0xb1a1e8, type = OLDRSAM:ADDITEM(2, trans = 95
18:53:40  Assert Warning: pthdrpage:ptalloc:bad bfget
18:53:40  IBM 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:40  stack trace for pid 17498650 written to /informix/tmp/af.41d5634
18:53:40   See Also: /informix/tmp/af.41d5634
18:53:41  pthdrpage:ptalloc:bad bfget
18:53:43  Rollforward of log record failed. iserrno = 135
18:53:43  Log Record: log = 447, pos = 0xb1a230, type = OLDRSAM:ADDITEM(2, trans = 95
18:53:43  Rollforward of log record failed. iserrno = 135
18:53:43  Log Record: log = 447, pos = 0xb1a230, type = OLDRSAM:ADDITEM(2, trans = 95
18:53:43  Assert Failed: INFORMIX-OnLine Must ABORT
        Critical media failure.
18:53:43  IBM 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:43  stack trace for pid 17498650 written to /informix/tmp/af.421562f
18:53:44   See Also: /informix/tmp/af.421562f, shmem.421562f.0
18:53:53  rsmirror.c, line 1832, thread 57, proc id 17498650, INFORMIX-OnLine Must ABORT
        Critical media failure..
18:53:53  PANIC: Attempting to bring system down
18:53:58  Checkpoint Completed:  duration was 0 seconds.
18:53:58  Fri Mar 23 - loguniq 32, logpos 0x74018, timestamp: 0x368a1e32 Interval: 1602

Oo煙花火

我對比了一下正常流程，應該是到了
Checking database partition index
這一步的時候出錯了。求解�。�！

liaosnet

回復 6# Oo煙花火


    從備份中恢復吧～（先確認下所有的chunk對應的文件都正常）

Oo煙花火

怎么恢復呢？如何備份的？

Oo煙花火

測試的服務器貌似沒有設置備份……

ontape 指向 /dev/null   了……

hugolin168

打800吧。。