Database Administration (MOSC)

MOSC Banner

Plz guide about corrupt data block in 11G

edited Oct 13, 2011 8:03PM in Database Administration (MOSC) 4 commentsAnswered
  Hello world !
   Based on some document about corrupt data block. But there is problem that I understand.
   When  use bellow script :

        select segment_name , header_file , header_block      
from dba_segments
where segment_name = 'TEST_CORRUPT'
and   owner = 'USR_CORRUPT';

  Result is:

   SEGMENT_NAME                 HEADER_FILE         HEADER_BLOCK
----------------------------        -----------                ------------
TEST_CORRUPT                     7                            130

  After that, user "dd" command in linux to made corrupt datafile at block 131 (TEST_CORRUPT reside on ts_corrupt01.dbf ):

        dd of=ts_corrupt01.dbf bs=8192 conv=notrunc seek=131 << EOF
> Make it Corrupt.
> EOF

  Is the block 130 contains some data (rows data) ? And when make corruption on 131, I can use DBMS_REPAIR. But if use:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center