hi,
This may sound funny. I want to know
how to corrupt a block. I want to test the different methods of identifying
block corruption, but I don't have sample data blocks.
Please help me
novice
Hi !
The simple thing is you can edit the datablocks using
BBED editor. It is shipped with Oracle and You need a
password to use that utility. You can browse and edit
the data blocks.
$BBED will give the required details. BUT IT IS
DANGEROUS
--- novicedba <[EMAIL PROTECTED]> wr
It apparently is only on NT, and unless you have the password,
which is known only to Oracle Support Personnel, you can't
use it.
http://www.ixora.com.au/q+a/0101/23224038.htm
Jared
On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote:
> Hi !
>
>
> The simple thing is you can edit the databl
Do a
"dd" on unix and change the contents of any particular
block.
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16
PMTo: Multiple recipients of list ORACLE-LSubject: How
do I corrupt a block
hi,
This may soun
You can write a little perl script to write over the block. Just open the
datafile, sysseek to (block_number)*(block_size), then
syswrite(chr(0),block_size). Strangely though, the naive approach of
overwriting a block entirely with nulls results in a block which is not
detectable with dbms_repai
;
>
> -Original Message-
> From: novicedba [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 2:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How do I corrupt a block
>
>
> hi,
> This may sound funny. I want to know how to corrupt a block. I wan
try the following:
> dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100.
> If that doesn't corrupt it, nothing will.
> Happy hunting!
>
> ===
> Mladen Gogala
>
>
>
>
>
> -Original Message-
> From: novicedba [mailto:[EMAIL PROTECTED]]
> Sen
try the following:
> dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100.
> If that doesn't corrupt it, nothing will.
> Happy hunting!
>
> ===
> Mladen Gogala
>
>
>
>
>
> -Original Message-
> From: novicedba [mailto:[EMAIL PROTECTED]]
> Sen
BBED isn't an option unless you can talk Oracle support into taking part in
your experiment - unlikely. (Or perhaps find an appropriate WaReZ site!
(8-o) Any hex editor will do if you aren't particular about exactly what
you change in the block. If you know Oracle block internals you can get a
Jared, BBED is available on UNIX, you just have to make
it with the make command.
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
The bbed command can allow you to soft corrupt a block
and you can use the "dd" command to hard corrupt the
block. The bbed command doe
10 matches
Mail list logo