逻辑日志满处理过程

-bash-3.2$ oninit -vy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/app/etc/onconfig.tnmsdb2'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 10572 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/home/informix/app/etc/.infos.tnmsdb2"...succeeded
Linking conf file "/home/informix/app/etc/.conf.tnmsdb2"...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 SDS Server network connections...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
------------启动数据库到这里不动了

1、查看逻辑日志
-bash-3.2$ onstat -l

IBM Informix Dynamic Server Version 11.50.UC6     -- Fast Recovery (CKPT REQ) -- Up 00:11:18 -- 144144 Kbytes
Blocked:CKPT

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-1  0        64       0          0          0.00
      phybegin         physize    phypos     phyused    %used  
      2:53             25000      9054       4          0.02   

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-1  1        32       0          0          0          0.0        0.0    
        Subsystem    numrecs    Log Space used

Buffer Waiting
Buffer  ioproc   flags           
  L-1   0        0x11     0

address  number   flags    uniqid   begin                size     used    %used
4afbdb30 1        U------  1        1:25263              5000     5000   100.00
4afbdb78 2        U------  2        1:30263              5000     5000   100.00
4afbdbc0 3        U------  3        1:35263              5000     5000   100.00
4afbdc08 4        U------  4        1:40263              5000     5000   100.00
4afbdc50 5        U------  5        1:45263              5000     5000   100.00
4afbdc98 6        U---C-L  6        1:50263              5000     5000   100.00

2、创建备份逻辑日志文件
[root@racdb2 db_bak]# cd /db_bak/
[root@racdb2 db_bak]# touch db_20120525
[root@racdb2 db_bak]# chown informix:informix db_20120525
[root@racdb2 db_bak]# chmod 660 db_20120525

3、修改备份文件路径
vi $INFORMIX_HOME/etc/onconfig.tnmsdb2
LTAPEDEV /db_bak/db_20120525

4、执行自动备份
-bash-3.2$ ontape -a

Performing automatic backup of logical logs.

Please mount tape 1 on /db_bak/db_20120525 and press Return to continue ...

Logbackup failed - No log backup allowed during recovery.
Read/Write End Of Medium enabled: blocks = 315

Please label this tape as number 1 in the log tape sequence.

This tape contains the following logical logs:
    1
WARNING: Backup or restore of the last logical log 1 may be incomplete.
         Ensure that this logical log is properly backed up or restored.

Program over.

5、检查逻辑日志
-bash-3.2$ onstat -l

IBM Informix Dynamic Server Version 11.50.UC6     -- On-Line -- Up 01:01:34 -- 224652 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-1  0        64       1576       39         40.41
      phybegin         physize    phypos     phyused    %used  
      2:53             25000      10741      0          0.00   

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-1  0        32       16908      1549       1059       10.9       1.5    
        Subsystem    numrecs    Log Space used
        OLDRSAM      16880      1689780      
        HA           28         1232         

address  number   flags    uniqid   begin                size     used    %used
4afbdb30 1        U---C-L  7        1:25263              5000     1548    30.96
4afbdb78 2        U------  2        1:30263              5000     5000   100.00
4afbdbc0 3        U------  3        1:35263              5000     5000   100.00
4afbdc08 4        U------  4        1:40263              5000     5000   100.00
4afbdc50 5        U------  5        1:45263              5000     5000   100.00
4afbdc98 6        U------  6        1:50263              5000     5000   100.00