Thinking Out Loud

March 25, 2012

RMAN-03009 ORA-19606

Filed under: 11g,oracle,RMAN — mdinh @ 12:41 am

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>

Create a free website or blog at WordPress.com.