ORA-19606: Cannot copy or restore to snapshot control file
今早上班發現在刪除過期備份的控制檔案映象時報錯,查詢mos發現如下文章可以解決,特此記錄:
Error ORA-19606 on RMAN Delete (文件 ID 1215493.1),
處理思路是將指定過期的映象控制檔案從控制檔案記錄的備份資訊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;
Error ORA-19606 on RMAN Delete (文件 ID 1215493.1),
處理思路是將指定過期的映象控制檔案從控制檔案記錄的備份資訊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;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/2317695/viewspace-2150730/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 快照控制檔案(snapshot control file)Oracle
- Oracle快照控制檔案(snapshot control file)Oracle
- 透過Snapshot Control File 恢復控制檔案
- 通過Snapshot Control File 恢復控制檔案
- 難得的waiting for snapshot control file enqueue提示...AIENQ
- HP -Data Protector Restore file systemREST
- Cannot restore segment prot after reloc:Permission deniedREST
- control file parallel writeParallel
- RMAN-06100: no channel to restore a backup or copy of datafileREST
- 控制檔案-control file
- control file(控制檔案)
- EM 10g Grid Control Fails With 'libdb.so.2: cannot open shared object file:AIObject
- RMAN-06023 no backup or copy of datafile 1 found to restoreREST
- you cannot use this control in design mode。
- HP -Data Protector Restore file system【Blog 搬家】REST
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- oracle重建control file的操作Oracle
- a control file contains informationAIORM
- control file parallel write等待事件Parallel事件
- sqlplus cannot execute binary fileSQL
- libmysqlclient.so.16: cannot open shared object file: No such file or directoryIBMMySqlclientObject
- libcap.so.1:cannot open shared object file: No such file or directoryObject
- libXext.so.6: cannot open shared object file: No such file or directoryObject
- libz.so.1: cannot open shared object file: No such file or directoryObject
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- How to copy a datafile from ASM to a file system not using RMANASM
- Unable to View Chinese Font When Using Tools>Copy FileView
- ORA-19550: cannot use backup/restore functions while using dispatcherRESTFunctionWhile
- recover database using backup control fileDatabase
- SCRIPT TO GENERATE SQL*LOADER CONTROL FILESQL
- 重建控制檔案 recreate control file
- control file parallel write事件小記Parallel事件
- control file sequential read等待事件事件
- Database Clone by rebuilding control file.DatabaseRebuild
- oracle檔案管理之 control fileOracle
- ImportError: libffi.so.7: cannot open shared object file: No such file or directoryImportErrorObject
- ulimit: core file size: cannot modify limit: Operation not permittedMIT
- ORA-00245:control file backup failed;targetis likely on local file systemAI