I faced with ORA-19606 error on 11.2.0.4 database. I am using below rman script to take full backup for my database.

Here is my script:

rman target  /

run
{
ALLOCATE CHANNEL C1 device type ‘sbt_tape’ ;
ALLOCATE CHANNEL C2 device type ‘sbt_tape’ ;
backup database plus archivelog delete input format= ‘DB_SID_DB_%d_%t_%s_%p’;
backup archivelog all delete input FORMAT= ‘DB_ARC_%d_%t_%s_%p’;
delete force noprompt obsolete;
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
}

I got below error message at end of backup during taking backup:

.
.
released channel: C1
released channel: C2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on default channel at 06/03/2020 05:00:17
ORA-19606: Cannot copy or restore to snapshot control file

Recovery Manager complete.
06/03/2020 05:00:22 Finished command. Return code is: 111
06/03/2020 05:00:22 ANS1909E The scheduled command failed.

After I started investigate issue, I have been found MOS Error ORA-19606 on RMAN Delete [ID 1215493.1] note.

Here is the steps of solutions:

1. Current settings:

RMAN> show all;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f’; # default

Now I am going to change new name (or location) for RMAN to use for snapshot controlfile:

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD_Database.f’;

Check the files under $ORACLE_HOME/dbs

[oracle@PROD]</u01/app/oracle/product/11.2.0/dbs> ls -lrt

-rw-r—– 1 oracle oinstall 7749632 Mar 06 05:00 snapcf_PROD.f
-rw-rw—- 1 oracle oinstall 1544 Mar 06 14:00 hc_PROD.dat
-rw-r—– 1 oracle oinstall 7749632 Mar 06 14:01 snapcf_PROD_Database.f

2. Remove or delete old controlfile copy.

[oracle@PROD]</u01/app/oracle/product/11.2.0/dbs> mv snapcf_PROD.f snapcf_PROD.f_old

3. Crosscheck controlfile copy.

RMAN> crosscheck controlfilecopy ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f’;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1347 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f RECID=1 STAMP=815323471
Crosschecked 1 objects

3. Delete controlfile copy via RMAN.

RMAN> delete expired controlfilecopy ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f’;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1347 device type=DISK
List of Control File Copies
===========================

Key S Completion Time Ckp SCN Ckp Time
——- – ——————- ———- ——————-
1172256811 X 06-03-2020 14:44:31 358151 06-03-2020 14:44:31
Name: /u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f
Tag: TAG20130513T144431
Do you really want to delete the above objects (enter YES or NO)? YES
deleted control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f RECID=1 STAMP=815323471
Deleted 1 EXPIRED objects

4. Check current settings again:

RMAN> show all;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD_Database.f’;

Now I am going to change new name for RMAN to use for snapshot controlfile
PS: You dont need this steps if its okey to use your copy with new name

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f’;

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD_Database.f’;
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/dbs/snapcf_PROD.f’;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Reference:
Error ORA-19606 on RMAN Delete [ID 1215493.1]