RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name DEV List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 790 SYSTEM *** N:\ORADATA\DEV\SYSTEM01.DBF 2 820 SYSAUX *** N:\ORADATA\DEV\SYSAUX01.DBF 3 11950 UNDOTBS1 *** N:\ORADATA\DEV\UNDOTBS01.DBF 4 5 USERS *** N:\ORADATA\DEV\USERS01.DBF 5 100 EXAMPLE *** N:\ORADATA\DEV\EXAMPLE01.DBF 6 12224 MASTER *** M:\ORADATA\DEV\MASTER01.DBF 7 30720 SSS *** N:\ORADATA\DEV\SSS_01.DBF 8 99328 EEE *** N:\ORADATA\DEV\EEE_01.DBF 9 46080 MEE *** N:\ORADATA\DEV\MEE_01.DBF 10 1024 TTT *** N:\ORADATA\DEV\TTT_01.DBF 11 1024 III *** N:\ORADATA\DEV\III_01.DBF 12 21504 AAA *** N:\ORADATA\DEV\AAA_01.DBF 13 1024 AUS *** N:\ORADATA\DEV\AUS_01.DBF 14 118784 WEE *** N:\ORADATA\DEV\WEE_01.DBF 15 1024 NAM *** N:\ORADATA\DEV\NAM_01.DBF 16 26624 APA *** N:\ORADATA\DEV\APA_01.DBF 17 1024 JJJ *** M:\ORADATA\DEV\JJJ_01.DBF List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 32375 TEMP 32767 N:\ORADATA\DEV\TEMP01.DBF 2 3124 MASTERTEMP 33554431 M:\ORADATA\DEV\MASTERTEMP01.DBF 3 4096 SSSTEMP 33554431 N:\ORADATA\DEV\SSSTEMP_01.DBF 4 16384 EEETEMP 33554431 N:\ORADATA\DEV\EEETEMP_01.DBF 5 4096 MEETEMP 33554431 N:\ORADATA\DEV\MEETEMP_01.DBF 6 1024 TTTTEMP 33554431 N:\ORADATA\DEV\TTTTEMP_01.DBF 7 1024 INDTEMP 33554431 N:\ORADATA\DEV\INDTEMP_01.DBF 8 2048 AAATEMP 33554431 N:\ORADATA\DEV\AAATEMP_01.DBF 9 1024 AUSTEMP 33554431 N:\ORADATA\DEV\AUSTEMP_01.DBF 10 11264 WEETEMP 33554431 N:\ORADATA\DEV\WEETEMP_01.DBF 11 1024 NAMTEMP 33554431 N:\ORADATA\DEV\NAMTEMP_01.DBF 12 3072 APATEMP 33554431 N:\ORADATA\DEV\APATEMP_01.DBF 13 1024 JJJTEMP 33554431 M:\ORADATA\DEV\JJJTEMP01.DBF RMAN> list failure; List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- ------------- ------- 8 HIGH OPEN 19-MAY-17 One or more non-system datafiles need media recovery 457 HIGH OPEN 19-MAY-17 Datafile 2: 'N:\ORADATA\DEV\SYSAUX01.DBF' contains one or more corrupt blocks 401 HIGH OPEN 19-MAY-17 Datafile 3: 'N:\ORADATA\DEV\UNDOTBS01.DBF' contains one or more corrupt blocks RMAN> advise failure; List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- ------------- ------- 8 HIGH OPEN 19-MAY-17 One or more non-system datafiles need media recovery 457 HIGH OPEN 19-MAY-17 Datafile 2: 'N:\ORADATA\DEV\SYSAUX01.DBF' contains one or more corrupt blocks 401 HIGH OPEN 19-MAY-17 Datafile 3: 'N:\ORADATA\DEV\UNDOTBS01.DBF' contains one or more corrupt blocks analyzing automatic repair options; this may take some time using channel ORA_DISK_1 analyzing automatic repair options complete Mandatory Manual Actions ======================== 1. No backup of block 4861 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 2. No backup of block 30941 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 3. No backup of block 60977 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 4. No backup of block 64401 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 5. No backup of block 68826 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 6. No backup of block 68858 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 7. No backup of block 68954 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 8. No backup of block 78874 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 9. No backup of block 93476 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 10. No backup of block 96071 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruptio 11. No backup of block 329 in file 3 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 12. No backup of block 1033 in file 3 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 13. No backup of block 1065 in file 3 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 14. No backup of block 1071 in file 3 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 15. No backup of block 1129 in file 3 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption 16. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair Optional Manual Actions ======================= 1. If you restored the wrong version of data file N:\ORADATA\DEV\SYSAUX01.DBF, then replace it with the correct one Automated Repair Options ======================== Option Repair Description ------ ------------------ 1 Recover datafile 2 Strategy: The repair includes complete media recovery with no data loss Repair script: n:\oracle_base\diag\rdbms\dev\dev\hm\reco_4029246596.hm RMAN> repair failure; Strategy: The repair includes complete media recovery with no data loss Repair script: n:\oracle_base\diag\rdbms\dev\dev\hm\reco_4029246596.hm contents of repair script: # recover datafile recover datafile 2; Do you really want to execute the above repair (enter YES or NO)? YES executing repair script Starting recover at 19-MAY-17 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:00 Finished recover at 19-MAY-17 repair failure complete RMAN>