2008-1-23 14:15
炸鸡
直接备份数据库到磁带机出错
aix5208+db2 8.1fix6,通过hba卡连到3584,不使用备份软件,我要直接备到带子上。
我先用mtlib命令去把带子塞进磁带机,测试备份文件到带机没问题,30G的大文件都没问题。
数据库的instance owner直接写带子都可以,但备数据库就出问题了。
db2 backup db edw online to /dev/rmt9 with 4 buffers
SQL2031W Warning! Please mount the target or source media on device
"/dev/rmt9".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) c
SQL2059W A device full warning was encountered on device "/dev/rmt9".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) c
SQL2059W A device full warning was encountered on device "/dev/rmt9".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) t
SQL2001N The utility was interrupted. The output data may be incomplete.
我们看看db2的log:
2008-01-23-13.15.35.380387 Instance:dw1 Node:001
PID:578676(db2med.435168.0 1) TID:1 Appid:none
oper system services sqlowrite Probe:60
EINVAL from write() does not mean a real disk full condition.
Possible reasons :
1. Invalid parameters to the API.
2. The file size / offset specified is > 2G but the file system
does not support > 2G.
fileHandle : 0x6 bufferLength: 4194304 offset: -1
2008-01-23-13.15.37.226222 Instance:dw1 Node:001
PID:578676(db2med.435168.0 1) TID:1 Appid:none
database utilities sqluMCWriteToDevice Probe:40
Media controller -- End of tape encountered on /dev/rmt9
请各路神仙指点一二。