求助，数据库down不能正常启动！！！

XJBS_1977

我的数据库是informix 7.31。今天不能正常启动：
1、用oninit启动时提示如下：
oninit: Cannot open chunk '/usr/informix/dbf/datadbs'. errno = 2
$ Unable to open input file 's'
Unable to open input file 'c'

2、用onstat - 察看数据库状态如下：
Informix Dynamic Server Version 7.31.UC7    -- On-Line (CKPT REQ) -- Up 00:30:1s
Blocked:CKPT

3、online.log中的内容如下：
11:27:13  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/log_full.sh'
11:27:18  DR: DRAUTO is 0 (Off)
11:27:18  Requested shared memory segment size rounded from 484KB to 4096KB
11:27:18  Informix Dynamic Server Version 7.31.UC7    Software Serial Number ACP#J267193
11:27:18  Assert Failed: chunk failed sanity check

11:27:18  Informix Dynamic Server Version 7.31.UC7   
11:27:18   Who: Session(1, informix@qiantai, 0, 28155086
                Thread(7, main_loop(), 10c5a014, 1)
                File: rspartn.c Line: 7262
11:27:18   Results: Chunk 2 is being taken OFFLINE.
11:27:18   Action: Restore chunk from archive. If this is a temporary dbspace
        chunk, drop and add the dbspace to enable it.
11:27:19   See Also: /tmp/af.3ef67d6
11:27:19  I/O error, Primary Chunk '/usr/informix/dbf/datadbs' -- Offline (sanity)
11:27:20  Informix Dynamic Server Initialized -- Shared Memory Initialized.
11:27:20  Physical Recovery Started.
11:27:20  Assert Failed: Chunk 2 is being taken OFFLINE.
11:27:20  Informix Dynamic Server Version 7.31.UC7   
11:27:20   Who: Session(8, informix@qiantai, 0, 281552292)
                Thread(20, fast_rec, 10c5b3b4, 1)
                File: rspartn.c Line: 5282
11:27:20   Results: Cannot Open DBspace 2.
11:27:20   Action: Restore chunk from archive. If this is a temporary dbspace
        chunk, drop and add the dbspace to enable it.
11:27:22   See Also: /tmp/af.3fc67d8, shmem.3fc67d8.0
11:27:23  Assert Failed: Chunk 2 is being taken OFFLINE.
11:27:23  Informix Dynamic Server Version 7.31.UC7   
11:27:23   Who: Session(8, informix@qiantai, 0, 281552292)
                Thread(20, fast_rec, 10c5b3b4, 1)
                File: rsmirror.c Line: 1784
11:27:23   Results: Dynamic Server will block at next checkpoint
11:27:23   Action: Shutdown (onmode -k) or override (onmode -O)
11:27:23   See Also: /tmp/af.3fc67d8
11:27:23  Assert Failed: pthdrpage:ptalloc:bad bfget
11:27:23  Informix Dynamic Server Version 7.31.UC7   
11:27:23   Who: Session(8, informix@qiantai, 0, 281552292)
                Thread(20, fast_rec, 10c5b3b4, 1)
                File: rspartn.c Line: 5316
11:27:23   Results: Cannot use TBLSpace page for TBLSpace 2097153
11:27:23   Action: Run 'oncheck -pt 2097153'
11:27:23   See Also: /tmp/af.3fc67d8
11:27:23  Cannot Open DBspace 2.
11:27:23  Physical Recovery Complete: 0 Pages Restored.
11:27:23  Logical Recovery Started.
11:27:25  Logical Recovery Complete.
        0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:27:26  Dataskip is now OFF for all dbspaces
11:27:26  On-Line Mode
11:27:26  Checkpoint blocked by down space, waiting for override or shutdown

请路过的高手帮忙看一下，可能是什么原因造成的。有没有办法不用重新初始化数据库，直接恢复数据。
有点急，在线等。

liaosnet

Assert Failed: Chunk 2 is being taken OFFLINE.

检查下chunk号为2的chunk存在问题~~~
如果是tempdbs，重建就好，如果是其它dbs，只能重备份恢复。

XJBS_1977

原帖由 liaosnet 于 2007-4-28 16:34 发表
Assert Failed: Chunk 2 is being taken OFFLINE.

检查下chunk号为2的chunk存在问题~~~
如果是tempdbs，重建就好，如果是其它dbs，只能重备份恢复。

我的chunk号是2的chunk是datadbs。看来只能从备份恢复了。我想问一下有办法从日志恢复吗？？？

liaosnet

日志恢复也得先从备份恢复~~~日志有备份再从日志。