Error ORA-19606 on RMAN Delete [ID 1215493.1]

发布时间:2020-08-09 08:58:57 作者:东北胖子
来源:ITPUB博客 阅读:158
Error ORA-19606 on RMAN Delete [ID 1215493.1]

  修改时间 08-FEB-2012     类型 PROBLEM     状态 MODERATED  

In this Document
  Symptoms
  Cause
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

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 coy 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 ===

Since RMAN will continue to use that file as it's snapshot copy, you must change the location/name that RMAN is using before it will allow you to delete the file. 

1.  Set new name (or location) for RMAN to use for snapshot controlfile:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCF_temp.ORA';

2.  Remove the snapshot controlfile from the RMAN information as a controlfile copy.

delete 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA' on operating system.

3.  Crosscheck and delete the file from RMAN:

crosscheck controlfilecopy 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA';
delete expired controlfilecopy 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA';

4.  Set the snapshot controlfile name (or location) to original:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA';

5.  To set the snapshot controlfile name back to default value:

CONFIGURE SNAPSHOT CONTROLFILE NAME clear;


推荐阅读:
  1. Golang中runtime的使用详解
  2. golang日志框架之logrus的使用

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

1215493.1 delete id

上一篇:网站受到攻击会有哪些症状?

下一篇:Shell脚本中执行sql语句操作MySQL数据库的几个方法

相关阅读

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

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