由于项目中多个版本的数据库都有，有时候常常忘记crosscheck命令在某个版本中的使用，在这里小记一把。
oracle 8i中
|
1 |
RMAN> change archivelog all validate; |
oracle8i中:
|
1 |
RMAN> change archivelog all crosscheck; |
oracle9i以上:
|
1 |
RMAN> crosscheck archivelog all; |
注意8i以下如rman使用nocatalog，这一定要加nocatalog参数。
如果文件丢失补回来后，可以用catalog注册进controlfile，例子：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 |
nuh784:NDSP:/ora/archive_primary/NDSP/ftp_current>rman target / nocatalog Recovery Manager: Release 8.1.7.4.0 - Production RMAN-06005: connected to target database: NDSP (DBID=566340570) RMAN-06009: using target database controlfile instead of recovery catalog RMAN> change archivelog all crosscheck; RMAN-03022: compiling command: change RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55468 recid=74699 stamp=781108222 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55469 recid=74700 stamp=781113625 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55470 recid=74701 stamp=781117287 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55471 recid=74702 stamp=781120823 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55472 recid=74703 stamp=781124553 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55473 recid=74704 stamp=781124624 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55474 recid=74705 stamp=781124676 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55475 recid=74706 stamp=781124741 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55478 recid=74709 stamp=781124908 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55479 recid=74710 stamp=781124948 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55480 recid=74711 stamp=781125653 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55481 recid=74712 stamp=781126893 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55482 recid=74713 stamp=781126987 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55483 recid=74714 stamp=781127102 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55484 recid=74715 stamp=781127207 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55485 recid=74716 stamp=781127359 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55486 recid=74717 stamp=781127510 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55487 recid=74718 stamp=781127658 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55488 recid=74719 stamp=781127832 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55489 recid=74720 stamp=781128015 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55490 recid=74721 stamp=781128234 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55491 recid=74722 stamp=781128406 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55492 recid=74723 stamp=781128529 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55493 recid=74724 stamp=781128704 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55494 recid=74725 stamp=781128858 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55495 recid=74726 stamp=781129034 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55496 recid=74727 stamp=781129156 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55497 recid=74728 stamp=781129366 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55498 recid=74729 stamp=781129547 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55499 recid=74730 stamp=781129714 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55500 recid=74731 stamp=781129889 RMAN> --文件系统中找个这2个文件已经被move到其他路径，copy回这2个文件后，注册进controlfile。 RMAN> catalog archivelog '/ora/archive/NDSParc_55476', '/ora/archive/NDSParc_55477'; RMAN-03022: compiling command: catalog RMAN-03023: executing command: catalog RMAN-08051: cataloged archivelog RMAN-08514: archivelog filename=/ora/archive/NDSParc_55476 recid=74819 stamp=781372005 RMAN-08051: cataloged archivelog RMAN-08514: archivelog filename=/ora/archive/NDSParc_55477 recid=74820 stamp=781372006 RMAN> RMAN> change archivelog all crosscheck; RMAN-03022: compiling command: change RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55468 recid=74699 stamp=781108222 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55469 recid=74700 stamp=781113625 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55470 recid=74701 stamp=781117287 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55471 recid=74702 stamp=781120823 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55472 recid=74703 stamp=781124553 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55473 recid=74704 stamp=781124624 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55474 recid=74705 stamp=781124676 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55475 recid=74706 stamp=781124741 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55476 recid=74819 stamp=781372005 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55477 recid=74820 stamp=781372006 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55478 recid=74709 stamp=781124908 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55479 recid=74710 stamp=781124948 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55480 recid=74711 stamp=781125653 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55481 recid=74712 stamp=781126893 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55482 recid=74713 stamp=781126987 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55483 recid=74714 stamp=781127102 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55484 recid=74715 stamp=781127207 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55485 recid=74716 stamp=781127359 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55486 recid=74717 stamp=781127510 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55487 recid=74718 stamp=781127658 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55488 recid=74719 stamp=781127832 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55489 recid=74720 stamp=781128015 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55490 recid=74721 stamp=781128234 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55491 recid=74722 stamp=781128406 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55492 recid=74723 stamp=781128529 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55493 recid=74724 stamp=781128704 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55494 recid=74725 stamp=781128858 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55495 recid=74726 stamp=781129034 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55496 recid=74727 stamp=781129156 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55497 recid=74728 stamp=781129366 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55498 recid=74729 stamp=781129547 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55499 recid=74730 stamp=781129714 RMAN-06158: validation succeeded for archived log RMAN-08514: archivelog filename=/ora/archive/NDSParc_55500 recid=74731 stamp=781129889 RMAN> |