免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3083 | 回复: 1
打印 上一主题 下一主题

sybase:dump时无法导出数据! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2008-02-02 17:27 |只看该作者 |倒序浏览
操作系统:Cent OS 4.3。
数据库版本:Sybase 11.0.3

isql登录后执行如下代码:
dump tran master with no_log
go
dump database master to "/home/databak/bak_data/master.dat"
go


界面上显示如下错误:
  1. WARNING: In order to LOAD the master database, the SQL Server must run in
  2. single-user mode.  If the master database dump uses multiple volumes, you must
  3. execute sp_volchanged on another SQL Server at LOAD time in order to signal
  4. volume changes.
  5. Backup Server session id is:  19.  Use this value when executing the
  6. 'sp_volchanged' system stored procedure after fulfilling any volume change
  7. request from the Backup Server.
  8. Backup Server: 4.41.1.1: Creating new disk file
  9. /home/databak/bak_data/master.dat.
  10. Backup Server: 4.128.2.1: Failed to start multibuffering subprocesses for
  11. archive device '/home/databak/bak_data/master.dat'. Look at the Backup Server
  12. error log or standard error for more information.
  13. Msg 8009, Level 16, State 1:
  14. Line 1:
  15. Error encountered by Backup Server.  Please refer to Backup Server messages for
  16. details.
复制代码


backup.log文件中的错误如下:

  1. Feb  2 14:48:27 2008: Backup Server: 4.41.1.1: Creating new disk file /home/databak/bak_data/master.dat.
  2. Feb  2 14:48:27 2008: A00: SYBMULTBUF ERROR: get_membufs: zero-filled buffer unavailable, System error=Bad file descriptor
  3. Feb  2 14:48:27 2008: Backup Server: 4.128.2.1: Failed to start multibuffering subprocesses for archive device '/home/databak/bak_data/master.dat'. Look at the Backup Server error log or standard error for more information.
复制代码


errorlog 文件中无相关非正常信息!

希望CU的兄弟们给予解答,谢谢!

论坛徽章:
0
2 [报告]
发表于 2008-02-03 21:05 |只看该作者
增加文件描述符的大小
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP