I have 11.2.0.3.6 standalone database with ASM on Aıx 7.1 system. We are using rman script to take full backup for that system.

We have basic script to can take full backup of our system such as:

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;
}

We got below error message during end of 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/13/2013 05:00:17
ORA-19606: Cannot copy or restore to snapshot control file

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

After We investigate issue,We have been found MOS Error ORA-19606 on RMAN Delete [ID 1215493.1]

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’;

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

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

-rw-r—– 1 oracle oinstall 7749632 Jun 13 05:00 snapcf_PROD.f
-rw-rw—- 1 oracle oinstall 1544 Jun 13 14:00 hc_PROD.dat
-rw-r—– 1 oracle oinstall 7749632 Jun 13 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 13-05-2013 14:44:31 358151 13-05-2013 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. Current settings:

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]

Advertisements