带库备份中归档日志备份问题
现象：
$ more hot_database_backup.sh.out

Script. /nbu/hot_database_backup.sh
==== started on Wed Jan 30 05:26:21 CST 2008 ====


RMAN: /u02/oracle/app/oracle/product/9.2.0/bin/rman
ORACLE_SID: ora8i
ORACLE_USER: oracle
ORACLE_HOME: /u02/oracle/app/oracle/product/9.2.0

NB_ORA_FULL: 0
NB_ORA_INCR: 0
NB_ORA_CINC: 1
NB_ORA_SERV: nbu
NB_ORA_POLICY: oraip

Cumulative incremental backup requested
Sun Microsystems Inc. SunOS 5.8 Generic Patch February 2004
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> RM
AN> to target database: ORA8I (DBID=4283221404)
connected to recovery catalog database

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=360 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)

Starting backup at 30-JAN-08
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00008 name=/u01/oradata/ora8i/user04.dbf
input datafile fno=00013 name=/u01/oradata/ora8i/users08.dbf
input datafile fno=00011 name=/u01/oradata/ora8i/system02.dbf
input datafile fno=00003 name=/u01/oradata/ora8i/indx01.dbf
input datafile fno=00004 name=/u01/oradata/ora8i/tools01.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4877_1_645341183 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:15
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/oradata/ora8i/users01.dbf
input datafile fno=00009 name=/u01/oradata/ora8i/users05.dbf
input datafile fno=00016 name=/u01/oradata/ora8i/users11.dbf
input datafile fno=00014 name=/u01/oradata/ora8i/users09.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4878_1_645341318 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:36
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00006 name=/u01/oradata/ora8i/users02.dbf
input datafile fno=00010 name=/u01/oradata/ora8i/users06.dbf
input datafile fno=00017 name=/u01/oradata/ora8i/users12.dbf
input datafile fno=00015 name=/u01/oradata/ora8i/users10.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4879_1_645341474 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:25
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00007 name=/u01/oradata/ora8i/users03.dbf
input datafile fno=00012 name=/u01/oradata/ora8i/users07.dbf
input datafile fno=00001 name=/u01/oradata/ora8i/system01.dbf
input datafile fno=00002 name=/u01/oradata/ora8i/undotbs01.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4880_1_645341619 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:25
Finished backup at 30-JAN-08

Starting Control File and SPFILE Autobackup at 30-JAN-08
piece handle=c-4283221404-20080130-01 comment=API Version 2.0,MMS Version 5.0.0.0
Finished Control File and SPFILE Autobackup at 30-JAN-08

sql statement: alter system archive log current

released channel: ch00

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

Starting backup at 30-JAN-08
current log archived
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/30/2008 05:37:43
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oradata/ora8i/archive1_3797.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

RMAN>

Recovery Manager complete.

Script. /nbu/hot_database_backup.sh
==== ended in error on Wed Jan 30 05:37:44 CST 2008 ====$ more hot_database_backup.sh.out

Script. /nbu/hot_database_backup.sh
==== started on Wed Jan 30 05:26:21 CST 2008 ====


RMAN: /u02/oracle/app/oracle/product/9.2.0/bin/rman
ORACLE_SID: ora8i
ORACLE_USER: oracle
ORACLE_HOME: /u02/oracle/app/oracle/product/9.2.0

NB_ORA_FULL: 0
NB_ORA_INCR: 0
NB_ORA_CINC: 1
NB_ORA_SERV: nbu
NB_ORA_POLICY: oraip

Cumulative incremental backup requested
Sun Microsystems Inc. SunOS 5.8 Generic Patch February 2004
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> RM
AN> to target database: ORA8I (DBID=4283221404)
connected to recovery catalog database

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=360 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)

Starting backup at 30-JAN-08
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00008 name=/u01/oradata/ora8i/user04.dbf
input datafile fno=00013 name=/u01/oradata/ora8i/users08.dbf
input datafile fno=00011 name=/u01/oradata/ora8i/system02.dbf
input datafile fno=00003 name=/u01/oradata/ora8i/indx01.dbf
input datafile fno=00004 name=/u01/oradata/ora8i/tools01.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4877_1_645341183 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:15
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/oradata/ora8i/users01.dbf
input datafile fno=00009 name=/u01/oradata/ora8i/users05.dbf
input datafile fno=00016 name=/u01/oradata/ora8i/users11.dbf
input datafile fno=00014 name=/u01/oradata/ora8i/users09.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4878_1_645341318 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:36
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00006 name=/u01/oradata/ora8i/users02.dbf
input datafile fno=00010 name=/u01/oradata/ora8i/users06.dbf
input datafile fno=00017 name=/u01/oradata/ora8i/users12.dbf
input datafile fno=00015 name=/u01/oradata/ora8i/users10.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4879_1_645341474 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:25
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00007 name=/u01/oradata/ora8i/users03.dbf
input datafile fno=00012 name=/u01/oradata/ora8i/users07.dbf
input datafile fno=00001 name=/u01/oradata/ora8i/system01.dbf
input datafile fno=00002 name=/u01/oradata/ora8i/undotbs01.dbf
channel ch00: starting piece 1 at 30-JAN-08
channel ch00: finished piece 1 at 30-JAN-08
piece handle=bk_4880_1_645341619 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:02:25
Finished backup at 30-JAN-08

Starting Control File and SPFILE Autobackup at 30-JAN-08
piece handle=c-4283221404-20080130-01 comment=API Version 2.0,MMS Version 5.0.0.0
Finished Control File and SPFILE Autobackup at 30-JAN-08

sql statement: alter system archive log current

released channel: ch00

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

Starting backup at 30-JAN-08
current log archived
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/30/2008 05:37:43
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oradata/ora8i/archive1_3797.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

RMAN>

Recovery Manager complete.

Script. /nbu/hot_database_backup.sh
==== ended in error on Wed Jan 30 05:37:44 CST 2008 ====

解决方法：
在rman下执行如下语句：change archivelog all crosscheck ;然后重新备份就正常了。