1. Validate archivelog with sequence 12;
RMAN> validate archivelog sequence 12;
Starting validate at 17-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
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=12 RECID=51 STAMP=847713373
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Archived Logs
=====================
Thrd Seq Status Blocks Failing Blocks Examined Name
---- ------- ------ -------------- --------------- ---------------
1 12 OK 0 84538 +DATA/cvrman/archivelog/2014_05_16/thread_1_seq_12.319.847713369
Finished validate at 17-MAY-14
2. Validate backupset 132
RMAN> validate backupset 132;
Starting validate at 17-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=40 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=51 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=39 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=56 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=49 device type=DISK
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +DATA/cvrman/autobackup/2014_05_16/s_847713197.298.847713199
channel ORA_DISK_1: piece handle=+DATA/cvrman/autobackup/2014_05_16/s_847713197.298.847713199 tag=TAG20140516T115317
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished validate at 17-MAY-14
3. Validate database
RMAN> validate database
2> ;
Starting validate at 17-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00005 name=+DATA/cvrman/datafile/example.308.847525493
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
channel ORA_DISK_2: starting validation of datafile
channel ORA_DISK_2: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
channel ORA_DISK_3: starting validation of datafile
channel ORA_DISK_3: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_4: starting validation of datafile
channel ORA_DISK_4: specifying datafile(s) for validation
including current SPFILE in backup set
channel ORA_DISK_5: starting validation of datafile
channel ORA_DISK_5: specifying datafile(s) for validation
including current control file for validation
channel ORA_DISK_4: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
channel ORA_DISK_5: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
Control File OK 0 612
channel ORA_DISK_1: validation complete, elapsed time: 00:00:39
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 385 6400 1217196
File Name: +DATA/cvrman/datafile/undotbs1.258.847354795
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 1112415
File Name: +DATA/cvrman/datafile/example.308.847525493
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6582
Index 0 1149
Other 0 2807
channel ORA_DISK_2: validation complete, elapsed time: 00:00:58
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 20096 70448 1217196
File Name: +DATA/cvrman/datafile/sysaux.257.847354793
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 13891
Index 0 10094
Other 0 26319
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 1153 1280 1013566
File Name: +DATA/cvrman/datafile/tbs1.294.847433665
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
channel ORA_DISK_3: validation complete, elapsed time: 00:01:08
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 15266 96072 1217087
File Name: +DATA/cvrman/datafile/system.256.847354793
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 64002
Index 0 13273
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.259.847354795
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 91
Index 0 39
Other 0 492
Finished validate at 17-MAY-14
No comments:
Post a Comment