I came across the following errors and could not remember how it was resolved the last time.
RMAN-03009: failure of delete command on ORA_DISK_4 channel at 03/23/2012 11:36:53 ORA-19606: Cannot copy or restore to snapshot control file
CONFIGURE SNAPSHOT CONTROLFILE again and delete obsolete.
RMAN> show all; RMAN configuration parameters for database with db_unique_name SAVVIS_DB08 are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET; 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 'LOW' OPTIMIZE FOR LOAD TRUE AS OF RELEASE 'DEFAULT'; CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/snapcf_db08.f'; # default RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/snapcf_db08.f'; new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/snapcf_db08.f'; new RMAN configuration parameters are successfully stored RMAN> delete noprompt obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 1 days using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Control File Copy 9 07-OCT-2011 21:50:17 /u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/snapcf_db08.f deleted control file copy control file copy file name=/u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/snapcf_db08.f RECID=9 STAMP=763941017 Deleted 1 objects RMAN>
Advertisements