8 Replies Latest reply: Sep 17, 2012 9:20 PM by 877440 RSS

    dataguard enviornment, rman crosscheck showed validation failed

    877440
      I have setup rman backup on standby site.
      Db version is 11gr2,
      os version is linux redhat

      I did rman crosscheck, here are some results:

      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/system.324.792993247 RECID=621 STAMP=793373396
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/system.314.788073527 RECID=483 STAMP=792994113
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/system.323.786903909 RECID=343 STAMP=788102778
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/system.333.785989831 RECID=206 STAMP=786907706
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/system.347.785963645 RECID=69 STAMP=785990015
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/sysaux.355.792993227 RECID=622 STAMP=793373396
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/sysaux.293.788073519 RECID=484 STAMP=792994113
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/sysaux.322.786903909 RECID=344 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/sysaux.332.785989833 RECID=207 STAMP=786907706
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/sysaux.346.785963645 RECID=70 STAMP=785990015
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs1.351.792993227 RECID=623 STAMP=793373396
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs1.361.788073413 RECID=485 STAMP=792994114
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs1.319.786903909 RECID=345 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs1.258.785989851 RECID=208 STAMP=786907706
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs1.345.785963645 RECID=71 STAMP=785990015
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arindex.341.785186191 RECID=624 STAMP=793373396
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arindex.319.713996145 RECID=346 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs2.291.792993257 RECID=625 STAMP=793373396
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs2.315.788073545 RECID=487 STAMP=792994114
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs2.316.786903931 RECID=347 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs2.348.785989855 RECID=210 STAMP=786907706
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/undotbs2.339.785963789 RECID=73 STAMP=785990015
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arindex.429.785173115 RECID=626 STAMP=793373396
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arindex.274.713990673 RECID=348 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/ggs_data.290.792993255 RECID=627 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/ggs_data.294.788073529 RECID=489 STAMP=792994114
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/ggs_data.329.786903917 RECID=349 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/ggs_data.257.785989847 RECID=212 STAMP=786907706
      validation failed for datafile copy
      datafile copy file name=+DAT/prd/datafile/ggs_data.305.785981949 RECID=75 STAMP=785990015
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arindex.407.785164105 RECID=628 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arindex.273.713990667 RECID=350 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.313.785209331 RECID=629 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.360.770344487 RECID=351 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.408.785164107 RECID=630 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.359.770344385 RECID=352 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.347.785193013 RECID=631 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.358.770343541 RECID=353 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.327.785199047 RECID=632 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.357.770343495 RECID=354 STAMP=788102779
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.309.785213677 RECID=633 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.286.713990693 RECID=355 STAMP=788102780
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.317.785207493 RECID=634 STAMP=793373397
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.288.713990693 RECID=356 STAMP=788102780
      validation failed for datafile copy
      datafile copy file name=/oracle_backup/stage/arsystem.316.785204659 RECID=635 STAMP=793373398
      validation failed for datafile copy

      How can I delete those invalid rman entries? I cannot successfully crosscheck them.

      Thanks,