Re: Block Corruption in empty pages in Oracle 11g

> The command is:
>
> ALTER SYSTEM DUMP DATAFILE <file_id> BLOCK MIN <min block>
> BLOCK MAX <max block>;
>
> On a real OS, one can have rather satisfactory results by doing:
>
> dd if=<data file> bs=8k count=<count>|od -x
>
> If the block size is not 8k, the corresponding value needs to be
> substituted into the dd command.

Some people actually take the time to ( on a test system ) introduce damage and test out their ability to find problems and recover from them. Shocking eh?

Of course a hex editor can let you introduce just little tiny bits of corruption ... especially with tools that show one the structure of the blocks. Received on Sat Aug 07 2010 - 04:54:13 CDT