ORA-19625 rman备份错误不能备份,正确使用rman crosscheck

最新推荐文章于 2024-01-29 11:10:49 发布
最新推荐文章于 2024-01-29 11:10:49 发布
阅读量904 收藏
点赞数
分类专栏： ORACLE管理
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lenovouser/article/details/17750475
版权

ORA-19625 rman备份错误不能备份

current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/02/2014 02:03:44
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /archive/1_2615_784054258.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
====解决办法
Last login: Thu Jan  2 09:51:24 2014 from 172.18.88.23
[root@testdb ~]# su - oracle
[oracle@testdb ~]$ rman
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jan 2 10:58:02 2014
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
RMAN> connect target /

connected to target database: testdb (DBID=4150210929)
RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=362 devtype=DISK
validation failed for archived log
archive log filename=/archive/1_2615_784054258.dbf recid=2615 stamp=834483641
validation failed for archived log
archive log filename=/archive/1_2616_784054258.dbf recid=2616 stamp=834414955
validation failed for archived log
archive log filename=/archive/1_2617_784054258.dbf recid=2617 stamp=834430988
validation failed for archived log
archive log filename=/archive/1_2618_784054258.dbf recid=2618 stamp=834512448
validation failed for archived log
archive log filename=/archive/1_2619_784054258.dbf recid=2619 stamp=834530438
validation failed for archived log
archive log filename=/archive/1_2620_784054258.dbf recid=2620 stamp=834555658
validation failed for archived log
archive log filename=/archive/1_2621_784054258.dbf recid=2621 stamp=834588004
validation failed for archived log
archive log filename=/archive/1_2622_784054258.dbf recid=2622 stamp=834616816
validation failed for archived log
archive log filename=/archive/1_2623_784054258.dbf recid=2623 stamp=834645655
validation failed for archived log
archive log filename=/archive/1_2624_784054258.dbf recid=2624 stamp=834658191
validation failed for archived log
archive log filename=/archive/1_2625_784054258.dbf recid=2625 stamp=834702995
validation failed for archived log
archive log filename=/archive/1_2626_784054258.dbf recid=2626 stamp=834714014
validation failed for archived log
archive log filename=/archive/1_2627_784054258.dbf recid=2627 stamp=834737243
validation failed for archived log
archive log filename=/archive/1_2628_784054258.dbf recid=2628 stamp=834767562
validation failed for archived log
archive log filename=/archive/1_2629_784054258.dbf recid=2629 stamp=834809097
validation failed for archived log
archive log filename=/archive/1_2630_784054258.dbf recid=2630 stamp=834825211
validation failed for archived log
archive log filename=/archive/1_2631_784054258.dbf recid=2631 stamp=834866600
validation failed for archived log
archive log filename=/archive/1_2632_784054258.dbf recid=2632 stamp=834910089
validation failed for archived log
archive log filename=/archive/1_2633_784054258.dbf recid=2633 stamp=834925879
validation failed for archived log
archive log filename=/archive/1_2634_784054258.dbf recid=2634 stamp=834962410
validation failed for archived log
archive log filename=/archive/1_2635_784054258.dbf recid=2635 stamp=834969894
validation failed for archived log
archive log filename=/archive/1_2636_784054258.dbf recid=2636 stamp=835101718
validation failed for archived log
archive log filename=/archive/1_2637_784054258.dbf recid=2637 stamp=835101857
validation failed for archived log
archive log filename=/archive/1_2638_784054258.dbf recid=2638 stamp=835101898
validation failed for archived log
archive log filename=/archive/1_2639_784054258.dbf recid=2639 stamp=835013837
validation failed for archived log
archive log filename=/archive/1_2640_784054258.dbf recid=2640 stamp=835059628
validation failed for archived log
archive log filename=/archive/1_2641_784054258.dbf recid=2641 stamp=835135220
validation failed for archived log
archive log filename=/archive/1_2642_784054258.dbf recid=2642 stamp=835153971
validation succeeded for archived log
archive log filename=/archive/1_2663_784054258.dbf recid=2663 stamp=835754624
Crosschecked 29 objects








RMAN> delete expired archivelog all;




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




List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
2615    1    2615    X 18-DEC-13 /archive/1_2615_784054258.dbf
2616    1    2616    X 18-DEC-13 /archive/1_2616_784054258.dbf
2617    1    2617    X 17-DEC-13 /archive/1_2617_784054258.dbf
2618    1    2618    X 17-DEC-13 /archive/1_2618_784054258.dbf
2619    1    2619    X 18-DEC-13 /archive/1_2619_784054258.dbf
2620    1    2620    X 18-DEC-13 /archive/1_2620_784054258.dbf
2621    1    2621    X 19-DEC-13 /archive/1_2621_784054258.dbf
2622    1    2622    X 19-DEC-13 /archive/1_2622_784054258.dbf
2623    1    2623    X 19-DEC-13 /archive/1_2623_784054258.dbf
2624    1    2624    X 20-DEC-13 /archive/1_2624_784054258.dbf
2625    1    2625    X 20-DEC-13 /archive/1_2625_784054258.dbf
2626    1    2626    X 20-DEC-13 /archive/1_2626_784054258.dbf
2627    1    2627    X 21-DEC-13 /archive/1_2627_784054258.dbf
2628    1    2628    X 21-DEC-13 /archive/1_2628_784054258.dbf
2629    1    2629    X 21-DEC-13 /archive/1_2629_784054258.dbf
2630    1    2630    X 22-DEC-13 /archive/1_2630_784054258.dbf
2631    1    2631    X 22-DEC-13 /archive/1_2631_784054258.dbf
2632    1    2632    X 22-DEC-13 /archive/1_2632_784054258.dbf
2633    1    2633    X 23-DEC-13 /archive/1_2633_784054258.dbf
2634    1    2634    X 23-DEC-13 /archive/1_2634_784054258.dbf
2635    1    2635    X 23-DEC-13 /archive/1_2635_784054258.dbf
2636    1    2636    X 24-DEC-13 /archive/1_2636_784054258.dbf
2637    1    2637    X 25-DEC-13 /archive/1_2637_784054258.dbf
2638    1    2638    X 25-DEC-13 /archive/1_2638_784054258.dbf
2639    1    2639    X 25-DEC-13 /archive/1_2639_784054258.dbf
2640    1    2640    X 24-DEC-13 /archive/1_2640_784054258.dbf
2641    1    2641    X 25-DEC-13 /archive/1_2641_784054258.dbf
2642    1    2642    X 25-DEC-13 /archive/1_2642_784054258.dbf




Do you really want to delete the above objects (enter YES or NO)? y
deleted archive log
archive log filename=/archive/1_2615_784054258.dbf recid=2615 stamp=834483641
deleted archive log
archive log filename=/archive/1_2616_784054258.dbf recid=2616 stamp=834414955
deleted archive log
archive log filename=/archive/1_2617_784054258.dbf recid=2617 stamp=834430988
deleted archive log
archive log filename=/archive/1_2618_784054258.dbf recid=2618 stamp=834512448
deleted archive log
archive log filename=/archive/1_2619_784054258.dbf recid=2619 stamp=834530438
deleted archive log
archive log filename=/archive/1_2620_784054258.dbf recid=2620 stamp=834555658
deleted archive log
archive log filename=/archive/1_2621_784054258.dbf recid=2621 stamp=834588004
deleted archive log
archive log filename=/archive/1_2622_784054258.dbf recid=2622 stamp=834616816
deleted archive log
archive log filename=/archive/1_2623_784054258.dbf recid=2623 stamp=834645655
deleted archive log
archive log filename=/archive/1_2624_784054258.dbf recid=2624 stamp=834658191
deleted archive log
archive log filename=/archive/1_2625_784054258.dbf recid=2625 stamp=834702995
deleted archive log
archive log filename=/archive/1_2626_784054258.dbf recid=2626 stamp=834714014
deleted archive log
archive log filename=/archive/1_2627_784054258.dbf recid=2627 stamp=834737243
deleted archive log
archive log filename=/archive/1_2628_784054258.dbf recid=2628 stamp=834767562
deleted archive log
archive log filename=/archive/1_2629_784054258.dbf recid=2629 stamp=834809097
deleted archive log
archive log filename=/archive/1_2630_784054258.dbf recid=2630 stamp=834825211
deleted archive log
archive log filename=/archive/1_2631_784054258.dbf recid=2631 stamp=834866600
deleted archive log
archive log filename=/archive/1_2632_784054258.dbf recid=2632 stamp=834910089
deleted archive log
archive log filename=/archive/1_2633_784054258.dbf recid=2633 stamp=834925879
deleted archive log
archive log filename=/archive/1_2634_784054258.dbf recid=2634 stamp=834962410
deleted archive log
archive log filename=/archive/1_2635_784054258.dbf recid=2635 stamp=834969894
deleted archive log
archive log filename=/archive/1_2636_784054258.dbf recid=2636 stamp=835101718
deleted archive log
archive log filename=/archive/1_2637_784054258.dbf recid=2637 stamp=835101857
deleted archive log
archive log filename=/archive/1_2638_784054258.dbf recid=2638 stamp=835101898
deleted archive log
archive log filename=/archive/1_2639_784054258.dbf recid=2639 stamp=835013837
deleted archive log
archive log filename=/archive/1_2640_784054258.dbf recid=2640 stamp=835059628
deleted archive log
archive log filename=/archive/1_2641_784054258.dbf recid=2641 stamp=835135220
deleted archive log
archive log filename=/archive/1_2642_784054258.dbf recid=2642 stamp=835153971
Deleted 28 EXPIRED objects
RMAN> quit    

再备份即ok

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

正确使用rman crosscheck

crosscheck archivelog all 用RMAN的备份中（Veritas等备份软件由于归档日志的异常导致归档日志备份失败）是经常碰到的，解决方法也是非常解单，就是执行2条RMAN的命令：
1. 进入rman
2. connect target /
3. crosscheck archivelog all;           //检查控制文件和实际物理文件的差别。
4. delete expired archivelog all;     //同步控制文件的信息和实际物理文件的信息。
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
这2条命令做什么事情，原理是什么。下面说明一下：
在controlfile中记录着每一个archivelog的相关信息，当我们在OS下把这些物理文件delete掉或异常变动后，在controlfile中仍然记录着这些archivelog的信息，当我们手工清除archive目录下的文件后，这些记录并没有被我们从controlfile中清除掉，也就是oracle并不知道这些文件已经不存在了!这时候我们要做手工的清除。 crosscheck archivelog all；的作用就是检查控制文件和实际物理文件的差别。
delete expired archivelog all;就是同步控制文件的信息和实际物理文件的信息。 如果单独执行crosscheck而没有执行delete那么备份还是失败的，原因是那些控制文件的信息和实际的信息还是不同。 crosscheck backupset crosscheck backupset 是检查备份集和实际的文件 1 备份集有两种状态A(Available,RMAN认为该项存在于备份介质上)X(Expired，备份存在于控制文件或恢复目录中，但是并没有物理存在于备份介质上）
2 crosscheck 的目的是检查RMAN 的目录以及物理文件，如果物理文件不存在于介质上，将标记为Expired。如果物理文件存在，将维持Available。如果原先标记为Expired的备份集再次存在于备份介质上（如恢复了损坏的磁盘驱动器后），crosscheck将把状态重新从Expired标记回Available。
3 crosscheck 输出分两部分。第一部分列出确定存在于备份介质上的所有备份集片，第二部分列出不存在于备份介质上的备份集片，并将其标记为Expired。当设置备份保存策略后，一个备份过期，crosscheck之后标记为丢弃的备份状态依旧为availabel,要删除丢弃备份delete obsolete itpub一实例
我的一个Unix下 oracle数据库在迁移当中一个归档文件丢失了，rman备份归档日志时提示 某个归档日志找不到， 请问如何在不停止oracle数据库情况下 截断归档日志，重新开始新的归档!
crosscheck archivelog all
delete archivelog all;
lenovouser
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle Rman ORA-19625 错误
清风弄影
12-23 3608
ORA-19625 错误处理
关系型数据库Oracle之RMAN备份ORA-19625等错误解决办法
JiekeXu的博客
07-03 669
事情是这样的，上周六中午刚要出去吃饭，便看到微信群里备份工程师的微信消息，说某套环境备份失败，让 DBA 检查下环境，我猜想这不是什么大问题，便不慌不忙...
RMAN备份时出现 ORA-19625 ORA-27037 错误
loveLAxin的博客
01-29 251
RMAN备份时出现 ORA-19625 ORA-27037 错误。
重庆思庄oracle技术分享-ORA-19625异常处理记录
duanweifang的博客
06-13 242
ORA-19625异常处理记录
rman 恢复数据错误案例：RMAN-03002
热门推荐
深蓝@黄炎龙
06-02 1万+
rman 恢复数据错误案例 系统环境： 操作系统： AIX 5300-08 Oracle：   Oracle10.2.0.1.0   错误现象： RMAN> restore datafile 4; Starting restore at 20-MAY-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=139 dev
ORA-01578 数据文件损坏,通过rman备份修复.txt
04-28
ORA-01578 数据文件损坏,通过rman备份修复.txt
数据库报：ORA-01196(ORA-10458/ORA-01110)错误的解决方法
09-09
主要给大家介绍了关于数据库报：ORA-01196(ORA-10458/ORA-01110)错误的解决方法，文中通过示例代码介绍的非常详细，对大家学习或者使用数据库具有一定的参考学习价值，需要的朋友们下面来一起学习学习吧
oracle的RMAN备份基础知识普及
02-01
rmantarget/（或者先rman再connecttarget/）如果要连接的目标数据库是一个远程数据库，那么必须在建立连接时指定一个有效的网络服务名，同时你本地的tnsname.ora文件中也必须已经建立了该网络服务名的正确配置。...
expdp 中ORA-39002、ORA-39070错误详解及解决办法
09-09
主要介绍了expdp 中ORA-39002、ORA-39070错误详解及解决办法的相关资料,需要的朋友可以参考下
ORA-12514及ORA-28547错误解决方案
12-15
可是今天出现了一点小意外,这里总结一下。 (一) 安装检查的问题 在Win7中安装Oracle11g 企业版，在安装的过程中出现一个问题: 代码如下: Environment variable: “PATH” – ... 预期值 : 1023 实际值 : 0 错误列表: –
rac rman备份因归档不可访问出错RMAN-06059 RMAN-03002 ORA-19625
cuiqu7295的博客
09-13 174
--linux环境10g的rac库--rman RAC备份出错如下（部分）Starting Control File and SPFILE Autobackup at 13-SEP-12piece handl...
RMAN执行crosscheck archivelog出现ORA-19633错误
loveLAxin的博客
12-14 610
ORA-19633问题一般是由于数据库从Windows迁移到linux，导致的归档问题。
ORA-19625异常处理记录
cqszpx的博客
07-15 399
数据库：19.3 系统：Windows 11 问题描述：在执行rman备份时，报错ORA-19625，如下： RMAN> backup as compressed backupset database plus archivelog delete all input; 从位于 27-5月 -22 的 backup 开始 当前日志已存档 使用通道 ORA_DISK_1 RMAN-00571: ===========================================================
rman备份出现ORA-19625
dba_monkey的博客
03-10 460
[oracle@sunny stage]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar 18 17:21:22 2007 Copyright (c) 1982, 2005, Oracle.  All rights reserved. connected to target d
oracle 事务日志备份,Oracle备份事务日志出错，提示ORA-19625:识别文件xxxx\ORAAHIVE\ARC6623xxx.001时出错...
weixin_35728532的博客
04-15 196
Oracle备份事务日志出错，提示ORA-19625:识别文件xxxx\ORAAHIVE\ARC6623xxx.001时出错描述：rman下oracle的数据库全备份+归档日志backup database plus archivelog;时报错，事务日志出错，提示ORA-19625:识别文件D:\ORACLE\PRODUCT\10.2.0\ORAARCHIVE\ARC66723_06490763...
Rman备份错误 ORA-19625
清风弄影
04-03 569
使用作业进行数据库全备的时候总是没有成功，在Rman中运行脚步：RUN { CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'F:...
解决ORA-19625
红磊的专栏
11-02 1417
当手工删除了数据库的归档文件后，需要用这个命令进行同步。 （物理上删除了归档日志，但是控制文件并不知道；因此需要交叉检验以同步信息）crosscheck archivelog all;当手工删除了RMAN的备份级时，需要使用的是这个命令：CROSSCHECK BACKUP;他们的区别是同步的内容不同，一个是同步归档文件的状态，一个是同步RMAN备份信息。
【原创】rman备份出现ORA-19625
weixin_34344403的博客
12-27 147
[oracle@sunny stage]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar 18 17:21:22 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target databas...
备份异常引发的ORA-01438，ORA-20242故障解析
cuicuocui2297的博客
02-19 276
早晨检查备份，发现一台ERP的测试机备份异常，检查日志发现如下错误 RMAN-00571: ========================================================...
19c rman ORA-19510 ORA-27059:
最新发布
03-08
而ORA-19510和ORA-27059是RMAN在备份或恢复过程中可能遇到的错误代码。 ORA-19510错误表示RMAN在执行备份或恢复操作时遇到了一个错误。这个错误通常会伴随着具体的错误信息，可以通过查看错误信息来确定具体的问题...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值