环境：oracle10g rac，两个节点，实例名分别为racdb1和racdb2，数据库名racdb。两个实例的log_archive_dest_1均设置为'LOCATION=/opt/app/oracle/archive/arch1'。两个实例的archivelog均在本地，也没有nfs。
现要通过RMAN备份归档时出现找不到归档文件的错误。下面是**屏蔽**作的过程：
1、在节点一上修改log_archive_dest_1的SID，操作如下：
SQL> alter system set log_archive_dest_1 = 'LOCATION=/opt/app/oracle/archive/arch1' SID = 'racdb1';
System altered.
在节点二上修改log_archive_dest_1的SID，操作如下：
SQL> alter system set log_archive_dest_1 = 'LOCATION=/opt/app/oracle/archive/arch1' SID = 'racdb2';
System altered.
2、RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
3、使用下列脚本备份
run{
allocate channel rac1 type 'sbt_tape'
connect 'sys/oracle@racdb1'
parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_zh.opt)';
allocate channel rac2 type 'sbt_tape'
connect 'sys/oracle@racdb2'
parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_zh.opt)';
sql 'alter system archive log thread 2 current';
sql 'alter system archive log thread 1 current';
backup
filesperset 10
format 'arch_%t_%s_%c_%p.arc'
(archivelog UNTIL TIME 'SYSDATE' delete all input channel rac1)
(archivelog UNTIL TIME 'SYSDATE' delete all input channel rac2);
release channel rac1;
release channel rac2;
}
不论在哪个节点都会出现类似下面的错误提示:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/28/2008 15:36:35
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/app/oracle/archive/arch1/2_124_642339076.dbf
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: A file or directory in the path name does not exist.
Additional information: 3
分解在两个节点上
crosscheck archivelog all;
delete expired archivelog all;
每次都会找到一些不同的文件，删除后再备份问题依旧。（只是文件名换了）
请问，这种问题该如何解决。是否应在 backup archivelog 中加 like 之类的，不是很明白，能否指点指点呀，谢谢！
另：在racdb1的/arch1/中大多是1_%.dbf，只有两三个2_%.dbf（是不是由于racdb2的/arch1/满了，放到这边的？）
|
