ORA-19606: Cannot copy or restore to snapshot control file

Because there are not many flash areas, select * from v $ flash_recovery_area_usage and find that the backup set occupies too much space.
So delete obsolete; found the error ORA-19606: Cannot copy or restore to snapshot control file

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 = 174 device type = DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
----------------------------------------------------------------
Control File Copy 1 23-AUG-13/u01/app/Oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f
Backup Set 560 20-SEP-13
Backup Piece 560 20-SEP-13 + DATADG/finerem/backupset/2013_09_20/annnf0_tag20130920t233259_0.1829.826673579
Backup Set 561 20-SEP-13
Backup Piece 561 20-SEP-13 + DATADG/finerem/autobackup/2013_09_20/s_826673580.945.826673581
Backup Set 562 21-SEP-13
Backup Piece 562 21-SEP-13 + DATADG/finerem/backupset/2013_09_21/annnf0_tag20130921t233004_0.623.826759805
Backup Set 563 21-SEP-13
Backup Piece 563 21-SEP-13 + DATADG/finerem/backupset/2013_09_21/nnndf0_tag20130921t233011_0.693.826759813
Backup Set 564 21-SEP-13
Backup Piece 564 21-SEP-13 + DATADG/finerem/backupset/2013_09_21/annnf0_tag20130921t233257_0.807.826759977
Backup Set 565 21-SEP-13
Backup Piece 565 21-SEP-13 + DATADG/finerem/autobackup/2013_09_21/s_826759979.743.826759979
Backup Set 566 22-SEP-13
Backup Piece 566 22-SEP-13 + DATADG/finerem/backupset/2013_09_22/annnf0_tag20130922t233005_0.1800.826846207
Backup Set 567 22-SEP-13
Backup Piece 567 22-SEP-13 + DATADG/finerem/backupset/2013_09_22/nnndf0_tag20130922t233021_0.624.826846223
Backup Set 568 22-SEP-13
Backup Piece 568 22-SEP-13 + DATADG/finerem/backupset/2013_09_22/annnf0_tag20130922t233307_0.1887.826846387
Backup Set 569 22-SEP-13
Backup Piece 569 22-SEP-13 + DATADG/finerem/autobackup/2013_09_22/s_826846388.1891.826846389
Backup Set 570 23-SEP-13
Backup Piece 570 23-SEP-13 + DATADG/finerem/backupset/2013_09_23/annnf0_tag20130923t233004_0.20.1.826932605
Backup Set 571 23-SEP-13
Backup Piece 571 23-SEP-13 + DATADG/finerem/backupset/2013_09_23/nnndf0_tag20130923t233020_0.776.826932621
Backup Set 572 23-SEP-13
Backup Piece 572 23-SEP-13 + DATADG/finerem/backupset/2013_09_23/annnf0_tag20130923t233306_0.1895.826932787
Backup Set 573 23-SEP-13
Backup Piece 573 23-SEP-13 + DATADG/finerem/autobackup/2013_09_23/s_826932787.20.1.826932789
Backup Set 574 24-SEP-13
Backup Piece 574 24-SEP-13 + DATADG/finerem/backupset/2013_09_24/annnf0_tag20130924t233005_0.20.2.827019005

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 09/25/2013 09:16:59
ORA-19606: Cannot copy or restore to snapshot control file

Solution:
Changes the configuration path of the snapshot controlfile and then deletes the SNAPSHOT of the control file.
--- Rename the SNAPSHOT File
RMAN> configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f_bak ';

New RMAN configuration parameters:
Configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f_bak ';
New RMAN configuration parameters are successfully stored

---- Crosscheck
RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f ';

Released channel: ORA_DISK_1
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 174 device type = DISK
Validation failed for control file copy
Control file copy file name =/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f RECID = 1 STAMP = 824231734
Crosschecked 1 objects

SPFILE error causing database startup failure (ORA-01565)

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store

1 2 Next Page