Re: How do I corrupt a block

From: Don Granaman <granaman_at_home.com>
Date: Thu, 31 May 2001 14:49:47 -0700
Message-ID: <F001.00317203.20010531145558@fatcity.com>

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 lot more sophisticated in what you corrupt.

As for simply corrupting a block, I have done it even with good old emacs/vi - as an experiment.
[WARNING: This isn't for the faint of heart! Don't try it with any database you can't afford to lose or large data files!] (For raw devices, you can:

dd if=<raw device> of=<some file>
munge the file with an editor - hex or otherwise
dd if=<some file> of=<raw device> ) The "best way", in my opinion, is to shut all instances down, edit the datafile, then restart the instance(s). YMMV

Happy hacking!
-Don Granaman
[certifiable OraSaurus]

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, May 31, 2001 3:01 PM

>
> 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 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 <novicedba_at_hotmail.com> wrote:
> > > 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
> >
> > =====
> > Have a nice day !!
> > ------------------------------------------------------------
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail - only $35
> > a year! http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 31 2001 - 16:49:47 CDT