Shulou(Shulou.com)06/02 Report--

Error ORA-19606 on RMAN Delete [ID 1215493.1] modification time 08-FEB-2012 type PROBLEM status 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.