rman备份出现ORA-19625
来源：互联网 发布：阿里云 怎么注销 编辑：程序博客网 时间：2024/06/05 14:42
这是一个转过来的帖子，今天做RMAN备份的时候正好碰到这个问题。参考了这个解决的办法问题解决了。
现在就直接转载这个帖子过来，以备不时之需。
[oracle@sunny stage]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar18 17:21:22 2007
Copyright (c) 1982, 2005, Oracle. All rightsreserved.
connected to target database: ORCL (DBID=1141870147)
RMAN> backup archivelog all;
Starting backup at 18-MAR-07
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 03/18/2007 17:52:42
RMAN-06059: expected archived log not found, lost of archived logcompromises recoverability
ORA-19625: error identifying file /u01/1_2_616734317.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
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 03/18/2007 17:52:42
RMAN-06059: expected archived log not found, lost of archived logcompromises recoverability
ORA-19625: error identifying file /u01/1_2_616734317.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
原因在于操作系统下删除了这个归档日志，这个日志还没备份过，rman去备份的时候，找不到这个归档就出错了。可用以下方法解决：
RMAN> change archivelog all crosscheck;
using target database control file instead of recoverycatalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK
validation succeeded for archived log
archive logfilename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_02_12/o1_mf_1_1_2x01h9c2_.arcrecid=1 stam
p=614355305
validation succeeded for archived log
archive logfilename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_02_13/o1_mf_1_2_2x147xxt_.arcrecid=2 stam
p=614390912
validation succeeded for archived log
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK
validation succeeded for archived log
archive logfilename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_02_12/o1_mf_1_1_2x01h9c2_.arcrecid=1 stam
p=614355305
validation succeeded for archived log
archive logfilename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_02_13/o1_mf_1_2_2x147xxt_.arcrecid=2 stam
p=614390912
validation succeeded for archived log
......
......
archive log Crosschecked 27 objects
archive log Crosschecked 27 objects
RMAN> backup archivelog all;
Starting backup at 18-MAR-07
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=1 recid=14stamp=616946466
input archive log thread=1 sequence=3 recid=16stamp=616947068
input archive log thread=1 sequence=4 recid=17stamp=617035270
input archive log thread=1 sequence=5 recid=18stamp=617068230
input archive log thread=1 sequence=6 recid=19stamp=617214283
input archive log thread=1 sequence=7 recid=20stamp=617236569
input archive log thread=1 sequence=8 recid=21stamp=617317844
input archive log thread=1 sequence=9 recid=22stamp=617365403
input archive log thread=1 sequence=10 recid=23stamp=617373909
input archive log thread=1 sequence=11 recid=24stamp=617388719
input archive log thread=1 sequence=12 recid=25stamp=617546548
input archive log thread=1 sequence=13 recid=26stamp=617562955
input archive log thread=1 sequence=14 recid=27stamp=617565160
input archive log thread=1 sequence=15 recid=28stamp=617565330
channel ORA_DISK_1: starting piece 1 at 18-MAR-07
channel ORA_DISK_1: finished piece 1 at 18-MAR-07
piecehandle=/stage/test/ORCL/backupset/2007_03_18/o1_mf_annnn_TAG20070318T175530_2zt34n86_.bkptag=TAG20070318T175530 c
omment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:36
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=1 recid=1 stamp=614355305
input archive log thread=1 sequence=2 recid=2 stamp=614390912
input archive log thread=1 sequence=3 recid=3 stamp=616178167
input archive log thread=1 sequence=4 recid=4 stamp=616179332
input archive log thread=1 sequence=5 recid=5 stamp=616337492
input archive log thread=1 sequence=6 recid=6 stamp=616456995
input archive log thread=1 sequence=7 recid=7 stamp=616458691
input archive log thread=1 sequence=8 recid=10stamp=616734185
input archive log thread=1 sequence=9 recid=12stamp=616734187
input archive log thread=1 sequence=10 recid=11stamp=616734186
channel ORA_DISK_1: starting piece 1 at 18-MAR-07
channel ORA_DISK_1: finished piece 1 at 18-MAR-07
piecehandle=/stage/test/ORCL/backupset/2007_03_18/o1_mf_annnn_TAG20070318T175530_2zt35rxm_.bkptag=TAG20070318T175530 c
omment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:26
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=1 recid=13stamp=616734317
channel ORA_DISK_1: starting piece 1 at 18-MAR-07
channel ORA_DISK_1: finished piece 1 at 18-MAR-07
piecehandle=/stage/test/ORCL/backupset/2007_03_18/o1_mf_annnn_TAG20070318T175530_2zt36m4w_.bkptag=TAG20070318T175530 c
omment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:02
Finished backup at 18-MAR-07
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=1 recid=14stamp=616946466
input archive log thread=1 sequence=3 recid=16stamp=616947068
input archive log thread=1 sequence=4 recid=17stamp=617035270
input archive log thread=1 sequence=5 recid=18stamp=617068230
input archive log thread=1 sequence=6 recid=19stamp=617214283
input archive log thread=1 sequence=7 recid=20stamp=617236569
input archive log thread=1 sequence=8 recid=21stamp=617317844
input archive log thread=1 sequence=9 recid=22stamp=617365403
input archive log thread=1 sequence=10 recid=23stamp=617373909
input archive log thread=1 sequence=11 recid=24stamp=617388719
input archive log thread=1 sequence=12 recid=25stamp=617546548
input archive log thread=1 sequence=13 recid=26stamp=617562955
input archive log thread=1 sequence=14 recid=27stamp=617565160
input archive log thread=1 sequence=15 recid=28stamp=617565330
channel ORA_DISK_1: starting piece 1 at 18-MAR-07
channel ORA_DISK_1: finished piece 1 at 18-MAR-07
piecehandle=/stage/test/ORCL/backupset/2007_03_18/o1_mf_annnn_TAG20070318T175530_2zt34n86_.bkptag=TAG20070318T175530 c
omment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:36
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=1 recid=1 stamp=614355305
input archive log thread=1 sequence=2 recid=2 stamp=614390912
input archive log thread=1 sequence=3 recid=3 stamp=616178167
input archive log thread=1 sequence=4 recid=4 stamp=616179332
input archive log thread=1 sequence=5 recid=5 stamp=616337492
input archive log thread=1 sequence=6 recid=6 stamp=616456995
input archive log thread=1 sequence=7 recid=7 stamp=616458691
input archive log thread=1 sequence=8 recid=10stamp=616734185
input archive log thread=1 sequence=9 recid=12stamp=616734187
input archive log thread=1 sequence=10 recid=11stamp=616734186
channel ORA_DISK_1: starting piece 1 at 18-MAR-07
channel ORA_DISK_1: finished piece 1 at 18-MAR-07
piecehandle=/stage/test/ORCL/backupset/2007_03_18/o1_mf_annnn_TAG20070318T175530_2zt35rxm_.bkptag=TAG20070318T175530 c
omment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:26
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=1 recid=13stamp=616734317
channel ORA_DISK_1: starting piece 1 at 18-MAR-07
channel ORA_DISK_1: finished piece 1 at 18-MAR-07
piecehandle=/stage/test/ORCL/backupset/2007_03_18/o1_mf_annnn_TAG20070318T175530_2zt36m4w_.bkptag=TAG20070318T175530 c
omment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:02
Finished backup at 18-MAR-07
备份成功
下面是我遇到同样的情况：
RMAN> backup archivelog all;
Starting backup at 15-FEB-10
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 02/15/2010 03:05:04
RMAN-06059: expected archived log not found, lost of archived logcompromises recoverability
ORA-19625: error identifying file/u01/app/admin/test/oralog1_41_695269311.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
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 02/15/2010 03:05:04
RMAN-06059: expected archived log not found, lost of archived logcompromises recoverability
ORA-19625: error identifying file/u01/app/admin/test/oralog1_41_695269311.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=418 devtype=DISK
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_41_695269311.dbfrecid=64 stamp=705538863
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_42_695269311.dbfrecid=65 stamp=705576226
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_43_695269311.dbfrecid=66 stamp=705576304
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_44_695269311.dbfrecid=67 stamp=705576371
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_45_695269311.dbfrecid=68 stamp=705576404
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_46_695269311.dbfrecid=69 stamp=705576536
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_47_695269311.dbfrecid=70 stamp=705576575
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_48_695269311.dbfrecid=71 stamp=705576626
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_49_695269311.dbfrecid=72 stamp=705576681
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_50_695269311.dbfrecid=73 stamp=705577007
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_51_695269311.dbfrecid=74 stamp=705577024
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_52_695269311.dbfrecid=75 stamp=705577038
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_53_695269311.dbfrecid=76 stamp=705577114
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_54_695269311.dbfrecid=77 stamp=705628836
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_55_695269311.dbfrecid=78 stamp=706134856
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_56_695269311.dbfrecid=79 stamp=706136663
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_57_695269311.dbfrecid=80 stamp=706226415
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_58_695269311.dbfrecid=81 stamp=706226736
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_59_695269311.dbfrecid=82 stamp=706312835
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_60_695269311.dbfrecid=83 stamp=706348833
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_61_695269311.dbfrecid=84 stamp=706927492
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_62_695269311.dbfrecid=85 stamp=706975243
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_63_695269311.dbfrecid=86 stamp=706979744
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_64_695269311.dbfrecid=87 stamp=706979754
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_65_695269311.dbfrecid=88 stamp=706979763
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_66_695269311.dbfrecid=89 stamp=706979786
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_67_695269311.dbfrecid=90 stamp=707025042
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_68_695269311.dbfrecid=91 stamp=707264272
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_69_695269311.dbfrecid=92 stamp=707311142
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_70_695269311.dbfrecid=93 stamp=707413335
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_71_695269311.dbfrecid=94 stamp=707437236
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_72_695269311.dbfrecid=95 stamp=707457653
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_73_695269311.dbfrecid=96 stamp=707494604
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_74_695269311.dbfrecid=97 stamp=707522544
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_75_695269311.dbfrecid=98 stamp=707552041
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_76_695269311.dbfrecid=99 stamp=707802899
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_77_695269311.dbfrecid=100 stamp=707805037
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_78_695269311.dbfrecid=101 stamp=707864276
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_79_695269311.dbfrecid=102 stamp=712492546
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_80_695269311.dbfrecid=103 stamp=712492563
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_81_695269311.dbfrecid=104 stamp=712492579
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_82_695269311.dbfrecid=105 stamp=709947562
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_83_695269311.dbfrecid=106 stamp=710303633
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_84_695269311.dbfrecid=107 stamp=710648616
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_85_695269311.dbfrecid=108 stamp=710996275
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_86_695269311.dbfrecid=109 stamp=710996402
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_87_695269311.dbfrecid=110 stamp=710996418
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_88_695269311.dbfrecid=111 stamp=710996449
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_89_695269311.dbfrecid=112 stamp=710996456
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_90_695269311.dbfrecid=113 stamp=710996458
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_91_695269311.dbfrecid=114 stamp=710996459
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_92_695269311.dbfrecid=115 stamp=710996461
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_93_695269311.dbfrecid=116 stamp=710996462
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_94_695269311.dbfrecid=117 stamp=710996463
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_95_695269311.dbfrecid=118 stamp=710996464
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_96_695269311.dbfrecid=119 stamp=710996465
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_97_695269311.dbfrecid=120 stamp=710996704
Crosschecked 57 objects
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=418 devtype=DISK
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_41_695269311.dbfrecid=64 stamp=705538863
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_42_695269311.dbfrecid=65 stamp=705576226
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_43_695269311.dbfrecid=66 stamp=705576304
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_44_695269311.dbfrecid=67 stamp=705576371
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_45_695269311.dbfrecid=68 stamp=705576404
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_46_695269311.dbfrecid=69 stamp=705576536
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_47_695269311.dbfrecid=70 stamp=705576575
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_48_695269311.dbfrecid=71 stamp=705576626
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_49_695269311.dbfrecid=72 stamp=705576681
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_50_695269311.dbfrecid=73 stamp=705577007
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_51_695269311.dbfrecid=74 stamp=705577024
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_52_695269311.dbfrecid=75 stamp=705577038
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_53_695269311.dbfrecid=76 stamp=705577114
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_54_695269311.dbfrecid=77 stamp=705628836
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_55_695269311.dbfrecid=78 stamp=706134856
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_56_695269311.dbfrecid=79 stamp=706136663
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_57_695269311.dbfrecid=80 stamp=706226415
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_58_695269311.dbfrecid=81 stamp=706226736
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_59_695269311.dbfrecid=82 stamp=706312835
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_60_695269311.dbfrecid=83 stamp=706348833
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_61_695269311.dbfrecid=84 stamp=706927492
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_62_695269311.dbfrecid=85 stamp=706975243
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_63_695269311.dbfrecid=86 stamp=706979744
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_64_695269311.dbfrecid=87 stamp=706979754
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_65_695269311.dbfrecid=88 stamp=706979763
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_66_695269311.dbfrecid=89 stamp=706979786
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_67_695269311.dbfrecid=90 stamp=707025042
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_68_695269311.dbfrecid=91 stamp=707264272
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_69_695269311.dbfrecid=92 stamp=707311142
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_70_695269311.dbfrecid=93 stamp=707413335
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_71_695269311.dbfrecid=94 stamp=707437236
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_72_695269311.dbfrecid=95 stamp=707457653
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_73_695269311.dbfrecid=96 stamp=707494604
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_74_695269311.dbfrecid=97 stamp=707522544
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_75_695269311.dbfrecid=98 stamp=707552041
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_76_695269311.dbfrecid=99 stamp=707802899
validation failed for archived log
archive log filename=/u01/app/admin/test/oralog1_77_695269311.dbfrecid=100 stamp=707805037
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_78_695269311.dbfrecid=101 stamp=707864276
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_79_695269311.dbfrecid=102 stamp=712492546
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_80_695269311.dbfrecid=103 stamp=712492563
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_81_695269311.dbfrecid=104 stamp=712492579
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_82_695269311.dbfrecid=105 stamp=709947562
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_83_695269311.dbfrecid=106 stamp=710303633
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_84_695269311.dbfrecid=107 stamp=710648616
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_85_695269311.dbfrecid=108 stamp=710996275
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_86_695269311.dbfrecid=109 stamp=710996402
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_87_695269311.dbfrecid=110 stamp=710996418
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_88_695269311.dbfrecid=111 stamp=710996449
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_89_695269311.dbfrecid=112 stamp=710996456
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_90_695269311.dbfrecid=113 stamp=710996458
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_91_695269311.dbfrecid=114 stamp=710996459
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_92_695269311.dbfrecid=115 stamp=710996461
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_93_695269311.dbfrecid=116 stamp=710996462
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_94_695269311.dbfrecid=117 stamp=710996463
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_95_695269311.dbfrecid=118 stamp=710996464
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_96_695269311.dbfrecid=119 stamp=710996465
validation succeeded for archived log
archive log filename=/u01/app/admin/test/oralog1_97_695269311.dbfrecid=120 stamp=710996704
Crosschecked 57 objects
RMAN> backup archivelog all;
Starting backup at 15-FEB-10
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=78 recid=101stamp=707864276
input archive log thread=1 sequence=79 recid=102stamp=712492546
input archive log thread=1 sequence=80 recid=103stamp=712492563
input archive log thread=1 sequence=81 recid=104stamp=712492579
input archive log thread=1 sequence=82 recid=105stamp=709947562
input archive log thread=1 sequence=83 recid=106stamp=710303633
input archive log thread=1 sequence=84 recid=107stamp=710648616
input archive log thread=1 sequence=85 recid=108stamp=710996275
input archive log thread=1 sequence=86 recid=109stamp=710996402
input archive log thread=1 sequence=87 recid=110stamp=710996418
input archive log thread=1 sequence=88 recid=111stamp=710996449
input archive log thread=1 sequence=89 recid=112stamp=710996456
input archive log thread=1 sequence=90 recid=113stamp=710996458
input archive log thread=1 sequence=91 recid=114stamp=710996459
input archive log thread=1 sequence=92 recid=115stamp=710996461
input archive log thread=1 sequence=93 recid=116stamp=710996462
input archive log thread=1 sequence=94 recid=117stamp=710996463
input archive log thread=1 sequence=95 recid=118stamp=710996464
input archive log thread=1 sequence=96 recid=119stamp=710996465
input archive log thread=1 sequence=97 recid=120stamp=710996704
input archive log thread=1 sequence=98 recid=121stamp=710996798
channel ORA_DISK_1: starting piece 1 at 15-FEB-10
channel ORA_DISK_1: finished piece 1 at 15-FEB-10
piecehandle=/u01/app/flash_recovery_area/TEST/backupset/2010_02_15/o1_mf_annnn_TAG20100215T030638_5qjlg031_.bkptag=TAG 20100215T030638 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:27
Finished backup at 15-FEB-10
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=78 recid=101stamp=707864276
input archive log thread=1 sequence=79 recid=102stamp=712492546
input archive log thread=1 sequence=80 recid=103stamp=712492563
input archive log thread=1 sequence=81 recid=104stamp=712492579
input archive log thread=1 sequence=82 recid=105stamp=709947562
input archive log thread=1 sequence=83 recid=106stamp=710303633
input archive log thread=1 sequence=84 recid=107stamp=710648616
input archive log thread=1 sequence=85 recid=108stamp=710996275
input archive log thread=1 sequence=86 recid=109stamp=710996402
input archive log thread=1 sequence=87 recid=110stamp=710996418
input archive log thread=1 sequence=88 recid=111stamp=710996449
input archive log thread=1 sequence=89 recid=112stamp=710996456
input archive log thread=1 sequence=90 recid=113stamp=710996458
input archive log thread=1 sequence=91 recid=114stamp=710996459
input archive log thread=1 sequence=92 recid=115stamp=710996461
input archive log thread=1 sequence=93 recid=116stamp=710996462
input archive log thread=1 sequence=94 recid=117stamp=710996463
input archive log thread=1 sequence=95 recid=118stamp=710996464
input archive log thread=1 sequence=96 recid=119stamp=710996465
input archive log thread=1 sequence=97 recid=120stamp=710996704
input archive log thread=1 sequence=98 recid=121stamp=710996798
channel ORA_DISK_1: starting piece 1 at 15-FEB-10
channel ORA_DISK_1: finished piece 1 at 15-FEB-10
piecehandle=/u01/app/flash_recovery_area/TEST/backupset/2010_02_15/o1_mf_annnn_TAG20100215T030638_5qjlg031_.bkptag=TAG 20100215T030638 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:00:00:27
Finished backup at 15-FEB-10
Starting Control File and SPFILE Autobackup at 15-FEB-10
piecehandle=/u01/app/flash_recovery_area/TEST/autobackup/2010_02_15/o1_mf_s_710996825_5qjlgt6s_.bkpcomment=NONE
Finished Control File and SPFILE Autobackup at 15-FEB-10
piecehandle=/u01/app/flash_recovery_area/TEST/autobackup/2010_02_15/o1_mf_s_710996825_5qjlgt6s_.bkpcomment=NONE
Finished Control File and SPFILE Autobackup at 15-FEB-10
当手工删除了数据库的归档文件后，需要用这个命令进行同步。
（物理上删除了归档日志，但是控制文件并不知道；因此需要交叉检验以同步信息）crosscheck archivelog all;
当手工删除了RMAN的备份级时，需要使用的是这个命令：
CROSSCHECK BACKUP;
他们的区别是同步的内容不同，一个是同步归档文件的状态，一个是同步RMAN备份信息。
转载另外一篇文章如下:
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并不知道这些文件已经不存在了!这时候我们要做手工的清除。
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 archivelogall；的作用就是检查控制文件和实际物理文件的差别。
delete expired 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
是并没有物理存在于备份介质上）
2 crosscheck 的目的是检查RMAN的目录以及物理文件，如果物理文件不存在于介质上，将标记为Expired。如果物理文件
存在，将维持Available。如果原先标记为Expired的备份集再次存在于备份介质上（如恢复了损坏的磁盘驱动器后），
crosscheck将把状态重新从Expired标记回Available。
3 crosscheck 输出分两部分。第一部分列出确定存在于备份介质上的所有备份集片，第二部分列出不存在于备份介质上的
备份集片，并将其标记为Expired。当设置备份保存策略后，一个备份过期，crosscheck之后标记为丢弃的备份状态依旧为
availabel,要删除丢弃备份delete obsolete
- rman备份出现ORA-19625
- rman备份出现ORA-19625
- rman备份出现ORA-19625
- rman 备份出现ORA-00245/RMAN-08132
- RMAN备份失败 RMAN-06059 ORA-19625
- RMAN删除备份出现ORA-19554错误的解决办法
- RMAN备份时出现ORA-27038: created file already exists
- rman备份中出现的ORA-19804和RMAN-06056错误总结及解决方案
- oracle数据库备份出现错误：RMAN-03002 ORA-19809 ORA-19804
- RMAN备份遭遇ORA-235
- ORA-19625 rman备份错误不能备份,正确使用rman crosscheck
- oracle rman备份与ORA-19504&ORA-27040&RMAN-03009
- 11gR2 RAC RMAN备份问题------手动删除归档日志导致RMAN-06059 ORA-19625
- RMAN备份错误ORA-19502的学习
- rman异地和本地备份---ORA-19504
- RAC 环境rman备份 ORA-27054
- RMAN备份时ORA-19809错误
- ORACLE RMAN备份失败之ORA-19599
- ORA-01555错误
- oracle 10G ASM_POWER_LIMIT与Rebalance
- 关于程序包：DBMS_RESOURCE_MANAGE…
- About Opening with the RESETLOGS Option
- Oracle工具——DBVERIFY
- rman备份出现ORA-19625
- TSPITR 基于表空间时间点恢复
- 关于Block Media Recovery
- oracle 重做日志组的三种状态：current,active,inactive
- 索引组织表中的MAPPING TABLE
- 索引组织表与簇---来自互联网
- 关于视图：V$OBJECT_USAGE
- 关于重构索引--index rebuild的OCP 题
- oracle 10g中ASM概念以及管理---转置互联网
