ORA-19606: Cannot copy or restore to snapshot control file

發(fā)布時(shí)間：2020-08-10 20:18:59 來(lái)源：ITPUB博客閱讀：160 作者：東北胖子欄目：關(guān)系型數(shù)據(jù)庫(kù)

今早上班發(fā)現(xiàn)在刪除過(guò)期備份的控制文件鏡像時(shí)報(bào)錯(cuò)，查詢mos發(fā)現(xiàn)如下文章可以解決，特此記錄：
Error ORA-19606 on RMAN Delete (文檔 ID 1215493.1)，
處理思路是將指定過(guò)期的鏡像控制文件從控制文件記錄的備份信息uncatalog出去，如下

SYMPTOMS：
=== ODM Issue Clarification ===

Receiving error on 'delete obsolete':
delete noprompt obsolete device type disk;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 5 days
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 3 01-SEP-10 C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_DISK_1 channel at 09/09/2010 02:04:24
ORA-19606: Cannot copy or restore to snapshot control file

CAUSE：

=== ODM Cause Determination ===

The snapshot controlfile is cataloged as a controlfile copy and is now obsolete. RMAN cannot delete this file as it is used by rman.

=== ODM Cause Justification ===

Error and information supplied justifies cause

SOLUTION：

=== ODM Solution / Action Plan ===
The snapshot controlfile must be removed as a valid controlfile copy. To do this, you would:
RMAN> change controlfilecopy 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA' uncatalog;
Confirm with:
RMAN> list copy of controlfile;

向AI問(wèn)一下細(xì)節(jié)

ORA-19606: Cannot copy or restore to snapshot control file

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽