Hello Guys,
Nowadays I have this problem: ORA-19606 and after I investigated, I found some an articles about this and I use metalink (Error ORA-19606 on RMAN Delete (Doc ID 1215493.1), but I want to know if it is bug...
when I executed : delete obsolete i have some files obsolete and don't possible remove... look
....
...
Backup Piece 8739 17_APR_2016_11:01:26 /u01/arc0_DB_20160417_9649_1.arc
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 04/17/2016 11:16:30
ORA-19606: Cannot copy or restore to snapshot control file
It's very older file... but what I have to do to fix this problem:
-- temporary
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_TRCPRD.f';
-- its works..
delete obsolete
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/olderpath/snapcf_TRCPRD.f';
its, ok...
I've done this steps:
RMAN> crosscheck controlfilecopy '/u01/snapcf_db.f';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=84 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 05/05/2016 09:18:22
RMAN-20220: control file copy not found in the repository
RMAN-06090: error while looking up control file copy: /u01/snapcf_db.f
[oracle@db]$ ll /u01/snapcf_db.f
-rw-r----- 1 oracle oinstall 14008320 Mai 5 10:00 /u01/snapcf_db.f
RMAN> crosscheck BACKUPPIECE '/u01/snapcf_db.f';
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 05/05/2016 09:21:16
RMAN-20260: backup piece not found in the repository
RMAN-06092: error while looking up backup piece
RMAN> CATALOG CONTROLFILECOPY '/u01/snapcf_db.f';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 05/05/2016 09:14:59
ORA-19584: file /u01/snapcf_db.f already in use
RMAN> change controlfilecopy '/u01/snapcf_db.f' uncatalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of uncatalog command at 05/05/2016 09:14:59
RMAN-20220: control file copy not found in the repository
RMAN-06090: error while looking up control file copy: /u01/snapcf_db.f
RMAN> crosscheck copy of controlfile;
does not work..
RMAN> delete expired copy of controlfile;
does not work..
RMAN> delete force obsolete;
does not work..
only works when I changed the controlfile name like I mensioned above..
CONFIGURE SNAPSHOT CONTROLFILE NAME...
What is real problem?
Thank you everybody!