Getting an error running new RMAN backups against a standby database:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_2 channel at 01/08/2012 09:00:14
ORA-19607: /u20d/oradata/standby/stbyitst/standby01.ctl is an active control file
Turns out, there is a Metalink article to solve this issue: 444269.1
They don't call it a bug, but, somehow, the standby controlfile gets registered as a controlfile copy in the RMAN Metadata.  The solution is to "UNCATALOG" this controlfile copy:
RMAN> list copy of controlfile;
using target database control file instead of recovery catalog
List of Control File Copies
===========================
Key     S Completion Time Ckp SCN    Ckp Time
------- - --------------- ---------- ---------------
6       X 18-AUG-10       2315490331 18-AUG-10
        Name: /u20d/oradata/standby/stbyitst/standby01.ctl
        Tag: TAG20100818T094510
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     6      18-AUG-10          /u20d/oradata/standby/stbyitst/standby01.ctl
RMAN> change copy of controlfile uncatalog;
uncataloged control file copy
control file copy file name=/u20d/oradata/standby/stbyitst/standby01.ctl RECID=6 STAMP=727350310
Uncataloged 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> 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=135 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=133 device type=DISK
no obsolete backups found
After following the above procedure, no more problem with backups!
 
2 comments:
Hey, I was same issue, done the same. Issue resolved. Good job. Keep it up.
Again and as always, thanks Chris.
Mike A.
Post a Comment