RMAN> validate tablespace SYSAUX; Starting validate at 20-MAY-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00002 name=N:\ORADATA\DEV\SYSAUX01.DBF channel ORA_DISK_1: validation complete, elapsed time: 00:00:07 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 2 FAILED 0 21222 105017 167376798 File Name: N:\ORADATA\DEV\SYSAUX01.DBF Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 6 28381 Index 3 25047 Other 1 30310 validate found one or more corrupt blocks See trace file n:\oracle_base\diag\rdbms\dev\dev\trace\dev_ora_2720.trc for details Finished validate at 20-MAY-17 RMAN> SHOW ALL; RMAN configuration parameters for database with db_unique_name DEV are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'B:\ORACLE_DATA\ORI-1\BACKUP\TESTER'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'N:\ORACLE_BASE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFDEV.ORA'; # default RMAN> SQL> show parameter recovery; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string N:\ORACLE_BASE\flash_recovery_ area db_recovery_file_dest_size big integer 3912M recovery_parallelism integer 0 SQL>