Rman备份到网络共享文件夹报错 rman-03009,ORA-19502,ORA-27063

在AIX下执行mount -v cifs -n 192.168.1.55/username/password -o uid=xxx,gid=xxx,fmode=750 /rman /rman_bksvr之后,调好了win2003的共享权限,在AIX下可以读写挂载目录,touch,cp,rm之类都没有问题~可是在用rman脚本备份的时候却报错,错误如下:

RMAN-03009:failure of backup command on c1 channel at 06/09/2014 15:01:19
ORA-19502:write error on file '/rman_bksvr/lv0_ORCL_4360.dbf',blockno 257 (blocksize=8192)
ORA-27063:number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 14: Bad address
Additional information -1
Additional information 1048576
ORA-19502:write error on file '/rman_bksvr/lv0_ORCL_4360.dbf',blockno 1 (blocksize=8192)
ORA-27063:number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 14: Bad address

备份脚本如下:
rman << EOF
connect target /
run{
allocate channel c1 type disk;
backup incremental level 0 database format '/rman_bksvr/lv0_%d_%s.dbf';
release channel c1;
}
exit
EOF

以上脚本如果备份到本地没有问题~备份到挂载的共享文件夹就出现上边的报错
共享空间肯定是没问题~还有500G~本地0级备份只有30多G~
也不想用NFS~因为AIX自带cifs支持~NFS还要第三方~还有费用
网上有说rman和cifs不兼容~但是我在自己的VMware workstation上用cifs从linux系统连接本地的win7共享文件夹,rman备份一点问题都没有
望各位大虾多多提点~小虾在此先谢过了

4回答

jiaxu2000jiaxu2000  系统工程师 , 沈阳医学院附属中心医院
就知道你会问这个,据说rman无法往cifs备份,还是研究nfs吧显示全部
就知道你会问这个,据说rman无法往cifs备份,还是研究nfs吧收起
 2014-06-09
浏览319
jiaxu2000jiaxu2000  系统工程师 , 沈阳医学院附属中心医院
nfs没有什么费用,windows server 2008 r2自带,无需任何第三方软件,2008 r2的安全性也远比win 2003强显示全部
nfs没有什么费用,windows server 2008 r2自带,无需任何第三方软件,2008 r2的安全性也远比win 2003强收起
 2014-06-09
浏览311
phanxphanx  系统工程师 , 银行
看看Oracle MOS 文档  444809.1Is use of CIFS Protocol for RMAN backups supported? (Doc ID 444809.1)Can RMAN be used to create backuppieces on CIFS?SolutionWe do not in general certify against particular storage vendors and use of NAS devices...显示全部
看看Oracle MOS 文档  444809.1
Is use of CIFS Protocol for RMAN backups supported? (Doc ID 444809.1)

Can RMAN be used to create backuppieces on CIFS?

Solution
We do not in general certify against particular storage vendors and use of NAS devices (NFS/CIFS) is treated as any other file system.

Oracle does not support CIFS protocol in general because CIFS does not guarantee atomic write of 512 byte (Oracle log block size) like NFS can (with wsize parameter). So in case of power failure, it is possible to corrupt Oracle archived logs.

However, RMAN does NOT rely on 512-byte atomic writes (we write the ENTIRE file and then close it) so the answer is yes: CIFS is fine for RMAN files: backup pieces, datafile copies, archived logs but it is not certified by Oracle.

In other words if there are any problems involved in using RMAN and CIFS, then we cannot get the RDBMS development involved.收起
 2014-06-09
浏览360
axiaowuuaaxiaowuua  系统运维工程师 , Gigaset
看楼上的英文,应该是不是支持这种文件系统吧。显示全部
看楼上的英文,应该是不是支持这种文件系统吧。收起
 2014-06-10
浏览333

提问者

edwardyan数据库运维工程师, 太极开放

问题状态

  • 发布时间:2014-06-09
  • 关注会员:1 人
  • 问题浏览:3497
  • 最近回答:2014-06-10
  • 关于TWT  使用指南  社区专家合作  厂商入驻社区  企业招聘  投诉建议  版权与免责声明  联系我们
    © 2017 talkwithtrend — talk with trend,talk with technologist 京ICP备09031017号-30