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';
备份成功。
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值