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 com...显示全部
在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

查看其它 3 个回答phanx的回答

phanxphanx系统工程师银行
看看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
浏览4396

回答者

phanx
系统工程师银行
擅长领域: 服务器数据库AIX

phanx 最近回答过的问题

回答状态

  • 发布时间:2014-06-09
  • 关注会员:1 人
  • 回答浏览:4396
  • X社区推广