Re: Block Corruption in empty pages in Oracle 11g
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 7 Aug 2010 04:15:08 +0000 (UTC)
Message-ID: <i3imkc$des$1_at_news.eternal-september.org>
On Fri, 06 Aug 2010 16:51:18 -0700, John Hurley wrote:
Date: Sat, 7 Aug 2010 04:15:08 +0000 (UTC)
Message-ID: <i3imkc$des$1_at_news.eternal-september.org>
On Fri, 06 Aug 2010 16:51:18 -0700, John Hurley wrote:
> zigzag:
>
> # Soory, don't undestand why do you mean by dump the block.
>
> Try searching with something like google ...
>
> Use words like these "oracle how to dump a data block" ...
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.
-- http://mgogala.byethost5.comReceived on Fri Aug 06 2010 - 23:15:08 CDT