Re: find physical blocks/disks, mapped from Oracle file# and block#, block corruption

"Gregor Theis" <gregor.theis_at_ib-theis.de> wrote in message news:<1042059198.67109.0_at_demeter.uk.clara.net>...
> run the oracle "dbv" utility on this file? To physically check the
> file you might want to "dd if=the_file of=/dev/null seek=to_the_bad_block
> count=the_full_db_block_in_fs_blocks". To calculate the parameters
> you will have to check the OS block size and READ the dd manual
> (if you are using a UNIX).

Why not use db_block_size instead of fs block size, whatever it means, in your dd command? If you use fs block size, your to_the_bad_block has to be adjusted from block# obtained from most places inside Oracle (such as dba_extents).

Yong Huang Received on Fri Jan 10 2003 - 04:13:44 CST