Crosscheck archives (CHANGE ARCHIVELOG ALL VALIDATE)
                                                 Last update (2011-02-22 12:48:47)
                                                                                                                   Date added (2008-06-16 20:50:27)

Summary
Maybe for some reason you have lost some archives or delete them on purpose. The result is the RMAN backup of the archives to constantly fail. For example you might get error messages from rman backup like this
channel t1: starting piece 1 at 29-APR-04
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 04/29/2004 18:01:05
ORA-19505: failed to identify file "/oradmp/archive/PRODDB/PRODDB_1_161663.arc"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
The workaround is to connect to the RMAN catalog and execute a validation of the archive logs.
The Recovery Manager CHANGE command removes references to a backup piece, (datafile or archivelog) from the controlfile and recovery catalog when the file no longer exists on disk.

First connect to the RMAN Catalog. Login as oracle owner of the software at the unix and set the ORACLE_HOME.
rman target / catalog rman/*****@RMAN

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

target database Password: 
connected to target database: PRODDB (DBID=4131138365)
connected to recovery catalog database
Then crosscheck the archives.
RMAN>CHANGE ARCHIVELOG ALL VALIDATE;
Tip: If you have a RAC system you need to validate archives from both nodes.
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search