在线求助-Legato备份Oracle归档日志失败!

hellojack623

各位大大,使用Legato备份Oracle数据库的归档日志到磁带中,一直不能成功,全备和增备则可以.Legato中关于RMAN脚本执行的日志如下:

:/opt/networker/bin/rmanscript/db_arch1
:/opt/networker/bin/rmanscript/db_arch1 Recovery Manager: Release 8.1.6.3.0 - Production
:/opt/networker/bin/rmanscript/db_arch1
:/opt/networker/bin/rmanscript/db_arch1 RMAN> connect target internal/manager@test
:/opt/networker/bin/rmanscript/db_arch1 2> connect rcvcat rman/rman@rman
:/opt/networker/bin/rmanscript/db_arch1 3> run {
:/opt/networker/bin/rmanscript/db_arch1 4> allocate channel b1 type 'sbt_tape'
:/opt/networker/bin/rmanscript/db_arch1 5> parms 'ENV=(NSR_SERVER=ssmxbf01,NSR_DATA_VOLUME_POOL=oralog12/24/06 05:01:06 savegrp: :/opt/networker/bin/rmanscript/db_arch1 will retry 1 more time(s)
)';
:/opt/networker/bin/rmanscript/db_arch1 6> #sql 'alter system archive log current';
:/opt/networker/bin/rmanscript/db_arch1 7> #change archivelog all crosscheck;
:/opt/networker/bin/rmanscript/db_arch1 8> backup filesperset 8(archivelog from time 'Apr 15 2001 23:21:00'
:/opt/networker/bin/rmanscript/db_arch1 9> until time 'sysdate' thread 1 delete input format 'arch1_%d_%u');
:/opt/networker/bin/rmanscript/db_arch1 10> release channel b1;
:/opt/networker/bin/rmanscript/db_arch1 11> }
:/opt/networker/bin/rmanscript/db_arch1 12>
:/opt/networker/bin/rmanscript/db_arch1 RMAN-06005: connected to target database: SMXJF (DBID=64072509)
:/opt/networker/bin/rmanscript/db_arch1
:/opt/networker/bin/rmanscript/db_arch1 RMAN-06008: connected to recovery catalog database
:/opt/networker/bin/rmanscript/db_arch1
:/opt/networker/bin/rmanscript/db_arch1 RMAN-03022: compiling command: allocate
:/opt/networker/bin/rmanscript/db_arch1 RMAN-03023: executing command: allocate
:/opt/networker/bin/rmanscript/db_arch1 RMAN-08030: allocated channel: b1
:/opt/networker/bin/rmanscript/db_arch1 RMAN-08500: channel b1: sid=39 devtype=SBT_TAPE
:/opt/networker/bin/rmanscript/db_arch1 RMAN-08526: channel b1: NMO v3.5.0.0
:/opt/networker/bin/rmanscript/db_arch1 RMAN-06421: sent command to channel: b1
:/opt/networker/bin/rmanscript/db_arch1
:/opt/networker/bin/rmanscript/db_arch1 RMAN-03022: compiling command: backup
:/opt/networker/bin/rmanscript/db_arch1 RMAN-00571: ===========================================================
:/opt/networker/bin/rmanscript/db_arch1 RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============
:/opt/networker/bin/rmanscript/db_arch1 RMAN-00571: ===========================================================
:/opt/networker/bin/rmanscript/db_arch1 RMAN-03002: failure during compilation of command
:/opt/networker/bin/rmanscript/db_arch1 RMAN-03013: command type: backup
:/opt/networker/bin/rmanscript/db_arch1 RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog
:/opt/networker/bin/rmanscript/db_arch1
:/opt/networker/bin/rmanscript/db_arch1 Recovery Manager complete.
:/opt/networker/bin/rmanscript/db_arch1 12/24/06 05:19:27 NetWorker: Error: process 10293 running command "/o8I/app/oracle/product/8.1.6/bin/rman" completed with an error code of 1.
:/opt/networker/bin/rmanscript/db_arch1 nsrnmostart returned status of 1
:/opt/networker/bin/rmanscript/db_arch1 /opt/networker/bin/nsrnmo exiting.

请问是何原因? 如何操作才能纠正错误?

本人是Oracle的菜鸟,请各位大大帮帮小弟,谢谢!

numenhuang

:/opt/networker/bin/rmanscript/db_arch1 6> #sql 'alter system archive log current';
:/opt/networker/bin/rmanscript/db_arch1 7> #change archivelog all crosscheck;
:/opt/networker/bin/rmanscript/db_arch1 8> backup filesperset 8(archivelog from time 'Apr 15 2001 23:21:00'
:/opt/networker/bin/rmanscript/db_arch1 9> until time 'sysdate' thread 1 delete input format 'arch1_%d_%u');
:/opt/networker/bin/rmanscript/db_arch1 10> release channel b1;
:/opt/networker/bin/rmanscript/db_arch1 11> }

1. 数据库版本？
2. sqlplus / as sysdba
    sql>archive log list;
    结果？

3. rman>list incarnation of database;

4. select name,completion_time from v$archived_log;
    结果？

hellojack623

谢谢楼上的帮忙!
数据库版本是8i的,由于我没有数据库的操作权限,所以后面几个命令现在无法尝试
如果方便的话能不能先列举出几种可能性,然后我再排查一下
刚才在网上搜索了一下这个报错信息,有的提到了归档日志的一致性问题,那么我可不可以尝试用change archivelog all crosscheck做一下一致性检查呢?

numenhuang

原帖由 hellojack623 于 2006-12-25 12:54 发表
谢谢楼上的帮忙!
数据库版本是8i的,由于我没有数据库的操作权限,所以后面几个命令现在无法尝试
如果方便的话能不能先列举出几种可能性,然后我再排查一下
刚才在网上搜索了一下这个报错信息,有的提到了归档日志 ...

你可以使用
RMAN> change archivelog all validate;
先检查archivelog。

数据库不是运行在archivelog模式下或者可能在log_archive_dest下没有符合条件的archived log。

hellojack623

谢谢! 我对下面这三条命令有点搞不清他们的作用

resync catalog
change archivelog all crosscheck
change archivelog all validate

都分别在什么情况下用呢?

hellojack623

还有,我如何查看数据库是在archivelog或者noarchivelog模式下运行呢?谢谢!