Error ORA-19606 on RMAN Delete

Error ORA-19606on RMAN Delete [ID 1215493.1]

---

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

In this Document
  Symptoms
  Cause
  Solution

---

This document is being delivered to you viaOracle Support's Rapid Visibility (RaV) process and therefore hasnot been subject to an independent technicalreview.

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 andlater   [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-10C:\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 channelat 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 isnow obsolete. RMAN cannot delete this file as it is used byrman.


=== 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 willallow you to delete the file. 

1.  Set new name (or location) for RMAN to use forsnapshot 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 RMANinformation 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 fromRMAN:

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 (orlocation) 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 backto default value:

CONFIGURE SNAPSHOT CONTROLFILE NAME clear;