1. Script to validate the recovery area
Validate recovery area;
Validate recovery area;
RMAN> validate recovery area; Starting validate at 22-MAY-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=50 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=25 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=57 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=52 device type=DISK allocated channel: ORA_DISK_5 channel ORA_DISK_5: SID=27 device type=DISK skipping backup sets; RECOVERY FILES, RECOVERY AREA or DB_RECOVERY_FILE_DEST option cannot validate backup set channel ORA_DISK_1: starting validation of archived log channel ORA_DISK_1: specifying archived log(s) for validation input archived log thread=1 sequence=4 RECID=70 STAMP=847791844 input archived log thread=1 sequence=5 RECID=68 STAMP=847791844 input archived log thread=1 sequence=6 RECID=72 STAMP=847791844 input archived log thread=1 sequence=7 RECID=74 STAMP=847791845 input archived log thread=1 sequence=8 RECID=69 STAMP=847791844 channel ORA_DISK_2: starting validation of archived log channel ORA_DISK_2: specifying archived log(s) for validation input archived log thread=1 sequence=9 RECID=71 STAMP=847791844 input archived log thread=1 sequence=12 RECID=67 STAMP=847791844 input archived log thread=1 sequence=13 RECID=75 STAMP=847791848 channel ORA_DISK_3: starting validation of archived log channel ORA_DISK_3: specifying archived log(s) for validation input archived log thread=1 sequence=1 RECID=78 STAMP=847792346 input archived log thread=1 sequence=2 RECID=79 STAMP=847792560 input archived log thread=1 sequence=3 RECID=80 STAMP=847792660 input archived log thread=1 sequence=4 RECID=81 STAMP=847802351 input archived log thread=1 sequence=5 RECID=82 STAMP=847802452 channel ORA_DISK_4: starting validation of archived log channel ORA_DISK_4: specifying archived log(s) for validation input archived log thread=1 sequence=6 RECID=83 STAMP=847836581 input archived log thread=1 sequence=7 RECID=85 STAMP=847857575 input archived log thread=1 sequence=8 RECID=95 STAMP=847862997 input archived log thread=1 sequence=9 RECID=96 STAMP=847862997 input archived log thread=1 sequence=10 RECID=94 STAMP=847862997 channel ORA_DISK_5: starting validation of archived log channel ORA_DISK_5: specifying archived log(s) for validation input archived log thread=1 sequence=1 RECID=97 STAMP=847882837 input archived log thread=1 sequence=2 RECID=98 STAMP=847923142 input archived log thread=1 sequence=3 RECID=99 STAMP=848008899 channel ORA_DISK_1: validation complete, elapsed time: 00:00:06 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 4 OK 0 27 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_4.295.847791843 1 5 OK 0 123 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.296.847791841 1 6 OK 0 15 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.304.847791845 1 7 OK 0 15767 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_7.284.847791839 1 8 OK 0 117 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_8.315.847791843 channel ORA_DISK_1: starting validation of archived log channel ORA_DISK_1: specifying archived log(s) for validation input archived log thread=1 sequence=4 RECID=100 STAMP=848051930 input archived log thread=1 sequence=5 RECID=101 STAMP=848095334 input archived log thread=1 sequence=6 RECID=102 STAMP=848152861 channel ORA_DISK_2: validation complete, elapsed time: 00:00:09 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 9 OK 0 2 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_9.269.847791843 1 12 OK 0 84538 +DATA/cvrman/archivelog/2014_ 1 13 OK 0 28027 +DATA/cvrman/archivelog/2014_ channel ORA_DISK_2: starting validation of archived log channel ORA_DISK_2: specifying archived log(s) for validation input archived log thread=1 sequence=7 RECID=103 STAMP=848181761 channel ORA_DISK_3: validation complete, elapsed time: 00:00:09 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 1 OK 0 46683 +DATA/cvrman/archivelog/2014_ 1 2 OK 0 13 +DATA/cvrman/archivelog/2014_ 1 3 OK 0 10 +DATA/cvrman/archivelog/2014_ 1 4 OK 0 46752 +DATA/cvrman/archivelog/2014_ 1 5 OK 0 4 +DATA/cvrman/archivelog/2014_ channel ORA_DISK_3: starting validation of datafile channel ORA_DISK_3: including datafile copy of datafile 00005 in backup set input file name=+DATA/cvrman/datafile/example.273.847802947 channel ORA_DISK_3: including datafile copy of datafile 00003 in backup set input file name=+DATA/cvrman/datafile/undotbs1.342.847802951 channel ORA_DISK_2: validation complete, elapsed time: 00:00:07 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 7 OK 0 85016 +DATA/cvrman/archivelog/2014_05_21/thread_1_seq_7.278.848181757 channel ORA_DISK_2: starting validation of datafile channel ORA_DISK_2: including datafile copy of datafile 00002 in backup set input file name=+DATA/cvrman/datafile/sysaux.344.847802947 channel ORA_DISK_2: including datafile copy of datafile 00006 in backup set input file name=+DATA/cvrman/datafile/tbs1.341.847802953 channel ORA_DISK_4: validation complete, elapsed time: 00:00:15 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 6 OK 0 83495 +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579 1 7 OK 0 33751 +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575 1 8 OK 0 3266 +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_8.306.847862997 1 9 OK 0 2 +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_9.326.847862997 1 10 OK 0 2935 +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_10.300.847862997 channel ORA_DISK_4: starting validation of datafile channel ORA_DISK_4: including datafile copy of datafile 00001 in backup set input file name=+DATA/cvrman/datafile/system.314.847802947 channel ORA_DISK_4: including datafile copy of datafile 00004 in backup set input file name=+DATA/cvrman/datafile/users.340.847803041 channel ORA_DISK_5: validation complete, elapsed time: 00:00:15 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 1 OK 0 84298 +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_1.302.847882835 1 2 OK 0 84314 +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_2.277.847923139 1 3 OK 0 83370 +DATA/cvrman/archivelog/2014_05_19/thread_1_seq_3.303.848008895 channel ORA_DISK_1: validation complete, elapsed time: 00:00:15 List of Archived Logs ===================== Thrd Seq Status Blocks Failing Blocks Examined Name ---- ------- ------ -------------- --------------- --------------- 1 4 OK 0 83315 +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_4.305.848051929 1 5 OK 0 83791 +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331 1 6 OK 0 85204 +DATA/cvrman/archivelog/2014_05_21/thread_1_seq_6.274.848152857 channel ORA_DISK_3: validation complete, elapsed time: 00:01:13 List of Datafile Copies ======================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 3 OK 0 385 6400 1246502 File Name: +DATA/cvrman/datafile/undotbs1.342.847802951 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 6015 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 5 OK 0 33702 44240 1237936 File Name: +DATA/cvrman/datafile/example.273.847802947 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 6582 Index 0 1149 Other 0 2807 channel ORA_DISK_2: validation complete, elapsed time: 00:01:37 List of Datafile Copies ======================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 2 OK 0 20713 71728 1246299 File Name: +DATA/cvrman/datafile/sysaux.344.847802947 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 14144 Index 0 10480 Other 0 26343 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 6 OK 0 1153 1280 1013566 File Name: +DATA/cvrman/datafile/tbs1.341.847802953 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 127 channel ORA_DISK_4: validation complete, elapsed time: 00:01:36 List of Datafile Copies ======================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 1 OK 0 15253 96072 1246502 File Name: +DATA/cvrman/datafile/system.314.847802947 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 64005 Index 0 13283 Other 0 3459 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 4 OK 0 18 667 993125 File Name: +DATA/cvrman/datafile/users.340.847803041 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 91 Index 0 39 Other 0 492 Finished validate at 22-MAY-14
