Re: Read a corrupted block
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: tim@xxxxxxxxx
- Date: Thu, 29 Jul 2010 20:12:42 +0100
On Thu, Jul 29, 2010 at 4:39 PM, Tim Gorman <tim@xxxxxxxxx> wrote:
> Joel,
>
> DUDE probably is overkill for one block, but it depends on the value of the
> data. If you think about the cost of a DBA, an IT manager, a business
> manager, and a business analyst all working 4-8 hours trying to diagnose and
> clean up the mess caused by the data lost in a small number of blocks, then
> the $1000-$5000 spent on DUDE becomes a bargain. Kurt Van Meerbeeck
> (http://www.ora600.be) is the creator of DUDE and Dan Fink and I are the US
> contacts for Kurt.
>
> There is the ALTER SYSTEM DUMP DATAFILE command, with the following
> syntax...
>
> SQL> alter system dump datafile '<file-name>' | <file#> block [ <block#> |
> block min <beginning-block#> block max <ending-block#> ];
>
> where...
>
> "<file-name>" is the name of the Oracle datafile
> "<file#>" is the FILE_ID of the Oracle datafile
> "<block#>" is the database block number
> "<beginning-block#>" is the starting block number within the datafile
> "<ending-block#>" is the ending block number within the datafile
>
> The output will be dumped to an Oracle trace file within the USER_DUMP_DEST
> directory. Example ALTER SYSTEM DUMP DATAFILE commands include...
>
Hello Joel,
I have created a short white paper about Oracle Block Editor and ASM -
maybe you
can use it in your case -
http://oracleprof.blogspot.com/2009/06/asm-and-bbed.html.
regards,
Marcin
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
