My case is very similar to
Strange RMAN snapshot controlfile issue
This happend on a 11gR2 database installed under a Linux x86 platform.
Apparently this is encountered after executing a DUPLICATE database from ACTIVE DATABASE. Furthermore, the snapshot controlfile is reported as a "datafile copy" when a CROSSCHECK is suggested.
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 323 02-JAN-13 /u01/oradata/DG/arch/DG_1_36_803644301.dbf
Archive Log 324 02-JAN-13 /u01/oradata/DG/arch/DG_1_37_803644301.dbf
Archive Log 325 02-JAN-13 /u01/oradata/DG/arch/DG_1_38_803644301.arc
Archive Log 326 02-JAN-13 /u01/oradata/DG/arch/DG_1_39_803644301.arc
Archive Log 327 02-JAN-13 /u01/oradata/DG/arch/DG_1_40_803644301.arc
...
Archive Log 377 03-JAN-13 /u01/oradata/DG/arch/DG_1_54_803644301.arc
Backup Set 351 03-JAN-13
Backup Piece 352 03-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T143645_8gb9qyvw_.bkp
Archive Log 427 03-JAN-13 /u01/oradata/DG/arch/DG_1_55_803644301.arc
Backup Set 410 03-JAN-13
Backup Piece 412 03-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T143724_8gb9s5h5_.bkp
Archive Log 461 03-JAN-13 /u01/oradata/DG/arch/DG_1_56_803644301.arc
Backup Set 432 03-JAN-13
Backup Piece 434 03-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T144310_8gbb404s_.bkp
Backup Set 462 03-JAN-13
Backup Piece 484 03-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_nnndf_TAG20130103T144337_8gbb4trh_.bkp
Backup Set 463 03-JAN-13
Backup Piece 485 03-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_ncnnf_TAG20130103T144337_8gbb6goj_.bkp
Archive Log 624 03-JAN-13 /u01/oradata/DG/arch/DG_1_57_803644301.arc
Backup Set 496 03-JAN-13
Backup Piece 498 03-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T144432_8gbb6knl_.bkp
Archive Log 625 03-JAN-13 /u01/oradata/DG/arch/DG_1_58_803644301.arc
Archive Log 626 03-JAN-13 /u01/oradata/DG/arch/DG_1_59_803644301.arc
Archive Log 627 03-JAN-13 /u01/oradata/DG/arch/DG_1_60_803644301.arc
Archive Log 628 03-JAN-13 /u01/oradata/DG/arch/DG_1_61_803644301.arc
Archive Log 629 03-JAN-13 /u01/oradata/DG/arch/DG_1_62_803644301.arc
...
Archive Log 652 03-JAN-13 /u01/oradata/DG/arch/DG_1_85_803644301.arc
Archive Log 653 03-JAN-13 /u01/oradata/DG/arch/DG_1_86_803644301.arc
Archive Log 654 03-JAN-13 /u01/oradata/DG/arch/DG_1_87_803644301.arc
Archive Log 655 03-JAN-13 /u01/oradata/DG/arch/DG_1_88_803644301.arc
Archive Log 656 03-JAN-13 /u01/oradata/DG/arch/DG_1_89_803644301.arc
Archive Log 657 03-JAN-13 /u01/oradata/DG/arch/DG_1_90_803644301.arc
Archive Log 658 04-JAN-13 /u01/oradata/DG/arch/DG_1_91_803644301.arc
Archive Log 659 04-JAN-13 /u01/oradata/DG/arch/DG_1_92_803644301.arc
Control File Copy 660 03-JAN-13 /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
Archive Log 666 04-JAN-13 /u01/oradata/DG/arch/DG_1_93_803644301.arc
Backup Set 672 04-JAN-13
Backup Piece 674 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T093320_8gddc2v8_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_36_803644301.dbf RECID=1 STAMP=803646146
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_37_803644301.dbf RECID=2 STAMP=803656969
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_38_803644301.arc RECID=3 STAMP=803657084
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_39_803644301.arc RECID=4 STAMP=803669996
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_40_803644301.arc RECID=5 STAMP=803670001
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_41_803644301.arc RECID=6 STAMP=803670157
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_42_803644301.arc RECID=7 STAMP=803670159
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_43_803644301.arc RECID=8 STAMP=803671332
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_44_803644301.arc RECID=9 STAMP=803671334
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_45_803644301.arc RECID=10 STAMP=803671405
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_46_803644301.arc RECID=11 STAMP=803671408
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_47_803644301.arc RECID=12 STAMP=803685637
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_48_803644301.arc RECID=13 STAMP=803696446
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_49_803644301.arc RECID=14 STAMP=803716365
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_50_803644301.arc RECID=15 STAMP=803736010
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_51_803644301.arc RECID=16 STAMP=803744305
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_52_803644301.arc RECID=17 STAMP=803744307
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_53_803644301.arc RECID=18 STAMP=803745403
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_54_803644301.arc RECID=19 STAMP=803745443
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T143645_8gb9qyvw_.bkp RECID=1 STAMP=803745406
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_55_803644301.arc RECID=20 STAMP=803745788
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T143724_8gb9s5h5_.bkp RECID=4 STAMP=803745445
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_56_803644301.arc RECID=21 STAMP=803745871
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T144310_8gbb404s_.bkp RECID=5 STAMP=803745792
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_nnndf_TAG20130103T144337_8gbb4trh_.bkp RECID=6 STAMP=803745818
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_ncnnf_TAG20130103T144337_8gbb6goj_.bkp RECID=7 STAMP=803745870
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_57_803644301.arc RECID=22 STAMP=803749182
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_03/o1_mf_annnn_TAG20130103T144432_8gbb6knl_.bkp RECID=8 STAMP=803745873
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_58_803644301.arc RECID=23 STAMP=803749229
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_59_803644301.arc RECID=26 STAMP=803749533
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_60_803644301.arc RECID=27 STAMP=803749771
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_61_803644301.arc RECID=28 STAMP=803749821
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_62_803644301.arc RECID=31 STAMP=803750073
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_63_803644301.arc RECID=34 STAMP=803750195
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_64_803644301.arc RECID=36 STAMP=803750380
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_65_803644301.arc RECID=37 STAMP=803751311
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_66_803644301.arc RECID=38 STAMP=803751358
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_67_803644301.arc RECID=41 STAMP=803751634
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_68_803644301.arc RECID=44 STAMP=803751922
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_69_803644301.arc RECID=46 STAMP=803751955
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_70_803644301.arc RECID=47 STAMP=803752503
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_71_803644301.arc RECID=48 STAMP=803752546
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_72_803644301.arc RECID=51 STAMP=803752834
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_73_803644301.arc RECID=54 STAMP=803753059
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_74_803644301.arc RECID=55 STAMP=803754254
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_75_803644301.arc RECID=56 STAMP=803754446
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_76_803644301.arc RECID=57 STAMP=803754783
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_77_803644301.arc RECID=58 STAMP=803754835
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_78_803644301.arc RECID=61 STAMP=803755116
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_79_803644301.arc RECID=64 STAMP=803755203
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_80_803644301.arc RECID=65 STAMP=803755716
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_81_803644301.arc RECID=67 STAMP=803756454
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_82_803644301.arc RECID=68 STAMP=803756778
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_83_803644301.arc RECID=69 STAMP=803756826
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_84_803644301.arc RECID=72 STAMP=803757098
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_85_803644301.arc RECID=74 STAMP=803757820
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_86_803644301.arc RECID=75 STAMP=803757820
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_87_803644301.arc RECID=76 STAMP=803757906
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_88_803644301.arc RECID=77 STAMP=803757950
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_89_803644301.arc RECID=80 STAMP=803758245
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_90_803644301.arc RECID=83 STAMP=803772050
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_91_803644301.arc RECID=85 STAMP=803784619
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_92_803644301.arc RECID=87 STAMP=803803394
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_93_803644301.arc RECID=89 STAMP=803813599
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T093320_8gddc2v8_.bkp RECID=9 STAMP=803813602
Deleted 65 objects
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
Note that the instance name is DG (I use it as data guard primary database).
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name DG are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f'; # default
RMAN> crosscheck datafilecopy '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f'
2> ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/04/2013 09:47:43
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20230: datafile copy not found in the repository
RMAN-06015: error while looking up datafile copy name: /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f RECID=12 STAMP=803757894
Crosschecked 1 objects
RMAN> crosscheck copy of controlfile;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f RECID=12 STAMP=803757894
Crosschecked 1 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 660 03-JAN-13 /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 01/04/2013 09:51:49
ORA-19606: Cannot copy or restore to snapshot control file
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 660 03-JAN-13 /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
RMAN> crosscheck copy ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
specification does not match any datafile copy in the repository
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f RECID=12 STAMP=803757894
validation succeeded for archived log
archived log file name=/u01/oradata/DG/arch/DG_1_94_803644301.arc RECID=91 STAMP=803813707
Crosschecked 2 objects
RMAN> delete expired copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any archived log in the repository
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
660 X 03-JAN-13 867176 03-JAN-13
Name: /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
Tag: TAG20130103T180453
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 01/04/2013 09:57:31
ORA-19606: Cannot copy or restore to snapshot control file
RMAN> exit
Recovery Manager complete.
- The way to clean it up is to change the configured location of the
snapshot controlfile, delete obsolete, and than change it back. see note 972539.1
So I followed it and it succeed.
RMAN> show all;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name DG are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f'; # default
RMAN> configure SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf2_DG.f'
2> ;
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf2_DG.f';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> show all;
RMAN configuration parameters for database with db_unique_name DG are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf2_DG.f';
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=181 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 660 03-JAN-13 /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
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/db_2/dbs/snapcf_DG.f RECID=12 STAMP=803757894
Deleted 1 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> configure SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f'
2> ;
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf2_DG.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> backup database plus archivelog;
Starting backup at 04-JAN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=94 RECID=91 STAMP=803813707
input archived log thread=1 sequence=95 RECID=93 STAMP=803815381
input archived log thread=1 sequence=96 RECID=94 STAMP=803816676
input archived log thread=1 sequence=97 RECID=96 STAMP=803816680
input archived log thread=1 sequence=98 RECID=98 STAMP=803817095
input archived log thread=1 sequence=99 RECID=100 STAMP=803817098
input archived log thread=1 sequence=100 RECID=103 STAMP=803828175
input archived log thread=1 sequence=101 RECID=104 STAMP=803828361
input archived log thread=1 sequence=102 RECID=106 STAMP=803829114
input archived log thread=1 sequence=103 RECID=108 STAMP=803829405
input archived log thread=1 sequence=104 RECID=110 STAMP=803829525
input archived log thread=1 sequence=105 RECID=113 STAMP=803835459
input archived log thread=1 sequence=106 RECID=114 STAMP=803835461
input archived log thread=1 sequence=107 RECID=116 STAMP=803835927
input archived log thread=1 sequence=108 RECID=117 STAMP=803835933
input archived log thread=1 sequence=109 RECID=118 STAMP=803836151
input archived log thread=1 sequence=110 RECID=119 STAMP=803836218
input archived log thread=1 sequence=111 RECID=120 STAMP=803836688
input archived log thread=1 sequence=112 RECID=121 STAMP=803836692
input archived log thread=1 sequence=113 RECID=122 STAMP=803836795
input archived log thread=1 sequence=114 RECID=124 STAMP=803836798
input archived log thread=1 sequence=115 RECID=127 STAMP=803836940
input archived log thread=1 sequence=116 RECID=129 STAMP=803840276
channel ORA_DISK_1: starting piece 1 at 04-JAN-13
channel ORA_DISK_1: finished piece 1 at 04-JAN-13
piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T165757_8gf6dq0o_.bkp tag=TAG201301 04T165757 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 04-JAN-13
Starting backup at 04-JAN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/oradata/DG/system01.dbf
input datafile file number=00002 name=/u01/oradata/DG/sysaux01.dbf
input datafile file number=00003 name=/u01/oradata/DG/undotbs01.dbf
input datafile file number=00005 name=/u01/oradata/DG/dg1_tbs01.dbf
input datafile file number=00004 name=/u01/oradata/DG/users01.dbf
channel ORA_DISK_1: starting piece 1 at 04-JAN-13
channel ORA_DISK_1: finished piece 1 at 04-JAN-13
piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T165806_8gf6dzp9_.bkp tag=TAG201301 04T165806 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 04-JAN-13
channel ORA_DISK_1: finished piece 1 at 04-JAN-13
piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T165806_8gf6gqsr_.bkp tag=TAG201301 04T165806 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-JAN-13
Starting backup at 04-JAN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=117 RECID=131 STAMP=803840345
channel ORA_DISK_1: starting piece 1 at 04-JAN-13
channel ORA_DISK_1: finished piece 1 at 04-JAN-13
piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T165906_8gf6gvkk_.bkp tag=TAG201301 04T165906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-JAN-13
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 740 04-JAN-13 /u01/oradata/DG/arch/DG_1_94_803644301.arc
Backup Set 741 04-JAN-13
Backup Piece 801 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T 093407_8gdddl62_.bkp
Backup Set 742 04-JAN-13
Backup Piece 802 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T 093407_8gddgb8l_.bkp
Archive Log 873 04-JAN-13 /u01/oradata/DG/arch/DG_1_95_803644301.arc
Backup Set 815 04-JAN-13
Backup Piece 818 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T 093509_8gddgg8n_.bkp
Archive Log 874 04-JAN-13 /u01/oradata/DG/arch/DG_1_96_803644301.arc
Archive Log 875 04-JAN-13 /u01/oradata/DG/arch/DG_1_97_803644301.arc
Archive Log 876 04-JAN-13 /u01/oradata/DG/arch/DG_1_98_803644301.arc
Archive Log 877 04-JAN-13 /u01/oradata/DG/arch/DG_1_99_803644301.arc
Archive Log 878 04-JAN-13 /u01/oradata/DG/arch/DG_1_100_803644301.arc
Archive Log 879 04-JAN-13 /u01/oradata/DG/arch/DG_1_101_803644301.arc
Archive Log 880 04-JAN-13 /u01/oradata/DG/arch/DG_1_102_803644301.arc
Archive Log 881 04-JAN-13 /u01/oradata/DG/arch/DG_1_103_803644301.arc
Archive Log 882 04-JAN-13 /u01/oradata/DG/arch/DG_1_104_803644301.arc
Archive Log 883 04-JAN-13 /u01/oradata/DG/arch/DG_1_105_803644301.arc
Archive Log 884 04-JAN-13 /u01/oradata/DG/arch/DG_1_106_803644301.arc
Archive Log 885 04-JAN-13 /u01/oradata/DG/arch/DG_1_107_803644301.arc
Archive Log 886 04-JAN-13 /u01/oradata/DG/arch/DG_1_108_803644301.arc
Archive Log 887 04-JAN-13 /u01/oradata/DG/arch/DG_1_109_803644301.arc
Archive Log 888 04-JAN-13 /u01/oradata/DG/arch/DG_1_110_803644301.arc
Archive Log 889 04-JAN-13 /u01/oradata/DG/arch/DG_1_111_803644301.arc
Archive Log 890 04-JAN-13 /u01/oradata/DG/arch/DG_1_112_803644301.arc
Archive Log 891 04-JAN-13 /u01/oradata/DG/arch/DG_1_113_803644301.arc
Archive Log 892 04-JAN-13 /u01/oradata/DG/arch/DG_1_114_803644301.arc
Archive Log 893 04-JAN-13 /u01/oradata/DG/arch/DG_1_115_803644301.arc
Backup Set 914 04-JAN-13
Backup Piece 917 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T 165609_8gf69c42_.bkp
Archive Log 933 04-JAN-13 /u01/oradata/DG/arch/DG_1_116_803644301.arc
Backup Set 915 04-JAN-13
Backup Piece 918 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T 165609_8gf6c3g2_.bkp
Backup Set 941 04-JAN-13
Backup Piece 944 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T 165757_8gf6dq0o_.bkp
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 740 04-JAN-13 /u01/oradata/DG/arch/DG_1_94_803644301.arc
Backup Set 741 04-JAN-13
Backup Piece 801 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T 093407_8gdddl62_.bkp
Backup Set 742 04-JAN-13
Backup Piece 802 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T 093407_8gddgb8l_.bkp
Archive Log 873 04-JAN-13 /u01/oradata/DG/arch/DG_1_95_803644301.arc
Backup Set 815 04-JAN-13
Backup Piece 818 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T 093509_8gddgg8n_.bkp
Archive Log 874 04-JAN-13 /u01/oradata/DG/arch/DG_1_96_803644301.arc
Archive Log 875 04-JAN-13 /u01/oradata/DG/arch/DG_1_97_803644301.arc
Archive Log 876 04-JAN-13 /u01/oradata/DG/arch/DG_1_98_803644301.arc
Archive Log 877 04-JAN-13 /u01/oradata/DG/arch/DG_1_99_803644301.arc
Archive Log 878 04-JAN-13 /u01/oradata/DG/arch/DG_1_100_803644301.arc
Archive Log 879 04-JAN-13 /u01/oradata/DG/arch/DG_1_101_803644301.arc
Archive Log 880 04-JAN-13 /u01/oradata/DG/arch/DG_1_102_803644301.arc
Archive Log 881 04-JAN-13 /u01/oradata/DG/arch/DG_1_103_803644301.arc
Archive Log 882 04-JAN-13 /u01/oradata/DG/arch/DG_1_104_803644301.arc
Archive Log 883 04-JAN-13 /u01/oradata/DG/arch/DG_1_105_803644301.arc
Archive Log 884 04-JAN-13 /u01/oradata/DG/arch/DG_1_106_803644301.arc
Archive Log 885 04-JAN-13 /u01/oradata/DG/arch/DG_1_107_803644301.arc
Archive Log 886 04-JAN-13 /u01/oradata/DG/arch/DG_1_108_803644301.arc
Archive Log 887 04-JAN-13 /u01/oradata/DG/arch/DG_1_109_803644301.arc
Archive Log 888 04-JAN-13 /u01/oradata/DG/arch/DG_1_110_803644301.arc
Archive Log 889 04-JAN-13 /u01/oradata/DG/arch/DG_1_111_803644301.arc
Archive Log 890 04-JAN-13 /u01/oradata/DG/arch/DG_1_112_803644301.arc
Archive Log 891 04-JAN-13 /u01/oradata/DG/arch/DG_1_113_803644301.arc
Archive Log 892 04-JAN-13 /u01/oradata/DG/arch/DG_1_114_803644301.arc
Archive Log 893 04-JAN-13 /u01/oradata/DG/arch/DG_1_115_803644301.arc
Backup Set 914 04-JAN-13
Backup Piece 917 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T 165609_8gf69c42_.bkp
Archive Log 933 04-JAN-13 /u01/oradata/DG/arch/DG_1_116_803644301.arc
Backup Set 915 04-JAN-13
Backup Piece 918 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T 165609_8gf6c3g2_.bkp
Backup Set 941 04-JAN-13
Backup Piece 944 04-JAN-13 /u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T 165757_8gf6dq0o_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_94_803644301.arc RECID=91 STAMP=803813707
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T093407_8gdddl62_.bkp RECID= 10 STAMP=803813650
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T093407_8gddgb8l_.bkp RECID= 11 STAMP=803813706
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_95_803644301.arc RECID=93 STAMP=803815381
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T093509_8gddgg8n_.bkp RECID= 12 STAMP=803813710
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_96_803644301.arc RECID=94 STAMP=803816676
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_97_803644301.arc RECID=96 STAMP=803816680
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_98_803644301.arc RECID=98 STAMP=803817095
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_99_803644301.arc RECID=100 STAMP=803817098
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_100_803644301.arc RECID=103 STAMP=803828175
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_101_803644301.arc RECID=104 STAMP=803828361
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_102_803644301.arc RECID=106 STAMP=803829114
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_103_803644301.arc RECID=108 STAMP=803829405
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_104_803644301.arc RECID=110 STAMP=803829525
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_105_803644301.arc RECID=113 STAMP=803835459
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_106_803644301.arc RECID=114 STAMP=803835461
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_107_803644301.arc RECID=116 STAMP=803835927
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_108_803644301.arc RECID=117 STAMP=803835933
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_109_803644301.arc RECID=118 STAMP=803836151
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_110_803644301.arc RECID=119 STAMP=803836218
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_111_803644301.arc RECID=120 STAMP=803836688
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_112_803644301.arc RECID=121 STAMP=803836692
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_113_803644301.arc RECID=122 STAMP=803836795
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_114_803644301.arc RECID=124 STAMP=803836798
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_115_803644301.arc RECID=127 STAMP=803836940
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_nnndf_TAG20130104T165609_8gf69c42_.bkp RECID= 13 STAMP=803840171
deleted archived log
archived log file name=/u01/oradata/DG/arch/DG_1_116_803644301.arc RECID=129 STAMP=803840276
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_ncsnf_TAG20130104T165609_8gf6c3g2_.bkp RECID= 14 STAMP=803840227
deleted backup piece
backup piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_01_04/o1_mf_annnn_TAG20130104T165757_8gf6dq0o_.bkp RECID= 15 STAMP=803840279
Deleted 29 objects
to add on, if still can't delte it after rename, may need to crosscheck the controfile .
e.g.
RMAN> crosscheck controlfilecopy;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "tag, double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 1 column 27 file: standard input
RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=178 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f RECID=14 STAMP=804079262
Crosschecked 1 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 1105 07-JAN-13 /u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f
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/db_2/dbs/snapcf_DG.f RECID=14 STAMP=804079262
Deleted 1 objects
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name DG are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG2.f';
RMAN> configure SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG2.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name DG are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f';
