LoveUnix » 备份软件 » 直接备份数据库到磁带机出错
让LU留住您的每

一天 让LU博客留住您的每一天
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


请各路神仙指点一二。

2008-1-23 14:23 炸鸡
靠,DB2不支持block size Variable Length!!!!!!!

马上改一下,把rmt9的block size改为4096,就开始动了。:lol

2008-1-23 18:47 小猪
:$ 学习啦.

2008-1-24 13:23 darkbug
路过BS一下楼主

2008-1-24 18:00 炸鸡
能去到多大?

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.