您好,欢迎访问一九零五行业门户网

执行RMAN拷贝时报错ORA-01276

症状:执行rman拷贝的时候报错ora-01276: cannot add file +testdg/rac/datafile/system.416.833384105. file has an oracle man
症状:
执行rman拷贝的时候报错
ora-01276: cannot add file +testdg/rac/datafile/system.416.833384105. file has an oracle managed files file name.
如下:
rman> copy datafile 1 to '+testdg/rac/datafile/system.416.833384105';
starting backup at 05-dec-13
copy datafile 2 to '+testdg/rac/datafile/sysaux.417.833384107';
copy datafile 3 to '+testdg/rac/datafile/undotbs1.418.833384107';
copy datafile 4 to '+testdg/rac/datafile/users.419.833384109';
copy datafile 5 to '+testdg/rac/datafile/undotbs2.424.833384491';using target database control file instead of recovery catalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=140 instance=rac1 device type=disk
channel ora_disk_1: starting datafile copy
input datafile file number=00001 name=+data/rac/datafile/system.416.833384105
rman-00571: ===========================================================
rman-00569: =============== error message stack follows ===============
rman-00571: ===========================================================
rman-03009: failure of backup command on ora_disk_1 channel at 12/05/2013 15:55:34
ora-01276: cannot add file +testdg/rac/datafile/system.416.833384105. file has an oracle managed files file name.
分析:
error: ora-01276 (ora-1276)
text: cannot add a file with an oracle managed files file name.
---------------------------------------------------------------------------
cause: an attempt was made to add to the database a datafile, log file,
or control file with an oracle managed files file name.
action: retry the operation with a new file name.
asm对omf文件自动命名,对于这种特殊情况,,不能讲copy后的文件与源文件命名一致。
解决方案:
按照oracle的提示修正命令即可:
copy datafile 1 to '+testdg/rac/datafile/system.dbf';
rman>
rman> copy datafile 1 to '+testdg/rac/datafile/system.dbf';
starting backup at 05-dec-13
using channel ora_disk_1
channel ora_disk_1: starting datafile copy
input datafile file number=00001 name=+data/rac/datafile/system.416.833384105
output file name=+testdg/rac/datafile/system.dbf tag=tag20131205t155835 recid=1 stamp=833385552
channel ora_disk_1: datafile copy complete, elapsed time: 00:00:45
finished backup at 05-dec-13
rman>
推荐阅读:
rman 配置归档日志删除策略
oracle基础教程之通过rman复制数据库
rman备份策略制定参考内容
rman备份学习笔记
oracle数据库备份加密 rman加密
其它类似信息

推荐信息