非法删除归档日志，导致备份软件无法进行备份，急求解决办法！

cq_2006

各位好，由于一些原因导致oracle归档日志丢失或者不完整，导致备份软件调用rman无法备份oracle数据库
有什么命令能解决这个问题，请帮帮忙啊，谢谢了

错误提示如下：
2009-11-23 15:41:06  
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Nov 23 15:43:06 2009

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

RMAN> connect target *
2> RUN{
3> allocate channel c1 type disk;
4> backup tablespace 'SYSTEM','UNDOTBS1','SYSAUX','USERS','IDINFORMATION_DATA','IDINFORMATION_INDEX','IDINFORMATION_PHOTO','SCHOOL_DATA','SCHOOL_INDEX','SCHOOL_HISTRJN' format '/backup/tmp/MARSBAK_syntong_TABLESPACE_1258962186_44_%s.bak';
5> sql 'alter system archive log current';
6> backup archivelog all delete input format '/backup/tmp/MARSBAK_syntong_ARCHIVELOG_1258962186_44_%s.bak';
7> backup current controlfile format '/backup/tmp/MARSBAK_syntong_CONTROLFILE_1258962186_44_%s.bak';
8> release channel c1;
9> }
10> exit;
connected to target database: SYNTONG (DBID=3390010226)
using target database control file instead of recovery catalog

allocated channel: c1
channel c1: sid=129 devtype=DISK

Starting backup at 23-NOV-09
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracledata/u02/oradata/syntong/system01.dbf
input datafile fno=00005 name=/oracledata/u02/oradata/syntong/IDINFORMATION_DATA.dbf
input datafile fno=00006 name=/oracledata/u02/oradata/syntong/IDINFORMATION_INDEX.dbf
input datafile fno=00007 name=/oracledata/u02/oradata/syntong/IDINFORMATION_PHOTO.dbf
input datafile fno=00008 name=/oracledata/u02/oradata/syntong/SCHOOL_DATA.dbf
input datafile fno=00009 name=/oracledata/u02/oradata/syntong/SCHOOL_INDEX.dbf
input datafile fno=00010 name=/oracledata/u02/oradata/syntong/SCHOOL_HISTRJN.dbf
input datafile fno=00003 name=/oracledata/u02/oradata/syntong/sysaux01.dbf
input datafile fno=00004 name=/oracledata/u02/oradata/syntong/users01.dbf
input datafile fno=00002 name=/oracledata/u02/oradata/syntong/undotbs01.dbf
channel c1: starting piece 1 at 23-NOV-09
channel c1: finished piece 1 at 23-NOV-09
piece handle=/backup/tmp/MARSBAK_syntong_TABLESPACE_1258962186_44_47.bak tag=TAG20091123T154307 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 23-NOV-09
channel c1: finished piece 1 at 23-NOV-09
piece handle=/backup/tmp/MARSBAK_syntong_TABLESPACE_1258962186_44_48.bak tag=TAG20091123T154307 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 23-NOV-09

sql statement: alter system archive log current

Starting backup at 23-NOV-09
current log archived
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/23/2009 15:43:25
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /backup/archivelog/1_203_696190516.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Recovery Manager complete.

13627662

rman > crosscheck archivelog all;

wolfheader

为了备份不失败，还可以加skip inaccessiable~

cq_2006

先谢谢了  
我还想问一下，我在网上搜了一下 有的说是
crosscheck archivelog all;
delete obsolete
或者
RMAN>ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
RMAN>CROSSCHECK BACKUP;
RMAN>DELETE EXPIRED BACKUP;
RMAN>RELEASE CHANNEL;
不知道第二个有什么作用？

ziggler

www.shutdownabort.com/errors/RMAN-06059.php

netbackup

看看Oracle手册。

redwaves

抢分了。

无牙

当手工删除了数据库的归档文件后，需要用这个命令进行同步。
crosscheck archivelog all;

当手工删除了RMAN的备份级时，需要使用的是这个命令：
CROSSCHECK BACKUP;

他们的区别是同步的内容不同，一个是同步归档文件的状态，一个是同步RMAN备份信息。

myguangzhou

物理上删除了归档日志，但是控制文件并不知道；因此需要交叉检验以同步信息

无牙