如何解决9i备份出现的ORA-19625错误

muone

RMAN脚本:
MAN> connect target xxx/xxx@xxxx;
> connect rcvcat rman/backupdb@rman;
> run{
>    allocate channel t1 type 'sbt_tape';
>    allocate channel t2 type 'sbt_tape';
>    send 'NSR_ENV=(NSR_SERVER=gsdx-1nk86gjbj5,NSR_LOG_VOLUME_POOL=database,NSR
CLIENT=server1_svc)';
>    sql 'alter system switch logfile';
>    backup full filesperset 4
>    format 'archivelog_%p_%u_%s_%t'
0>    (archivelog all delete input);
1>   release channel t1;
2>   release channel t2;
3> }


日志如下
MAN-00571: ===========================================================
MAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
MAN-00571: ===========================================================
MAN-03002: failure of backup command at 01/27/2007 14:23:54
MAN-06059: expected archived log not found, lost of archived log compromises re
overability
RA-19625: error identifying file /archlog/2_225.dbf
RA-27037: unable to obtain file status
BM AIX RISC System/6000 Error: 2: No such file or directory
dditional information: 3


进入rman连接了target数据库和catalog数据库后做了
crosscheck archivelog all;
然后作delete expired archivelog all;

在执行RMAN备份脚本后还是要出现以上的信息,不过 error identifying file /archlog/2_225.dbf
信息变为archlog/2_226.dbf

我到我的/archilog目录下根本没有2_225.dbf的文件.....根据日期最新的日志文件为以下..



2048 Jan 27 13:52 1_285.dbf
51712 Jan 27 13:59 1_286.dbf
2560 Jan 27 13:59 1_287.dbf
54272 Jan 27 14:09 1_288.dbf
2048 Jan 27 14:09 1_289.dbf
37888 Jan 27 14:16 1_290.dbf
2048 Jan 27 14:16 1_291.dbf
35328 Jan 27 14:23 1_292.dbf
1536 Jan 27 14:23 1_293.dbf

请大家帮忙看看.谢谢

muone

之前有出现过日志丢失的情况..一般我做了crosscheck archivelog all后就可以备份了..不过现在就不行了.请大家帮忙看看吧.谢谢了

kmzx

改下脚本，在archivelog那加上from time（或 SEQ、SCN） 项，把找不到的archlog/2_226.dbf跳开就行了。