Oracle 10.2.0.2 and 11d problem with archive files

[Peter_Baade]

I just installed 11d and ran a full backup of my Oracle database, but it seems like some of my archive file is missing. Is there a way to sync the archive files and the database files so I can backup my Oracle? I get this script from 11d:

Recovery Manager: Release 10.2.0.2.0 - Production on Tue Dec 5 02:39:23 2006

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


# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------

RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=172.16.0.2,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={FC7755EC-F152-4D42-95FC-DA651FACF212},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\172.16.0.6\isis';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'BE_U'
DATABASE FORCE PLUS ARCHIVELOG FORCE;
BACKUP CURRENT CONTROLFILE
FORMAT 'BE_U';

RELEASE CHANNEL ch0;
}

connected to target database: ISIS (DBID=1483583394)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=304 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0


Starting backup at 05-DEC-06
current log archived
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/05/2006 02:39:28
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file D:\ORADATA\ISIS\ARCHIVE\ARC01638_0572552164.001
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Recovery Manager complete.

Devices acquired: 1
Data streams used: 0

[James_Jenkins_2]

Peter,

This is a common situation, and the way to get the controlfiles updated with the current archivelog files is to use the CROSSCHECK command. This will cause Oracle to sync up the controlfile records with the current status of the archivelogs. Once that CROSSCHECK command is completed, please advise if there are any further problems with those Oracle backups.

Here's a basic list of steps:

POTENTIAL SOLUTION(S)
======================
rman> CROSSCHECK ARCHIVELOG ALL ;

After running crosscheck and you detect a archivelog is missing , then the archivelog is set STATUS EXPIRED !!!

If you then use:

rman> DELETE EXPIRED ARCHVIELOG ;

this will then remove the entry for that 'expired' archivelog from RMAN Catalog (or controlfile) !!!
So RMAN does not have infromation about that archived logfile anymore

As per documentation, after delteing expired logs, this compromises availability of recovery !!
HENCE it is strongly recomended after you delete expired Archivelogs to take a new FULL Database backup !!

RMAN RESTORE VALIDATE - does only verify if the files can be restored from backup.
It does not check for missing logs !!!