在UNIX平台上informix数据,由于没有正确操作,直接REBOOT,就这一下数据库就不能
ONLINE,看online.log,是数据库在建立索引时failed,页被破坏,用informix用户登录,onmonitor中状态是recovery.用oncheck亦无效,下面是部分online.log
16:10:05 INFORMIX-OnLine Stopped.Wed Nov 7 16:10:21 200116:10:21 Event alarms enabled. ALARMPROG = '/usr/informix/log_full.sh'
16:10:27 DR: DRAUTO is 0 (Off)
16:10:28 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
16:10:28 Physical Recovery Started.
16:10:29 Physical Recovery Complete: 0 Pages Restored.
16:10:29 Logical Recovery Started.
16:10:31 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks16:10:32 Dataskip is now OFF for all dbspaces
16:10:32 On-Line Mode
16:10:32 Checkpoint Completed: duration was 0 seconds.
16:15:35 Checkpoint Completed: duration was 0 seconds.Wed Oct 16 12:29:45 200212:29:45 Event alarms enabled. ALARMPROG = '/usr/informix/log_full.sh'
12:29:50 DR: DRAUTO is 0 (Off)
12:29:51 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
ONLINE,看online.log,是数据库在建立索引时failed,页被破坏,用informix用户登录,onmonitor中状态是recovery.用oncheck亦无效,下面是部分online.log
16:10:05 INFORMIX-OnLine Stopped.Wed Nov 7 16:10:21 200116:10:21 Event alarms enabled. ALARMPROG = '/usr/informix/log_full.sh'
16:10:27 DR: DRAUTO is 0 (Off)
16:10:28 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
16:10:28 Physical Recovery Started.
16:10:29 Physical Recovery Complete: 0 Pages Restored.
16:10:29 Logical Recovery Started.
16:10:31 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks16:10:32 Dataskip is now OFF for all dbspaces
16:10:32 On-Line Mode
16:10:32 Checkpoint Completed: duration was 0 seconds.
16:15:35 Checkpoint Completed: duration was 0 seconds.Wed Oct 16 12:29:45 200212:29:45 Event alarms enabled. ALARMPROG = '/usr/informix/log_full.sh'
12:29:50 DR: DRAUTO is 0 (Off)
12:29:51 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货