Wednesday, May 21, 2014

Validate the recovery area

1. Script to validate the 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


No comments: