RMAN-06207:: delete obsolete
569701Aug 1 2007 — edited Dec 2 2012Hello All,
I searched the forum with the error, and could not reach anywhere.
I 'am using 10gR2.
The deletion of the obsolete files ends up with one archive log file left over without being deleted.
rman>delete noprompt obsolete device type disk;
RMAN-06214: Archivelog /u02/oracle/shcl1dg/archivelog/SHCL1_1_1250_596301406.arch
RMAN-06213: --------------- ---------------------------------------------------
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: ==========================
This is the archive log of the the standby. This file does not exist in the location
RMAN> crosscheck archivelog '/u02/oracle/shcl1dg/archivelog/SHCL1_1_1250_596301406.arch'
2> ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 08/02/2007 11:21:52
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20240: archived log not found in the recovery catalog
RMAN-06046: archive log name: /u02/oracle/shcl1dg/archivelog/SHCL1_1_1250_596301406.arch
RMAN>
How do i delete this file from the oracle's "BRAIN" .
TIA,
J J