逻辑日志无法自动备份
逻辑日志用完移动到下一个时，上一个逻辑日志无法自动备份onconfig配置为：
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 64 # Log tape block size (Kbytes)
LTAPESIZE 8192000 # Max amount of data to put on log tape (Kbytes)
执行onstat -l结果为：
% onstat -l
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line -- Up 3 days 16:02:36 -- 1295616
Kbytes
Physical Logging
Buffer bufusedbufsizenumpages numwrits pages/io
P-214 32 5791 997 5.81
phybegin physize phypos phyused %used
3:53 125000 70930 110 0.09
Logical Logging
Buffer bufusedbufsizenumrecsnumpages numwrits recs/pages pages/io
L-20 32 10020050 242873 39682 41.3 6.1
Subsystem numrecsLog Space used
OLDRSAM 10020050 887902912
address number flags uniqid begin size used %used
7000000213c31b84 U-B----43 2:53 25000 1 0.00
7000000213c32205 U-B----44 2:25053 25000 1 0.00
7000000213c32886 U-B----45 2:50053 25000 1 0.00
7000000213c32f07 U-B----46 2:75053 25000 27 0.11
7000000213c33588 U-B----47 2:100053 25000 25000 100.00
7000000213c33c09 U-B----48 2:125053 25000 25000 100.00
7000000213c342810 U-B----49 2:150053 25000 25000 100.00
7000000213c349011 U-B----50 2:175053 25000 25000 100.00
7000000213c34f812 U-B----51 2:200053 25000 25000 100.00
7000000213c356013 U-B----52 2:225053 25000 25000 100.00
7000000213c35c81 U-B----53 9:3 25000 25000 100.00
7000000213c36302 U-B----54 9:25003 25000 25000 100.00
7000000213c36983 U------55 9:50003 25000 25000 100.00
7000000213c370014 U------56 9:75003 25000 25000 100.00
7000000213c376815 U------57 9:100003 25000 25000 100.00
7000000213c37d016 U------58 9:125003 25000 25000 100.00
7000000213c383817 U------59 9:150003 25000 25000 100.00
7000000213c38a018 U------60 9:175003 25000 25000 100.00
7000000213c390819 U------61 9:200003 25000 25000 100.00
7000000213c397020 U------62 9:225003 25000 25000 100.00
7000000213c39d821 U------63 9:250003 25000 25000 100.00
7000000213c3a4022 U------64 9:275003 25000 25000 100.00
7000000213c3aa823 U------65 9:300003 25000 4448 17.79
7000000213c3b1024 U---C-L66 9:325003 25000 350 1.40
7000000213c3b7825 U-B----28 9:350003 25000 1 0.00
7000000213c3be026 U-B----29 9:375003 25000 1 0.00
7000000213c3c4827 U-B----30 9:400003 25000 1 0.00
7000000213c3cb028 U-B----31 9:425003 25000 1 0.00
7000000213c3d1829 U-B----32 9:450003 25000 1 0.00
7000000213c3d8030 U-B----33 10:3 25000 2 0.01
7000000213c3de831 U-B----34 10:25003 25000 1 0.00
7000000213c3e5032 U-B----35 10:50003 25000 1 0.00
7000000213c3eb833 U-B----36 10:75003 25000 1 0.00
7000000213c3f2034 U-B----37 10:100003 25000 1 0.00
7000000213c3f8835 U-B----38 10:125003 25000 1 0.00
70000002018bf7036 U-B----39 10:150003 25000 1 0.00
70000002154502837 U-B----40 10:175003 25000 1 0.00
70000002154509038 U-B----41 10:200003 25000 1 0.00
7000000215450f839 U-B----42 10:225003 25000 2 0.01
39 active, 39 total
回复 #1 qinghan1125 的帖子
LTAPEDEV /dev/null # Log tape device path做一个链接文件 到 /dev/null,然后这个参数改为 链接文件 ..
回复 #2 liaosnet 的帖子
这样是可行的，但是理论上如果LTAPEDEV 直接配置为/dev/null的话，是可以自动备份的不知道这里为什么出现问题？
回复 #3 qinghan1125 的帖子
额..这要看你的备份程序里使用的是什么方式的备份.../dev/null在默认的情况下是不允许备份了....... 可能有长事务存在跨越了多个logical log，建议您手工执行ontape -a，然后在看看flag标志位是否变成B，IDS里面没有这样的BUG.
页:
[1]