RMAN> backup validate check logical database;
Starting backup at 20-FEB-13 17:17:31
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf
input datafile file number=00003 name=+BIG_DATA/db1dup/datafile/undotbs1.259.807722585
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00001 name=+BIG_DATA/db1dup/datafile/system.260.807722583
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
3 OK 0 1 25608 1159578
File Name: +BIG_DATA/db1dup/datafile/undotbs1.259.807722585
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 0
Index 0 0
Other 0 25599
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
4 FAILED 1 1 16001 1159197
File Name: /u01/app/ora112/oradata/DB1DUP/hh_test_copy.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 11 69
Index 0 0
Other 0 15930
validate found one or more corrupt blocks
See trace file /u01/app/ora112/diag/rdbms/db1dup/DB1DUP/trace/DB1DUP_ora_14701.trc for details
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+BIG_DATA/db1dup/datafile/sysaux.261.807722585
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:16
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
1 OK 0 11159 41602 1159578
File Name: +BIG_DATA/db1dup/datafile/system.260.807722583
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 14724
Index 0 4786
Other 0 10931
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
———— —— ————– —————
Control File OK 0 604
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
———— —— ————– —————
SPFILE OK 0 2
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:10
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
2 OK 0 4414 41635 1159423
File Name: +BIG_DATA/db1dup/datafile/sysaux.261.807722585
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 10850
Index 0 9779
Other 0 16557
Finished backup at 20-FEB-13 17:18:07
SQL> select * from V$database_block_corruption;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
———- ———- ———- —————— ———
4 131 1 1129665 CORRUPT
4 142 1 0 CHECKSUM
4 150 1 0 CHECKSUM
4 158 1 0 CHECKSUM
4 166 1 0 CHECKSUM
4 190 1 0 CHECKSUM
4 198 1 0 CHECKSUM
4 203 1 0 CHECKSUM
4 206 1 0 CHECKSUM
4 214 1 0 CHECKSUM
4 230 1 0 CHECKSUM
4 238 1 0 CHECKSUM
RMAN> recover corruption list;
SQL> select * from V$database_block_corruption;
no rows selected