informix起不来了

oninit -PHY 是内部用法，用于恢复HDR或者RSS中的 secondary收起

informix@dmsrvr:~> onstat -

IBM Informix Dynamic Server Version 11.50.UC7DE -- Fast Recovery -- Up 00:00:16 -- 186040 Kbytes

informix@dmsrvr:~> onmode -ky
informix@dmsrvr:~> oninit -v -PHY
Checking group membership to determine server run mode...succeeded
Reading configuration file '/opt/IBM/informix/etc/onconfig.test'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 12198 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Allocating 40016 kbytes for buffer pool of 4K page size...succeeded
Creating infos file "/opt/IBM/informix/etc/.infos.test"...succeeded
Linking conf file "/opt/IBM/informix/etc/.conf.test"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded
Initializing dataskip structure...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Verbose output complete: mode = 2
informix@dmsrvr:~> onstat -

IBM Informix Dynamic Server Version 11.50.UC7DE -- Fast Recovery -- Up 00:00:10 -- 186040 Kbytes


看来要物理启动，成长了 :)收起

回复 19# weiruan85


    这里显示似乎是数据库仍在运行的时候（oninit 或者ontape -r/-p），或者是刚刚停止数据库（onmode -ky），你再次执行了oninit。。
在onmode -ky后，最后再稍等一会在执行oninit命令。。。。收起

我刚才试了下，ontape -p后用onmode -m

informix@dmsrvr:~> onstat -

IBM Informix Dynamic Server Version 11.50.UC7DE -- On-Line (CKPT REQ) -- Up 00:00:27 -- 186040 Kbytes
Blocked:CKPT
informix@dmsrvr:~>
informix@dmsrvr:~> onstat -

IBM Informix Dynamic Server Version 11.50.UC7DE -- On-Line -- Up 00:00:36 -- 186040 Kbytes

informix@dmsrvr:~> onstat -

IBM Informix Dynamic Server Version 11.50.UC7DE -- On-Line -- Up 00:00:53 -- 186040 Kbytes

informix@dmsrvr:~> onmode -ky
informix@dmsrvr:~> oninit

没有任何问题，看来ontape -p 后数据库不能停掉，没有恢复完。但是为啥会报这么奇怪的错误呢。收起

我如果ontape -p ,然后紧接着ontape -l ,数据库就会处于online状态。

如果ontape -p 后把数据库停了，然后oninit重启就会报这个错误。

这个是怎么回事。收起

informix@dmsrvr:~> cat /opt/IBM/informix/tmp/online.log
06:43:34  IBM Informix Dynamic Server Started.
06:43:34  Warning: The IBM IDS Developer Edition license restriction limits
06:43:34  the total shared memory size for this server to 1048576 KB.
06:43:34  The maximum allowable shared memory was reset to this size to start the database server.

Tue Nov 15 06:43:35 2011

06:43:35  Event alarms enabled.  ALARMPROG = '/opt/IBM/informix/etc/log_full.sh'
06:43:35  Booting Language from module <>
06:43:35  Loading Module
06:43:35  Booting Language from module <>
06:43:35  Loading Module
06:43:41  DR: DRAUTO is 0 (Off)
06:43:41  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
06:43:41  Event notification facility epoll enabled.
06:43:41  IBM Informix Dynamic Server Version 11.50.UC7DE Software Serial Number AAA#B000000
06:43:41  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

06:43:41  Started 1 B-tree scanners.
06:43:41  B-tree scanner threshold set at 5000.
06:43:41  B-tree scanner range scan size set to -1.
06:43:41  B-tree scanner ALICE mode set to 6.
06:43:41  B-tree scanner index compression level set to med.
06:43:41  Data replication type and state information reset. To start DR, use
          the 'onmode -d' command and wait for the pair to be operational,
          before shutting down the database server

06:43:41  Dataskip is now OFF for all dbspaces
06:43:41  Restartable Restore has been ENABLED
06:43:41  Recovery Mode
06:43:44  Physical Restore of rootdbs started.

06:43:49  Checkpoint Completed:  duration was 0 seconds.
06:43:49  Tue Nov 15 - loguniq 14, logpos 0xdfa018, timestamp: 0x95dca Interval: 683

06:43:49  Maximum server connections 0
06:43:49  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

06:43:49  Increasing # of AIO VPs to 3

06:43:51  Physical Restore of rootdbs Completed.
06:43:51  Checkpoint Completed:  duration was 0 seconds.
06:43:51  Tue Nov 15 - loguniq 14, logpos 0xdfa018, timestamp: 0x95dce Interval: 683

06:43:51  Maximum server connections 0
06:44:27  IBM Informix Dynamic Server Stopped.

06:44:31  IBM Informix Dynamic Server Started.
06:44:31  Warning: The IBM IDS Developer Edition license restriction limits
06:44:31  the total shared memory size for this server to 1048576 KB.
06:44:31  The maximum allowable shared memory was reset to this size to start the database server.

Tue Nov 15 06:44:32 2011

06:44:32  Event alarms enabled.  ALARMPROG = '/opt/IBM/informix/etc/log_full.sh'
06:44:32  Booting Language from module <>
06:44:32  Loading Module
06:44:32  Booting Language from module <>
06:44:32  Loading Module
06:44:38  DR: DRAUTO is 0 (Off)
06:44:38  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
06:44:38  Event notification facility epoll enabled.
06:44:38  IBM Informix Dynamic Server Version 11.50.UC7DE Software Serial Number AAA#B000000
06:44:38  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

06:44:38  Started 1 B-tree scanners.
06:44:38  B-tree scanner threshold set at 5000.
06:44:38  B-tree scanner range scan size set to -1.
06:44:38  B-tree scanner ALICE mode set to 6.
06:44:38  B-tree scanner index compression level set to med.
06:44:38  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'temp_space'
06:44:38  Physical Recovery Started at Page (1:15139).
06:44:38  Physical Recovery Complete: 18 Pages Examined, 18 Pages Restored.
06:44:38  Logical Recovery Started.
06:44:38  10 recovery worker threads will be started.
06:44:38  Fast Recovery Switching to Log 15
06:44:38  Fast Recovery Switching to Log 16
06:44:39  Logical Recovery has reached the transaction cleanup phase.
06:44:39  Logical Recovery Complete.
          8178 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

06:44:39  oninit: Fatal error in shared memory initialization

06:44:39  IBM Informix Dynamic Server Stopped.

06:44:39  mt_shm_remove: WARNING: may not have removed all/correct segments收起

ontape -p只做了物理恢复，数据库需要逻辑恢复才能一致性打开，
ontape -l试试收起

more  online.log~收起

onclean执行了没？类似的报错这个命令还挺好用的。收起

回复 13# 孔令俊


    RESIDENT         0     #强迫驻留标志(Yes=1,NO=0)

          #为保持较好性能，应将共享内存缓冲区强制驻留在物理内存中(设为1),

           但若物理内存太小，将会使系统进程和用户进程没有足够内存


这个参数我没有改过，是默认的，  另外我是因为做了ontape -p 恢复后，数据库重启就报这个错误了。ontape -r 就没啥问题收起