AskTom

Hi,

today i wanted to backup our database but I found that samebody delete saem archivelog which wasn’t backed up.
When I tried to backup database I have got an error below.
RMAN-06059: expected archived log not found.
So how to solve this issue?

[oracle@centos53 dbs]$ rman target /
…
connected to target database: ORCL11G (DBID=806862530)

RMAN> backup database archivelog all delete input;

Starting backup at 11-NOV-09
…
archived log +DATA/orcl11g/archivelog/2009_11_08/thread_1_seq_58.275.702372629 not found or out of sync with catalog
trying alternate file for archived log of thread 1 with sequence 58
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/11/2009 02:50:45
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/product/11.1.0/db_1/dbs/arch1_58_699978250.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Solution
1) crosscheck archivelog all;
2) backup archivelog all skip inaccessible delete input;
3) backup database archivelog all delete input;

It’s done.

Regards,
Tom