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

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

current log archivedusing channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup command at 01/02/2014 02:03:44RMAN-06059: expected archived log not found, lost of archived log compromises recoverabilityORA-19625: error identifying file /archive/1_2615_784054258.dbfORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3====解决办法Last login: Thu Jan  2 09:51:24 2014 from 172.18.88.23[root@testdb ~]# su - oracle[oracle@testdb ~]$ rmanRecovery Manager: Release 10.2.0.4.0 - Production on Thu Jan 2 10:58:02 2014Copyright (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 catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=362 devtype=DISKvalidation failed for archived logarchive log filename=/archive/1_2615_784054258.dbf recid=2615 stamp=834483641validation failed for archived logarchive log filename=/archive/1_2616_784054258.dbf recid=2616 stamp=834414955validation failed for archived logarchive log filename=/archive/1_2617_784054258.dbf recid=2617 stamp=834430988validation failed for archived logarchive log filename=/archive/1_2618_784054258.dbf recid=2618 stamp=834512448validation failed for archived logarchive log filename=/archive/1_2619_784054258.dbf recid=2619 stamp=834530438validation failed for archived logarchive log filename=/archive/1_2620_784054258.dbf recid=2620 stamp=834555658validation failed for archived logarchive log filename=/archive/1_2621_784054258.dbf recid=2621 stamp=834588004validation failed for archived logarchive log filename=/archive/1_2622_784054258.dbf recid=2622 stamp=834616816validation failed for archived logarchive log filename=/archive/1_2623_784054258.dbf recid=2623 stamp=834645655validation failed for archived logarchive log filename=/archive/1_2624_784054258.dbf recid=2624 stamp=834658191validation failed for archived logarchive log filename=/archive/1_2625_784054258.dbf recid=2625 stamp=834702995validation failed for archived logarchive log filename=/archive/1_2626_784054258.dbf recid=2626 stamp=834714014validation failed for archived logarchive log filename=/archive/1_2627_784054258.dbf recid=2627 stamp=834737243validation failed for archived logarchive log filename=/archive/1_2628_784054258.dbf recid=2628 stamp=834767562validation failed for archived logarchive log filename=/archive/1_2629_784054258.dbf recid=2629 stamp=834809097validation failed for archived logarchive log filename=/archive/1_2630_784054258.dbf recid=2630 stamp=834825211validation failed for archived logarchive log filename=/archive/1_2631_784054258.dbf recid=2631 stamp=834866600validation failed for archived logarchive log filename=/archive/1_2632_784054258.dbf recid=2632 stamp=834910089validation failed for archived logarchive log filename=/archive/1_2633_784054258.dbf recid=2633 stamp=834925879validation failed for archived logarchive log filename=/archive/1_2634_784054258.dbf recid=2634 stamp=834962410validation failed for archived logarchive log filename=/archive/1_2635_784054258.dbf recid=2635 stamp=834969894validation failed for archived logarchive log filename=/archive/1_2636_784054258.dbf recid=2636 stamp=835101718validation failed for archived logarchive log filename=/archive/1_2637_784054258.dbf recid=2637 stamp=835101857validation failed for archived logarchive log filename=/archive/1_2638_784054258.dbf recid=2638 stamp=835101898validation failed for archived logarchive log filename=/archive/1_2639_784054258.dbf recid=2639 stamp=835013837validation failed for archived logarchive log filename=/archive/1_2640_784054258.dbf recid=2640 stamp=835059628validation failed for archived logarchive log filename=/archive/1_2641_784054258.dbf recid=2641 stamp=835135220validation failed for archived logarchive log filename=/archive/1_2642_784054258.dbf recid=2642 stamp=835153971validation succeeded for archived logarchive log filename=/archive/1_2663_784054258.dbf recid=2663 stamp=835754624Crosschecked 29 objectsRMAN> delete expired archivelog all;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=362 devtype=DISKList of Archived Log CopiesKey     Thrd Seq     S Low Time  Name------- ---- ------- - --------- ----2615    1    2615    X 18-DEC-13 /archive/1_2615_784054258.dbf2616    1    2616    X 18-DEC-13 /archive/1_2616_784054258.dbf2617    1    2617    X 17-DEC-13 /archive/1_2617_784054258.dbf2618    1    2618    X 17-DEC-13 /archive/1_2618_784054258.dbf2619    1    2619    X 18-DEC-13 /archive/1_2619_784054258.dbf2620    1    2620    X 18-DEC-13 /archive/1_2620_784054258.dbf2621    1    2621    X 19-DEC-13 /archive/1_2621_784054258.dbf2622    1    2622    X 19-DEC-13 /archive/1_2622_784054258.dbf2623    1    2623    X 19-DEC-13 /archive/1_2623_784054258.dbf2624    1    2624    X 20-DEC-13 /archive/1_2624_784054258.dbf2625    1    2625    X 20-DEC-13 /archive/1_2625_784054258.dbf2626    1    2626    X 20-DEC-13 /archive/1_2626_784054258.dbf2627    1    2627    X 21-DEC-13 /archive/1_2627_784054258.dbf2628    1    2628    X 21-DEC-13 /archive/1_2628_784054258.dbf2629    1    2629    X 21-DEC-13 /archive/1_2629_784054258.dbf2630    1    2630    X 22-DEC-13 /archive/1_2630_784054258.dbf2631    1    2631    X 22-DEC-13 /archive/1_2631_784054258.dbf2632    1    2632    X 22-DEC-13 /archive/1_2632_784054258.dbf2633    1    2633    X 23-DEC-13 /archive/1_2633_784054258.dbf2634    1    2634    X 23-DEC-13 /archive/1_2634_784054258.dbf2635    1    2635    X 23-DEC-13 /archive/1_2635_784054258.dbf2636    1    2636    X 24-DEC-13 /archive/1_2636_784054258.dbf2637    1    2637    X 25-DEC-13 /archive/1_2637_784054258.dbf2638    1    2638    X 25-DEC-13 /archive/1_2638_784054258.dbf2639    1    2639    X 25-DEC-13 /archive/1_2639_784054258.dbf2640    1    2640    X 24-DEC-13 /archive/1_2640_784054258.dbf2641    1    2641    X 25-DEC-13 /archive/1_2641_784054258.dbf2642    1    2642    X 25-DEC-13 /archive/1_2642_784054258.dbfDo you really want to delete the above objects (enter YES or NO)? ydeleted archive logarchive log filename=/archive/1_2615_784054258.dbf recid=2615 stamp=834483641deleted archive logarchive log filename=/archive/1_2616_784054258.dbf recid=2616 stamp=834414955deleted archive logarchive log filename=/archive/1_2617_784054258.dbf recid=2617 stamp=834430988deleted archive logarchive log filename=/archive/1_2618_784054258.dbf recid=2618 stamp=834512448deleted archive logarchive log filename=/archive/1_2619_784054258.dbf recid=2619 stamp=834530438deleted archive logarchive log filename=/archive/1_2620_784054258.dbf recid=2620 stamp=834555658deleted archive logarchive log filename=/archive/1_2621_784054258.dbf recid=2621 stamp=834588004deleted archive logarchive log filename=/archive/1_2622_784054258.dbf recid=2622 stamp=834616816deleted archive logarchive log filename=/archive/1_2623_784054258.dbf recid=2623 stamp=834645655deleted archive logarchive log filename=/archive/1_2624_784054258.dbf recid=2624 stamp=834658191deleted archive logarchive log filename=/archive/1_2625_784054258.dbf recid=2625 stamp=834702995deleted archive logarchive log filename=/archive/1_2626_784054258.dbf recid=2626 stamp=834714014deleted archive logarchive log filename=/archive/1_2627_784054258.dbf recid=2627 stamp=834737243deleted archive logarchive log filename=/archive/1_2628_784054258.dbf recid=2628 stamp=834767562deleted archive logarchive log filename=/archive/1_2629_784054258.dbf recid=2629 stamp=834809097deleted archive logarchive log filename=/archive/1_2630_784054258.dbf recid=2630 stamp=834825211deleted archive logarchive log filename=/archive/1_2631_784054258.dbf recid=2631 stamp=834866600deleted archive logarchive log filename=/archive/1_2632_784054258.dbf recid=2632 stamp=834910089deleted archive logarchive log filename=/archive/1_2633_784054258.dbf recid=2633 stamp=834925879deleted archive logarchive log filename=/archive/1_2634_784054258.dbf recid=2634 stamp=834962410deleted archive logarchive log filename=/archive/1_2635_784054258.dbf recid=2635 stamp=834969894deleted archive logarchive log filename=/archive/1_2636_784054258.dbf recid=2636 stamp=835101718deleted archive logarchive log filename=/archive/1_2637_784054258.dbf recid=2637 stamp=835101857deleted archive logarchive log filename=/archive/1_2638_784054258.dbf recid=2638 stamp=835101898deleted archive logarchive log filename=/archive/1_2639_784054258.dbf recid=2639 stamp=835013837deleted archive logarchive log filename=/archive/1_2640_784054258.dbf recid=2640 stamp=835059628deleted archive logarchive log filename=/archive/1_2641_784054258.dbf recid=2641 stamp=835135220deleted archive logarchive log filename=/archive/1_2642_784054258.dbf recid=2642 stamp=835153971Deleted 28 EXPIRED objectsRMAN> 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;