Recovery of Block Corruption by using RMAN util
Recovery of Block Corruption by using RMAN For this we need to simmulate the issue in TEST DB 1) in our case take emp table which is already existed under scott schema and the default tablespace is users 2) try to access the emp table select count(*) from scott.emp; check segemnt header block number SQL> col SEGMENT_NAME for a20 SQL> select segment_name,header_block,owner from dba_segments where segment_name='EMP' SEGMENT_NAME HEADER_BLOCK OWNER -------------------- ------------ ------------------------------ EMP 146 SCOTT 3) OS level check datafile status using db verify tool. oracle@localhost.localdomain:/home/oracle [TESTDB] >dbv file=/u01/app/oracle/oradata/TESTDB/users01.dbf DBVERIFY: Release 11.2.0.3.0 - Production on Wed Jul 5 23:09:35 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All right...