Database Software

Hi ,

Below is the problem Description :

We have a datagurad setup (primary and standby) . On primary , archive log is archived into 3 different locations :

1] +DATA
2] /media/archivelogs/ (This is a network Drive)
3]/home/oracle/archivelogs/

The backup was failing from the last few days . Upon investigation , it was found that some of the archive logs in /media/archivelogs/ mount point did not exist .

I then ran the RMAN> crosscheck archivelog all; command hoping that the next execution of the RMAN backup will succeed . But strangly , the backup still failed with the below error :

RMAN-03002: failure of backup plus archivelog command at 07/19/2011 10:37:08
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /media/archivelogs/arc1_101341_643980013.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


I then queried the v$archived_log for the status :

SQL> select Name, ARCHIVED , STATUS , DELETED from v$archived_log where SEQUENCE#='101341';


NAME ARC S DEL
--------------------------------------------- --- - ---
YES D YES
/media/archivelogs/arc1_101341_643980013.dbf YES X NO (we can see the status as expired)
YES D YES


My understandg is that RMAN should sikp the expired archivelog (Status = X ) and continue to backup the database .


Questions :

1] why does RMAN still looking for /media/archivelogs/arc1_101341_643980013.dbf even after crosscheck ?