求助，数据库down不能正常启动！！！
我的数据库是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:13Event alarms enabled.ALARMPROG = '/usr/informix/etc/log_full.sh'
11:27:18DR: DRAUTO is 0 (Off)
11:27:18Requested shared memory segment size rounded from 484KB to 4096KB
11:27:18Informix Dynamic Server Version 7.31.UC7 Software Serial Number ACP#J267193
11:27:18Assert Failed: chunk failed sanity check
11:27:18Informix Dynamic Server Version 7.31.UC7
11:27:18 Who: Session(1, informix@qiantai, 0, 281550868)
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:19I/O error, Primary Chunk '/usr/informix/dbf/datadbs' -- Offline (sanity)
11:27:20Informix Dynamic Server Initialized -- Shared Memory Initialized.
11:27:20Physical Recovery Started.
11:27:20Assert Failed: Chunk 2 is being taken OFFLINE.
11:27:20Informix 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:23Assert Failed: Chunk 2 is being taken OFFLINE.
11:27:23Informix 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:23Assert Failed: pthdrpage:ptalloc:bad bfget
11:27:23Informix 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:23Cannot Open DBspace 2.
11:27:23Physical Recovery Complete: 0 Pages Restored.
11:27:23Logical Recovery Started.
11:27:25Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
11:27:26Dataskip is now OFF for all dbspaces
11:27:26On-Line Mode
11:27:26Checkpoint blocked by down space, waiting for override or shutdown
请路过的高手帮忙看一下，可能是什么原因造成的。有没有办法不用重新初始化数据库，直接恢复数据。
有点急，在线等。 Assert Failed: Chunk 2 is being taken OFFLINE.
检查下chunk号为2的chunk存在问题~~~
如果是tempdbs，重建就好，如果是其它dbs，只能重备份恢复。 原帖由 liaosnet 于 2007-4-28 16:34 发表
Assert Failed: Chunk 2 is being taken OFFLINE.
检查下chunk号为2的chunk存在问题~~~
如果是tempdbs，重建就好，如果是其它dbs，只能重备份恢复。
我的chunk号是2的chunk是datadbs。看来只能从备份恢复了。我想问一下有办法从日志恢复吗？？？ 日志恢复也得先从备份恢复~~~日志有备份再从日志。
页:
[1]