執行RMAN拷貝時報錯ORA-01276

來源:互聯網
上載者:User

癥狀:
執行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備份學習筆記

OracleDatabase Backup加密 RMAN加密

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.