RMAN-06059: expected archived log not found

使用plus archivelog 参数，报下边的错误：

RMAN> backup database plus archivelog format '/u01/backup/wb_%U';

Starting backup at 11-JUN-14

current log archived

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 06/11/2014 09:52:30

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file /u01/frank_archlog/1_9_848141027.dbf

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

原因：之前自己手动用rm命令删掉了归档日志。但是controlfile中还记录着归档日志信息，oracle还会去找这些归档日志文件，因此就会报错。

解决方法：使控制文件中的归档日志信息和实际物理文件信息保持一致；

1. corsscheck archivelog all；

此命令用来检查控制文件和实际物理文件信息的差异。

2.delete expired archivelog all；

删除无效的归档日志信息，使 检查控制文件和实际物理文件信息同步。

第一步：

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=24 device type=DISK

validation failed for archived log

archived log file name=/u01/frank_archlog/1_9_848141027.dbf RECID=5 STAMP=849276703

validation failed for archived log

archived log file name=/u01/frank_archlog/1_10_848141027.dbf RECID=6 STAMP=849279477

validation failed for archived log

archived log file name=/u01/frank_archlog/1_11_848141027.dbf RECID=7 STAMP=849280581

validation failed for archived log

archived log file name=/u01/frank_archlog/1_12_848141027.dbf RECID=8 STAMP=849280582

validation failed for archived log

archived log file name=/u01/frank_archlog/1_13_848141027.dbf RECID=9 STAMP=849282286

validation failed for archived log

archived log file name=/u01/frank_archlog/1_14_848141027.dbf RECID=10 STAMP=849282457

validation failed for archived log

archived log file name=/u01/frank_archlog/1_15_848141027.dbf RECID=11 STAMP=849282461

validation failed for archived log

archived log file name=/u01/frank_archlog/1_16_848141027.dbf RECID=12 STAMP=849282464

validation failed for archived log

archived log file name=/u01/frank_archlog/1_17_848141027.dbf RECID=13 STAMP=849363432

validation failed for archived log

archived log file name=/u01/frank_archlog/1_18_848141027.dbf RECID=14 STAMP=849366653

validation failed for archived log

archived log file name=/u01/frank_archlog/1_19_848141027.dbf RECID=15 STAMP=849366664

validation succeeded for archived log

archived log file name=/u01/frank_archlog/1_20_848141027.dbf RECID=16 STAMP=849536395

validation succeeded for archived log

archived log file name=/u01/frank_archlog/1_21_848141027.dbf RECID=17 STAMP=849883098

validation succeeded for archived log

archived log file name=/u01/frank_archlog/1_22_848141027.dbf RECID=18 STAMP=849952348

Crosschecked 14 objects

第二步：

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=24 device type=DISK

List of Archived Log Copies for database with db_unique_name FRANK

=====================================================================

Key     Thrd Seq     S Low Time 

------- ---- ------- - ---------

5       1    9       X 23-MAY-14

        Name: /u01/frank_archlog/1_9_848141027.dbf

6       1    10      X 03-JUN-14

        Name: /u01/frank_archlog/1_10_848141027.dbf

7       1    11      X 03-JUN-14

        Name: /u01/frank_archlog/1_11_848141027.dbf

8       1    12      X 03-JUN-14

        Name: /u01/frank_archlog/1_12_848141027.dbf

9       1    13      X 03-JUN-14

        Name: /u01/frank_archlog/1_13_848141027.dbf

10      1    14      X 03-JUN-14

        Name: /u01/frank_archlog/1_14_848141027.dbf

11      1    15      X 03-JUN-14

        Name: /u01/frank_archlog/1_15_848141027.dbf

12      1    16      X 03-JUN-14

        Name: /u01/frank_archlog/1_16_848141027.dbf

13      1    17      X 03-JUN-14

        Name: /u01/frank_archlog/1_17_848141027.dbf

14      1    18      X 04-JUN-14

        Name: /u01/frank_archlog/1_18_848141027.dbf

15      1    19      X 04-JUN-14

        Name: /u01/frank_archlog/1_19_848141027.dbf

Do you really want to delete the above objects (enter YES or NO)?  yes

deleted archived log

archived log file name=/u01/frank_archlog/1_9_848141027.dbf RECID=5 STAMP=849276703

deleted archived log

archived log file name=/u01/frank_archlog/1_10_848141027.dbf RECID=6 STAMP=849279477

deleted archived log

archived log file name=/u01/frank_archlog/1_11_848141027.dbf RECID=7 STAMP=849280581

deleted archived log

archived log file name=/u01/frank_archlog/1_12_848141027.dbf RECID=8 STAMP=849280582

deleted archived log

archived log file name=/u01/frank_archlog/1_13_848141027.dbf RECID=9 STAMP=849282286

deleted archived log

archived log file name=/u01/frank_archlog/1_14_848141027.dbf RECID=10 STAMP=849282457

deleted archived log

archived log file name=/u01/frank_archlog/1_15_848141027.dbf RECID=11 STAMP=849282461

deleted archived log

archived log file name=/u01/frank_archlog/1_16_848141027.dbf RECID=12 STAMP=849282464

deleted archived log

archived log file name=/u01/frank_archlog/1_17_848141027.dbf RECID=13 STAMP=849363432

deleted archived log

archived log file name=/u01/frank_archlog/1_18_848141027.dbf RECID=14 STAMP=849366653

deleted archived log

archived log file name=/u01/frank_archlog/1_19_848141027.dbf RECID=15 STAMP=849366664

Deleted 11 EXPIRED objects

RMAN> backup database plus archivelog format '/u01/backup/wb_%U';

备份成功。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29602308/viewspace-1180401/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29602308/viewspace-1180401/