Chinaunix首页 | 论坛 | 博客
  • 博客访问: 149765
  • 博文数量: 20
  • 博客积分: 1550
  • 博客等级: 上尉
  • 技术积分: 320
  • 用 户 组: 普通用户
  • 注册时间: 2005-07-19 17:08
文章分类

全部博文(20)

文章存档

2011年(2)

2010年(2)

2009年(1)

2008年(15)

我的朋友

分类: Oracle

2008-07-17 00:05:23

误删除oracle的日志
备份时提示如下错误
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/16/2008 23:51:15
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /log/oracle_log/1_338_640542816.LOG
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

通过执行如下命令解决
+++++++++++++++++++++++++++++++++++++++
change archivelog all crosscheck;
+++++++++++++++++++++++++++++++++++++++
RMAN> change archivelog all crosscheck;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=117 devtype=DISK
validation failed for archived log
archive log filename=/log/oracle_log/1_338_640542816.LOG recid=336 stamp=657669641
validation failed for archived log
archive log filename=/log/oracle_log/1_339_640542816.LOG recid=337 stamp=657738027
validation failed for archived log
archive log filename=/log/oracle_log/1_340_640542816.LOG recid=338 stamp=657759629
validation failed for archived log
archive log filename=/log/oracle_log/1_341_640542816.LOG recid=339 stamp=657842418
validation failed for archived log
archive log filename=/log/oracle_log/1_342_640542816.LOG recid=340 stamp=657864014
validation failed for archived log
archive log filename=/log/oracle_log/1_343_640542816.LOG recid=341 stamp=657928838
validation failed for archived log
archive log filename=/log/oracle_log/1_344_640542816.LOG recid=342 stamp=657957614
validation failed for archived log
archive log filename=/log/oracle_log/1_345_640542816.LOG recid=343 stamp=658015696
validation failed for archived log
archive log filename=/log/oracle_log/1_346_640542816.LOG recid=344 stamp=658080017
validation failed for archived log
archive log filename=/log/oracle_log/1_347_640542816.LOG recid=345 stamp=658141266
validation failed for archived log
archive log filename=/log/oracle_log/1_348_640542816.LOG recid=346 stamp=658188060
validation failed for archived log
archive log filename=/log/oracle_log/1_349_640542816.LOG recid=347 stamp=658242042
validation failed for archived log
archive log filename=/log/oracle_log/1_350_640542816.LOG recid=348 stamp=658275005
validation failed for archived log
archive log filename=/log/oracle_log/1_351_640542816.LOG recid=349 stamp=658360812
validation failed for archived log
archive log filename=/log/oracle_log/1_352_640542816.LOG recid=350 stamp=658393855
validation failed for archived log
archive log filename=/log/oracle_log/1_353_640542816.LOG recid=351 stamp=658447235
validation failed for archived log
archive log filename=/log/oracle_log/1_354_640542816.LOG recid=352 stamp=658486838
validation failed for archived log
archive log filename=/log/oracle_log/1_355_640542816.LOG recid=353 stamp=658540852
validation failed for archived log
archive log filename=/log/oracle_log/1_356_640542816.LOG recid=354 stamp=658583721
validation failed for archived log
archive log filename=/log/oracle_log/1_357_640542816.LOG recid=355 stamp=658653162
validation failed for archived log
archive log filename=/log/oracle_log/1_358_640542816.LOG recid=356 stamp=658739595
validation failed for archived log
archive log filename=/log/oracle_log/1_359_640542816.LOG recid=357 stamp=658792810
validation succeeded for archived log
archive log filename=/log/oracle_log/1_360_640542816.LOG recid=358 stamp=658912430
validation succeeded for archived log
archive log filename=/log/oracle_log/1_361_640542816.LOG recid=359 stamp=658954866
validation succeeded for archived log
archive log filename=/log/oracle_log/1_362_640542816.LOG recid=360 stamp=658998866
validation succeeded for archived log
archive log filename=/log/oracle_log/1_363_640542816.LOG recid=361 stamp=659052039
validation succeeded for archived log
archive log filename=/log/oracle_log/1_364_640542816.LOG recid=362 stamp=659122134
validation succeeded for archived log
archive log filename=/log/oracle_log/1_365_640542816.LOG recid=363 stamp=659171737
validation succeeded for archived log
archive log filename=/log/oracle_log/1_366_640542816.LOG recid=364 stamp=659224807
validation succeeded for archived log
archive log filename=/log/oracle_log/1_367_640542816.LOG recid=365 stamp=659258174
validation succeeded for archived log
archive log filename=/log/oracle_log/1_368_640542816.LOG recid=366 stamp=659327627
validation succeeded for archived log
archive log filename=/log/oracle_log/1_369_640542816.LOG recid=367 stamp=659379662
validation succeeded for archived log
archive log filename=/log/oracle_log/1_370_640542816.LOG recid=368 stamp=659484008
validation succeeded for archived log
archive log filename=/log/oracle_log/1_371_640542816.LOG recid=369 stamp=659485072
validation succeeded for archived log
archive log filename=/log/oracle_log/1_372_640542816.LOG recid=370 stamp=659548812
validation succeeded for archived log
archive log filename=/log/oracle_log/1_373_640542816.LOG recid=371 stamp=659571505
validation succeeded for archived log
archive log filename=/log/oracle_log/1_374_640542816.LOG recid=373 stamp=659790766
validation succeeded for archived log
archive log filename=/log/oracle_log/1_375_640542816.LOG recid=372 stamp=659790766
validation succeeded for archived log
archive log filename=/log/oracle_log/1_376_640542816.LOG recid=374 stamp=659790772
validation succeeded for archived log
archive log filename=/log/oracle_log/1_377_640542816.LOG recid=375 stamp=659790839
validation succeeded for archived log
archive log filename=/log/oracle_log/1_378_640542816.LOG recid=376 stamp=659790844
validation succeeded for archived log
archive log filename=/log/oracle_log/1_379_640542816.LOG recid=377 stamp=659790883
validation succeeded for archived log
archive log filename=/log/oracle_log/1_380_640542816.LOG recid=378 stamp=659790883
validation succeeded for archived log
archive log filename=/log/oracle_log/1_381_640542816.LOG recid=379 stamp=659795533
validation succeeded for archived log
archive log filename=/log/oracle_log/1_382_640542816.LOG recid=380 stamp=659795533
validation succeeded for archived log
archive log filename=/log/oracle_log/1_383_640542816.LOG recid=381 stamp=659832196
validation succeeded for archived log
archive log filename=/log/oracle_log/1_384_640542816.LOG recid=382 stamp=659860015
validation succeeded for archived log
archive log filename=/log/oracle_log/1_385_640542816.LOG recid=383 stamp=659918638
validation succeeded for archived log
archive log filename=/log/oracle_log/1_386_640542816.LOG recid=384 stamp=660005067
validation succeeded for archived log
archive log filename=/log/oracle_log/1_387_640542816.LOG recid=385 stamp=660081656
validation succeeded for archived log
archive log filename=/log/oracle_log/1_388_640542816.LOG recid=386 stamp=660091502
validation succeeded for archived log
archive log filename=/log/oracle_log/1_389_640542816.LOG recid=387 stamp=660175211
validation succeeded for archived log
archive log filename=/log/oracle_log/1_390_640542816.LOG recid=388 stamp=660214131
validation succeeded for archived log
archive log filename=/log/oracle_log/1_391_640542816.LOG recid=389 stamp=660264372
validation succeeded for archived log
archive log filename=/log/oracle_log/1_392_640542816.LOG recid=390 stamp=660268274
validation succeeded for archived log
archive log filename=/log/oracle_log/1_393_640542816.LOG recid=391 stamp=660268274
Crosschecked 56 objects


RMAN>





阅读(1217) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~