oracle9i的RMAN备份失败（NBU5.0备份）

linvswin

操作系统是AIX5.0的，用NBU5.0备份oracle9i数据库，做全备份。
已经打开数据库归档模式，采用的是RMAN热备份。
在备份客户端收集到以下错误日志：
Script /scripts/hot_database_backup.sh
==== started on Tue Mar 22 21:47:30 BEIST 2005 ====


RMAN: /oracle/product/9.2.0.1/bin/rman
ORACLE_SID: test
ORACLE_USER: oracle
ORACLE_HOME: /oracle/product/9.2.0.1

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: backupserver
NB_ORA_POLICY: ora_svr1

Full backup requested

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: test (DBID=333347616)
using target database controlfile instead of recovery catalog

RMAN>; 2>; 3>; 4>; 5>; 6>; 7>; 8>; 9>; 10>; 11>; 12>; 13>; 14>; 15>; 16>; 17>; 18>; 19>; 20>; 21>; 22>; 23>; 24>; 25>; 26>; 27>; 28>; 29>; 30>; 31>; 32>; 33>; 34>; RMAN>; 2>; 3>; 4>; 5>; 6>; 7>; 8>; 9>; 10>; 11>; 12>; 13>; 14>; 15>; 16>; 17>; 18>; 19>; 20>; 21>; 22>; 23>; 24>; 25>; 26>; 27>; 28>; 29>; 30>; 31>; 32>; 33>; 34>;
allocated channel: ch00
channel ch00: sid=12 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2004051401)

Starting backup at 22-MAR-05
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00009 name=/ora_data/test/DLDF_DATA1.ORA
input datafile fno=00010 name=/ora_data/test/DLDF_IDX1.ORA
input datafile fno=00008 name=/ora_data/test/YDDA_IDX1.ORA
input datafile fno=00013 name=/ora_data/test/TRANS_DATA1.ORA
input datafile fno=00014 name=/ora_data/test/DLDFHIS_ODATA1.ORA
channel ch00: starting piece 1 at 22-MAR-05
channel ch00: finished piece 1 at 22-MAR-05
piece handle=bk_461_1_553643255 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:42:28
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00012 name=/ora_data/test/DLDFHIS_IDX1.ORA
input datafile fno=00007 name=/ora_data/test/YDDA_DATA1.ORA
input datafile fno=00001 name=/ora_index/test/system01.dbf
channel ch00: starting piece 1 at 22-MAR-05
channel ch00: finished piece 1 at 22-MAR-05
piece handle=bk_462_1_553645804 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:55:10
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00002 name=/ora_index/test/undotbs01.dbf
input datafile fno=00004 name=/ora_index/test/indx01.dbf
input datafile fno=00006 name=/ora_index/test/users01.dbf
input datafile fno=00003 name=/ora_index/test/drsys01.dbf
input datafile fno=00005 name=/ora_index/test/tools01.dbf
channel ch00: starting piece 1 at 22-MAR-05
channel ch00: finished piece 1 at 23-MAR-05
piece handle=bk_463_1_553649115 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:37:39
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00011 name=/ora_data/test/DLDFHIS_DATA1.ORA
channel ch00: starting piece 1 at 23-MAR-05
channel ch00: finished piece 1 at 23-MAR-05
piece handle=bk_464_1_553651375 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 01:14:60
Finished backup at 23-MAR-05

sql statement: alter system archive log current

released channel: ch00

allocated channel: ch00
channel ch00: sid=12 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2004051401)

Starting backup at 23-MAR-05
current log archived
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/23/2005 01:18:00
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /ora_index/archivelog/1_1343.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

RMAN>; RMAN>;

Recovery Manager complete.

Script /scripts/hot_database_backup.sh
==== ended in error on Wed Mar 23 01:18:01 BEIST 2005 ====

请问有没有什么办法解决啊。
谢谢！

sonorous

archivelog文件没找到啊，好像是路径不对，把你的备份脚本中备archivelog的那段脚本贴出来看看

还有一种可能，你是不是删除过archivelog了，如果是的话，你做一个crosscheck

川菜厨子

用操作系统命令删除了archivelog
没做crosscheck的话就会出现这样的问题

在rman里
Crosscheck backup;
Crosscheck archivelog all;
Delete [noprompt] expired backup命令删除过期备份

sonorous

在rman里执行一次CHANGE ARCHIVELOG ALL CROSSCHECK

就行了

linvswin

是因为我删除了归档日志，谢谢各位指点。谢谢

linvswin

我做了crosscheck archivelog all之后，现在NBU备份数据库还是不行，错误日志：
Script /scripts/hot_database_backup.sh
==== started on Mon Mar 28 18:38:43 BEIST 2005 ====


RMAN: /oracle/product/9.2.0.1/bin/rman
ORACLE_SID: test
ORACLE_USER: oracle
ORACLE_HOME: /oracle/product/9.2.0.1

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: backupserver
NB_ORA_POLICY: ora_test

Full backup requested

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01092: ORACLE instance terminated. Disconnection forced

Script /scripts/hot_database_backup.sh
==== ended in error on Mon Mar 28 18:38:44 BEIST 2005 ====

请各位大虾帮忙分析原因，谢谢！

yddll

error from target database

老邱

手工进rman试一下。如果不行重起oracle再试一下。

ORA-01092: ORACLE instance terminated. Disconnection forced
好像在你运行rman的时候数据库被关掉了（这么巧？）