vvv2000 发表于 2010-10-12 10:32

为什么备份sybase库失败？

Backup Server session id is:5.Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.41.1.1: Creating new disk file /sybak/zxdbp_51_dbak.dat.
Backup Server: 6.28.1.1: Dumpfile name 'xdbp_511027802A31' section number 1
mounted on disk file '/sybak/zxdbp_51_dbak.dat'
Backup Server: 4.58.1.1: Database zxdbp_51: 4 kilobytes DUMPED.
Backup Server: 4.139.2.22: The 'aio_read' call failed for device
'/sybak/zxdbp_51_dbak.dat' with error number 14 (Bad address). Refer to your
operating system documentation for further details. Look for 'Oct5 03:00:01
2010: D00: SYBMULTBUF ERROR: ' in the backup server errorlog for additional
information from SYBMULTBUF.
Msg 8009, Level 16, State 1:
Server 'crbtdb3', Line 1:
Error encountered by Backup Server.Please refer to Backup Server messages for
details.
dump fail db list is: zxdbp_51

数据库里检查的日志是：
Oct4 23:47:45 2010: Backup Server: 1.70.1.1: 将 maximum shared memory usage 配置为 48 MB。
Oct4 23:47:45 2010: Backup Server: 1.69.1.2: 将 number of service threads 配置为 48。
Oct4 23:47:45 2010: Backup Server: 1.70.1.3: 将 maximum shared memory per stripe 配置为 1048576
bytes。
Oct5 03:00:01 2010: Backup Server: 4.41.1.1: 创建新的磁盘文件/sybak/zxdbp_51_dbak.dat。
Oct5 03:00:01 2010: Backup Server: 1.70.1.2: 将 shared memory per stripe 配置为 786432 bytes。
Oct5 03:00:01 2010: Backup Server: 6.28.1.1: 转储文件名'xdbp_511027802A31', 区域号1安装在disk fi
le '/sybak/zxdbp_51_dbak.dat'上。
Oct5 03:00:01 2010: D00: SYBMULTBUF ERROR: Attempt to start database device i/o failed: State =
115 Msg = Bad address
Oct5 03:00:01 2010: Backup Server: 4.139.2.22: 'aio_read' 调用因设备 '/sybak/zxdbp_51_dbak
.dat' 而失败，错误号为 14 (Bad address)。请参考操作系统的文档以获取更详细的信息。查看备份服务器错
笕罩镜?'Oct5 03:00:01 2010: D00: SYBMULTBUF ERROR: ' 以获取来自SYBMULTBUF的附加信息。
Oct5 03:00:02 2010: Backup Server: 4.58.1.1: 数据库zxdbp_51: 4千字节DUMPEDed

chuxu 发表于 2010-10-12 11:07

在/sybak/目录下手工写文件正常吗？

andkylee 发表于 2010-10-12 13:06

'aio_read' 调用因设备 '/sybak/zxdbp_51_dbak
.dat' 而失败，错误号为 14 (Bad address)。



看看是不是aio问题，查看一下/sybak/zxdbp_51_dbak.dat是否正常？

piml_lv 发表于 2010-10-12 13:10

看着好眼熟啊

是不是 异地备份服务器啊

vvv2000 发表于 2010-10-17 20:17

在/sybak/目录下手工写文件正常吗？正常的。是转存储啊，在下挂的磁阵上备份呢
页: [1]
查看完整版本: 为什么备份sybase库失败？