fdhunter 发表于 2008-03-19 12:44

sybase dump 超过1G就出错，怎么回事？

aix5.3sybase12.5

数据备份时dump 超过1G就停下来了，是不是sybase有什么限制啊
系统limits的限制我已经取消啦

# ulimit -a
time(seconds)      unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)      4194304
memory(kbytes)       unlimited
coredump(blocks)   unlimited
nofiles(descriptors) unlimited
#

那位高手指点一下。

flybean 发表于 2008-03-19 13:30

详细的出错日志呢？

fdhunter 发表于 2008-03-19 14:43

一14:42:23
Backup Server session id is:38.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
/sybase_bak/izumi20080319_01.dmp.
Backup Server: 6.28.1.1: Dumpfile name 'izumi080790CE29' section number 1
mounted on disk file '/sybase_bak/izumi20080319_01.dmp'
Backup Server: 4.58.1.1: Database izumi: 1042030 kilobytes DUMPed.
Backup Server: 4.145.2.22: Error for device
'/sybase_bak/izumi20080319_01.dmp'. Error writing to archive device
/sybase_bak/izumi20080319_01.dmp. Attempted to write 65536 bytes, 5632 bytes
were written.
Msg 8009, Level 16, State 1:
Server 'izumi', Line 1:
Error encountered by Backup Server.Please refer to Backup Server messages for
details.




Aix 5.3,JFS2的文件系统，
怎么单个文件只能最大到1073741312大小，一开始以为是
/etc/security/limits中的fsize的限制，但改fszie参数
为－1并重启后，还是不能突破该限制！

fdhunter 发表于 2008-03-19 14:45

Mar 19 14:39:37 2008: Backup Server: 4.41.1.1: Creating new disk file /sybase_ba
k/izumi20080319_01.dmp.
Mar 19 14:39:37 2008: Backup Server: 6.28.1.1: Dumpfile name 'izumi080790CE29'
section number 1 mounted on disk file '/sybase_bak/izumi20080319_01.dmp'
Mar 19 14:41:02 2008: A00: SYBMULTBUF ERROR: Error writing to archive device /sy
base_bak/izumi20080319_01.dmp. Attempted to write 65536 bytes, 5632 bytes were w
ritten.
Mar 19 14:41:03 2008: Backup Server: 4.145.2.22: Error for device '/sybase_b
ak/izumi20080319_01.dmp'. Error writing to archive device /sybase_bak/izumi20080
319_01.dmp. Attempted to write 65536 bytes, 5632 bytes were written.
Mar 19 14:41:03 2008: Backup Server: 4.58.1.1: Database izumi: 1042030 kilobytes
DUMPed.
Mar 19 14:41:05 2008: Backup Server: 4.15.2.2: Label validation error: seek to t
railer labels failed.

chuxu 发表于 2008-03-19 15:32

# ulimit -a
sybase 用户的呢？

hobbylu 发表于 2008-03-19 15:33

修改操作系统限制

fdhunter 发表于 2008-03-19 18:23

ok了，root用户、sybase用户都是ulimit -a
time(seconds)      unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)      4194304
memory(kbytes)       unlimited
coredump(blocks)   unlimited
nofiles(descriptors) unlimited

把/etc/security/limits 下sybase用户的设置删掉，重启就可以啦，不懂什么原因！谢谢各位啦。
页: [1]
查看完整版本: sybase dump 超过1G就出错，怎么回事？