I want to corrupt a datablock(!)

[bmycroft]

Hi there,
ok, I want to do a demo of how to recover if you get a block corruption, and need to use dbms_repair & rowid scans to retrieve as much data as poss etc.

To do that I need to corrupt a single block in a datafile on unix, and this is where im stuck....

Anyone out there have any ideas how to do this. I have an idea I can use dd to copy the file out and then edit in Vi, and the use dd to put it back... or something - dunno. Any advice would be usefull...

ta lots, Bob

[Mr.Hanky]

Ask a developer.

Where is gandolf when you need him?

[bmycroft]

Hmm....
.... I posted a Tar as well - I would be amazed if Oracle Support comes back with anything usefull though...

[davey23uk]

need to find a block editor

maybe od could do it

[OracleDoc]

Got a magnet?

[KenEwald]

http://www.freedownloadscenter.com/B...ditor-hex.html

I've seen it done, but it was long ago. How you know which bytes to change is a mystery to me. Guess you could just change away till analyze table validate structure turns up a corrupt block.

Maybe gandolf is off getting his hair bleached.
"Gandalf the Grey" becomes "Gandalf the White"

-Ken

[hrishy]

Hi

Just open a small datafile in notepad and save it.The block should be corrupted

regards
Hrishy

[gandolf989]

Originally posted by Mr.Hanky
Ask a developer.

Where is gandolf when you need him?

Somehow when you think corrupt, my name comes up? I would have thought that you would have been smart enough to know that any editor can corrupt a datafile. In fact I would have assumed that you had already practiced that!

[chunyuh]

Oracle itself provides a tool called bbed.
Normally Oracle support use it for repairing blocks. Of course, you can use to corrupt blocks.

You need to compile bbed urself.
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Thanks

[kris123]

thats cool hun
But i still dont know how to use it (after compiling)