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备份一点问题都没有
望各位大虾多多提点~小虾在此先谢过了
参与5

4同行回答

axiaowuuaaxiaowuua系统运维工程师Gigaset
看楼上的英文,应该是不是支持这种文件系统吧。显示全部
看楼上的英文,应该是不是支持这种文件系统吧。收起
互联网服务 · 2014-06-10
浏览4098
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
浏览4393
jiaxu2000jiaxu2000系统工程师沈阳医学院附属中心医院
nfs没有什么费用,windows server 2008 r2自带,无需任何第三方软件,2008 r2的安全性也远比win 2003强显示全部
nfs没有什么费用,windows server 2008 r2自带,无需任何第三方软件,2008 r2的安全性也远比win 2003强收起
事业单位 · 2014-06-09
浏览4088
jiaxu2000jiaxu2000系统工程师沈阳医学院附属中心医院
就知道你会问这个,据说rman无法往cifs备份,还是研究nfs吧显示全部
就知道你会问这个,据说rman无法往cifs备份,还是研究nfs吧收起
事业单位 · 2014-06-09
浏览4090

提问者

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

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2014-06-09
  • 关注会员:1 人
  • 问题浏览:9018
  • 最近回答:2014-06-10
  • X社区推广