delete_unavailable_controlfile_copy

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due

RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212:   Object Type   Filename/Handle

RMAN-06213: --------------- ---------------------------------------------------

RMAN-06214: Datafile Copy   /tmp/standby.ctl

[1|rdb03|/backup/mvan]-$ rman catalog rman/rman@emrep target sys/master@mvan03

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Apr 1 18:31:04 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: MVAN (DBID=2393792140)

connected to recovery catalog database

RMAN> list controlfilecopy '/tmp/standby.ctl';

List of Control File Copies

Key     S Completion Time Ckp SCN    Ckp Time        Name

------- - --------------- ---------- --------------- ----

1541970 A 13-FEB-09       2197256889 13-FEB-09       /tmp/standby.ctl

RMAN> crosscheck controlfilecopy '/tmp/standby.ctl';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=632 instance=mvan03 devtype=DISK

validation failed for control file copy

control file copy filename=/tmp/standby.ctl recid=1 stamp=678729577

Crosschecked 1 objects

RMAN> list controlfilecopy '/tmp/standby.ctl';

List of Control File Copies

Key     S Completion Time Ckp SCN    Ckp Time        Name

------- - --------------- ---------- --------------- ----

1541970 X 13-FEB-09       2197256889 13-FEB-09       /tmp/standby.ctl

RMAN> 

RMAN> list expired copy;

specification does not match any archive log in the recovery catalog

List of Control File Copies

Key     S Completion Time Ckp SCN    Ckp Time        Name

------- - --------------- ---------- --------------- ----

1541970 X 13-FEB-09       2197256889 13-FEB-09       /tmp/standby.ctl

RMAN> delete expired copy;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=632 instance=mvan03 devtype=DISK

specification does not match any archive log in the recovery catalog

List of Control File Copies

Key     S Completion Time Ckp SCN    Ckp Time        Name

------- - --------------- ---------- --------------- ----

1541970 X 13-FEB-09       2197256889 13-FEB-09       /tmp/standby.ctl

Do you really want to delete the above objects (enter YES or NO)? YES

deleted control file copy

control file copy filename=/tmp/standby.ctl recid=1 stamp=678729577

Deleted 1 EXPIRED objects

RMAN>