RMAN-06059: expected archived log not found,ORA-19625

最新推荐文章于 2020-01-19 10:28:50 发布
最新推荐文章于 2020-01-19 10:28:50 发布
阅读量3k 收藏
点赞数
分类专栏： Oracle RMAN 文章标签： validation archive disk thread input database
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Evils798/article/details/7991339
版权 
RMAN> backup  database format='/oracle_rman/%d_%s.dbf' plus archivelog;

Starting backup at 31-7月 -11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/31/2011 12:41:15
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_2_7375pt80_.arc
ORA-27037: unable to obtain file status

 出现RMAN-06059，ORA-19625此种情况是因为归档日志已被删,但RMAN备份的时候仍然需要,备份无法进行下去,
 执行change archivelog all crosscheck ;检查归档日志命令

RMAN> change archivelog all crosscheck ;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_2_7375pt80_.arc recid=1 stamp=757863003
validation failed for archived log
archive log filename=/arc/1_3_757862072.dbf recid=2 stamp=757866473
validation failed for archived log
archive log filename=/arc/1_4_757862072.dbf recid=3 stamp=757867158
validation failed for archived log
archive log filename=/arc2/1_4_757862072.dbf recid=4 stamp=757867158
validation failed for archived log
archive log filename=/arc/1_5_757862072.dbf recid=5 stamp=757867305
validation failed for archived log
archive log filename=/arc2/1_5_757862072.dbf recid=6 stamp=757867305
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_6_737bg68j_.arc recid=7 stamp=757867846
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_7_737bl10x_.arc recid=8 stamp=757867969
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_8_737bl2qc_.arc recid=9 stamp=757867970
validation failed for archived log
archive log filename=/arc/1_9_757862072.dbf recid=10 stamp=757868173
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_10_737bxx9y_.arc recid=11 stamp=757868349
validation failed for archived log
archive log filename=/arc/1_11_757862072.dbf recid=12 stamp=757868925
validation succeeded for archived log
archive log filename=/arc2/1_11_757862072.dbf recid=13 stamp=757868925
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_12_737cm5vn_.arc recid=14 stamp=757869029
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_13_737crw78_.arc recid=15 stamp=757869212
validation failed for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_14_737d2xd0_.arc recid=16 stamp=757869533
validation succeeded for archived log
archive log filename=/arc/1_15_757862072.dbf recid=17 stamp=757869674
validation succeeded for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_15_737d7bom_.arc recid=18 stamp=757869674
validation succeeded for archived log
archive log filename=/arc/1_16_757862072.dbf recid=19 stamp=757870597
validation succeeded for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_16_737f45pm_.arc recid=20 stamp=757870597
validation succeeded for archived log
archive log filename=/arc/1_17_757862072.dbf recid=21 stamp=757870657
validation succeeded for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_17_737f61b4_.arc recid=22 stamp=757870657
validation succeeded for archived log
archive log filename=/arc/1_18_757862072.dbf recid=23 stamp=757946312
validation succeeded for archived log
archive log filename=/arc/1_19_757862072.dbf recid=24 stamp=757946471
Crosschecked 24 objects

发现有很多过期的归档，运行以下命令进行删除过期的归档

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time   Name
------- ---- ------- - ---------- ----
1       1    2       X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_2_7375pt80_.arc
2       1    3       X 30-7月 -11 /arc/1_3_757862072.dbf
3       1    4       X 30-7月 -11 /arc/1_4_757862072.dbf
4       1    4       X 30-7月 -11 /arc2/1_4_757862072.dbf
5       1    5       X 30-7月 -11 /arc/1_5_757862072.dbf
6       1    5       X 30-7月 -11 /arc2/1_5_757862072.dbf
7       1    6       X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_6_737bg68j_.arc
8       1    7       X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_7_737bl10x_.arc
9       1    8       X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_8_737bl2qc_.arc
10      1    9       X 30-7月 -11 /arc/1_9_757862072.dbf
11      1    10      X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_10_737bxx9y_.arc
12      1    11      X 30-7月 -11 /arc/1_11_757862072.dbf
14      1    12      X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_12_737cm5vn_.arc
15      1    13      X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_13_737crw78_.arc
16      1    14      X 30-7月 -11 /u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_14_737d2xd0_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_2_7375pt80_.arc recid=1 stamp=757863003
deleted archive log
archive log filename=/arc/1_3_757862072.dbf recid=2 stamp=757866473
deleted archive log
archive log filename=/arc/1_4_757862072.dbf recid=3 stamp=757867158
deleted archive log
archive log filename=/arc2/1_4_757862072.dbf recid=4 stamp=757867158
deleted archive log
archive log filename=/arc/1_5_757862072.dbf recid=5 stamp=757867305
deleted archive log
archive log filename=/arc2/1_5_757862072.dbf recid=6 stamp=757867305
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_6_737bg68j_.arc recid=7 stamp=757867846
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_7_737bl10x_.arc recid=8 stamp=757867969
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/SYW/archivelog/2011_07_30/o1_mf_1_8_737bl2qc_.arc recid=9 stamp=757867970
deleted archive log
archive log filename=/arc/1_9_757862072.dbf recid=10 stamp=757868173
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_10_737bxx9y_.arc recid=11 stamp=757868349
deleted archive log
archive log filename=/arc/1_11_757862072.dbf recid=12 stamp=757868925
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_12_737cm5vn_.arc recid=14 stamp=757869029
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_13_737crw78_.arc recid=15 stamp=757869212
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/SYW/archivelog/2011_07_30/o1_mf_1_14_737d2xd0_.arc recid=16 stamp=757869533
Deleted 15 EXPIRED objects

删除了15个过期的归档，现在再执行一次备份

RMAN> backup database format='/oracle_rman/%d_%s.dbf' plus archivelog;


Starting backup at 31-7月 -11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=13 stamp=757868925
input archive log thread=1 sequence=15 recid=18 stamp=757869674
input archive log thread=1 sequence=16 recid=20 stamp=757870597
input archive log thread=1 sequence=17 recid=22 stamp=757870657
input archive log thread=1 sequence=18 recid=23 stamp=757946312
input archive log thread=1 sequence=19 recid=24 stamp=757946471
input archive log thread=1 sequence=20 recid=25 stamp=757946742
input archive log thread=1 sequence=21 recid=26 stamp=757947186
input archive log thread=1 sequence=22 recid=27 stamp=757947643
channel ORA_DISK_1: starting piece 1 at 31-7月 -11
channel ORA_DISK_1: finished piece 1 at 31-7月 -11
piece handle=/u01/app/oracle/flash_recovery_area/SYW/backupset/2011_07_31/o1_mf_annnn_TAG20110731T130043_739rcx0n_.bkp tag=TAG20110731T130043 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:10
Finished backup at 31-7月 -11

Starting backup at 31-7月 -11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/syw/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/syw/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/syw/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/syw/users01.dbf
channel ORA_DISK_1: starting piece 1 at 31-7月 -11
channel ORA_DISK_1: finished piece 1 at 31-7月 -11
piece handle=/oracle_rman/SYW_6.dbf tag=TAG20110731T130053 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 31-7月 -11
channel ORA_DISK_1: finished piece 1 at 31-7月 -11
piece handle=/oracle_rman/SYW_7.dbf tag=TAG20110731T130053 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 31-7月 -11

Starting backup at 31-7月 -11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=23 recid=28 stamp=757947722
channel ORA_DISK_1: starting piece 1 at 31-7月 -11
channel ORA_DISK_1: finished piece 1 at 31-7月 -11
piece handle=/u01/app/oracle/flash_recovery_area/SYW/backupset/2011_07_31/o1_mf_annnn_TAG20110731T130202_739rgcwd_.bkp tag=TAG20110731T130202 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 31-7月 -11

RMAN>

灰帽DBA
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ORA-27104，ORA-01565，ORA-27077，ORA-00093，ORA-01012，ORA-32001，SP2-0714，ORA-12547，sqlplus /nolog 连接不上
01-19
ORA-27104: system-defined limits for shared memory was misconfigured –oracle的sga超过安装oracle配置的最大内存 ipcs -l —— Messages Limits ——– max queues system wide = 32768 max size of message ...
【RMAN】据库备份失败RMAN-06059
cuanjianxiao3267的博客
10-26 381
Oracle数据库备份失败RMAN-06059: expected archived log not found, lost of archived log compromises recoverability情形...
RMAN-06059，ORA-19625
cuiyuchan8365的博客
07-09 195
今天在备份的时候发现了以下的错误信息： 启动 backup 于 09-7月 -13当前日志已存档使用通道 ORA_DISK_1RMAN-00571: ======================================...
RMAN-06059: expected archived log not found
langkeziju的专栏
03-11 669
使用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: =======
Oracle数据库备份失败RMAN-06059:
jhrokin的专栏
11-28 1626
 Oracle数据库备份失败RMAN-06059: expected archived log not found, lost of archived log compromises recoverability情形当运行Oracle数据库备份时，备份失败，显示如下错误： The Database script returned an error. Refer to the Database sc
Oracle-Automatic-Installation:Oracle DBA Rman
05-08
Oracle数据库自动化安装与DBA RMAN实践 Oracle数据库是企业级广泛应用的关系型数据库管理系统，而RMAN（Recovery Manager）是Oracle提供的一款强大的备份和恢复工具。本资料将重点介绍如何在Linux环境下实现Oracle...
数据库ORA-01196故障-归档日志丢失恢复详解
12-16
通过查询`v$archived_log`视图，发现有一部分归档日志没有被应用。这可能是由于停电导致数据库在写入归档日志时中断，或者归档日志传输到备库的过程中出现了问题。 要解决这个问题，需要按照以下步骤进行： 1. **...
数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复.docx
01-22
3. **审查数据库日志**：检查redo log和archived logs，寻找可能导致错误的事务或操作。 4. **恢复策略**：由于常规备份可能也受到了影响，可能需要考虑使用更早的备份或利用RMAN的incremental restore和recover命令...
ora-sys-tools:Oracle 数据库的系统工具
07-07
"ora-sys-tools"显然是一组专为管理Oracle数据库而设计的系统工具。这些工具通常包含了用于诊断、监控、备份、恢复、性能优化等多种功能，帮助DBA（数据库管理员）更高效地维护数据库。 一、Oracle数据库系统工具...
rman备份的问题
敖尔其楞的专栏
01-19 463
库在由rac切换到单库上的时候，rman备份失败 提示信息如下： RMAN-00571: =========================================================== RMAN-03002: failure of backup plus archivelog command at 01/19/2020 02:00:22 RMAN-06059: expect...
[20160202]crosscheck archivelog all.txt
02-02 153
[20160202]crosscheck archivelog all.txt --当使用crosscheck archivelog all检查时注意一个细节，通过例子来说明： 1.环境： SCOTT@book> ...
RMAN备份归档日志的注意要点
BOSCO 蜻蜓点水，一点一滴
10-16 2681
今天在公司的数据库上看到这样的一个RMAN备份脚本： run {  allocate channel c1 type disk maxpiecesize = 2G;  allocate channel c2 type disk maxpiecesize = 2G;  ba
11gR2 RAC RMAN备份问题------手动删除归档日志导致RMAN-06059 ORA-19625
sun-hsh
06-24 1732
Symptoms 客户报告说RMAN备份出错，
Oracle在Rman备份模式下误删归档日志文件解决方法
annicybc的专栏
08-04 4090
问题来源：在使用rman备份策略的数据库中，由于不小心删除了数据库的归档日志文件，导致rman备份的时候报错不能正常进行归档日志的备份工作，但是删除的归档日志已经不在需要使用。但是没有办法跳过没有用的已经删除的归档日志。报错内容：RMAN-00571: ===========================================================RMAN-00569:
RMAN 处理一例 archived log not found or out of sync with catalog
edwzhang的专栏
12-26 2102
备份遇到错误如下： using channel ORA_DISK_1 archived log +DGDGDG/aaaaa/1_669005_745232453.dbf not found or out of sync with catalog trying alternate file for archived log of thread 1 with sequence 669005 R
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream
最新发布
06-13
这个错误提示表示该归档日志文件还在被 standby 数据库或者上游主数据库使用，不能被删除。如果你想要删除这个归档日志文件，你需要先确认这个日志是否被 standby 数据库或者上游主数据库所需要，如果需要的话，你...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值