在进行rman备份时报错
run {
2> allocate channel c1 device type disk;3> allocate channel c2 device type disk;
4> backup incremental level 0
5> format '/rmanbak/db_full_%U.bkp'
6> tag '2016-07-22-FULL'
7> database plus archivelog;
8> release channel c1;
9> release channel c2;
10> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=36 device type=DISK
allocated channel: c2
channel c2: SID=39 device type=DISK
Starting backup at 22-JUL-16
current log archived
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/22/2016 05:54:51
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /home/oracle/1_9_911268083.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
提示就是找不到这个文件1_9_911268083.dbf
第一个做法是越过去这个,就是查询v$archive_log这个视图。
select sequence# from v$archived_log;
SEQUENCE#
----------
67
237
238
239
240
241
在这里 我就可以从237开始
backup archivelog from sequence 237;
这种方法不推荐,下备份还会遇到,可以使用第二 方法
crosscheck archivelog all;
delete expired archivelog all;
这样这个没有物理文件的记录就从控制文件中删除了,再执行脚本就没有任何问题了