免费注册 查看新帖 |

Chinaunix

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

备份600G的库出现问题,急!急!急! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2010-02-09 09:32 |只看该作者 |倒序浏览
备份机器sun 445,操作系统是solaris10,两个阵列 分别是800G 已经做成文件系统

一、加上stripe on出现问题,使用两个阵列

2> use master
3> go
1> dump database rnosdb to "/files1/dump01" at r_bakup_server
2> stripe on '/files/dump02'
3> go
Backup Server session id is:  94.  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 /files/dump02.
Backup Server: 4.141.2.40: [7] The 'open' call failed for device '/files/dump02'
with error number 2 (No such file or directory). Refer to your operating system
documentation for further details.
Backup Server: 5.7.2.16: RPC ('bs_poll_capabilities') execution failed.
Msg 8009, Level 16, State 1:
Server 'BOCODT', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.
1>

二、使用一个文件系统,不加stripe on备份一段时间出现的问题

dump database rnosdb to "/files/rnosdb2010020820.dmp" at r_bakup_server   
  end if
end
  1> use master
2> go
1> dump database rnosdb to "/files/rnosdb2010020820.dmp" at r_bakup_server
2> go
Backup Server session id is:  98.  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 /files/rnosdb2010020820.dmp.
Backup Server: 6.28.1.1: Dumpfile name 'rnosdb1003911E39 ' section number 1
mounted on disk file '/files/rnosdb2010020820.dmp'
Backup Server: 4.188.1.1: Database rnosdb: 7233898 kilobytes (1%) DUMPED.
Backup Server: 4.188.1.1: Database rnosdb: 14457200 kilobytes (2%) DUMPED.
Backup Server: 4.188.1.1: Database rnosdb: 21680502 kilobytes (3%) DUMPED.
Backup Server: 4.188.1.1: Database rnosdb: 28903290 kilobytes (4%) DUMPED.
Backup Server: 4.145.2.37: [3] Error for device '/files/rnosdb2010020820.dmp'.
Error writing to archive device /files/rnosdb2010020820.dmp. Attempted to write
65536 bytes, 61440 bytes were written.
Backup Server: 5.7.2.11: RPC ('as_large_pagerun') execution failed.
Backup Server: 4.188.1.1: Database rnosdb: 35730768 kilobytes (5%) DUMPED.
Msg 8009, Level 16, State 1:
Server 'BOCODT', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

请帮忙看看什么问题,谢谢!

论坛徽章:
0
2 [报告]
发表于 2010-02-09 11:06 |只看该作者
备份机器sun 445,操作系统是solaris10,两个阵列 分别是800G 已经做成文件系统

一、加上stripe on出现 ...
maolinzhou 发表于 2010-02-09 09:32



    第一个说是是路径不对.
第二个是操作系统的文件大小有限制?
建议你一次用多个stripe on语句把备份文件分割成多个,比如20个

论坛徽章:
6
水瓶座
日期:2014-06-04 03:34:37水瓶座
日期:2014-06-17 13:20:31数据库技术版块每日发帖之星
日期:2016-07-09 06:20:00数据库技术版块每日发帖之星
日期:2016-07-17 06:20:00数据库技术版块每日发帖之星
日期:2016-08-01 06:20:00数据库技术版块每日发帖之星
日期:2016-08-04 06:20:00
3 [报告]
发表于 2010-02-10 10:44 |只看该作者
>>>stripe on '/files/dump02'

>>>Backup Server: 4.141.2.40: [7] The 'open' call failed for device '/files/dump02'  with error number 2 (No such file or directory).

请确认该文件系统是否已经正常挂载上?

>>>Attempted to write 65536 bytes, 61440 bytes were written.
通过该错误语句判断应该不是OS中文件系统方面的限制。感觉像是备份时sybase主服务和back server服务用RPC通信时出现异常。请检查该时间段的errorlog看有没有异常。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP