温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

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

发布时间:2020-08-10 20:18:59 来源:ITPUB博客 阅读:151 作者:东北胖子 栏目:关系型数据库
今早上班发现在删除过期备份的控制文件镜像时报错,查询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;

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI