Chinaunix

标题: 如何解决9i备份出现的ORA-19625错误 [打印本页]

作者: muone 时间: 2007-01-27 14:45
标题: 如何解决9i备份出现的ORA-19625错误
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 时间: 2007-01-27 14:48
之前有出现过日志丢失的情况..一般我做了crosscheck archivelog all后就可以备份了..不过现在就不行了.请大家帮忙看看吧.谢谢了

作者: kmzx 时间: 2007-01-28 00:57
改下脚本，在archivelog那加上from time（或 SEQ、SCN）项，把找不到的archlog/2_226.dbf跳开就行了。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)