Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How does one manually corrupt a database (database file, redo logs and backups)

Re: How does one manually corrupt a database (database file, redo logs and backups)

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 02 Sep 2006 18:12:26 +0200
Message-ID: <44F9AD6A.7020105@gmail.com>


Charles Schultz schrieb:
> Funny topic, eh? I am practicing backup and recovery procedures and
> finding that recovery is quite easy since I never have corrupted
> blocks to worry about. So, how do I practice for a "worse case"
> scenarios? Are there white papers out there that go over this kind of
> stuff? I found several "Best Practices" in metalink (look Mladen, not
> plural), but that is not exactly what I am looking for as they tell
> you how to fix the problem, not make the problem. I have tried
> overwriting the binary files, but being simpled-minded I was using vi.
> I thought about using the unix dd utility - unfortuantely I do not
> have enough experience to be surgical (easy to mess up the first few
> blocks, but what about the middle?). Can I use the same method to
> isolate corruption to various parts of the database (ie, database
> files, redo logs or rman backups)?
>
> I have a gut feeling that someone has already documented this, so if
> this is the case, please point me there.
> Thanks,
>
> PS - I have been practicing on 9iR2. Yet anything above 9iR1 would be
> fine.
>
> --
> Charles Schultz

Mr. Rogers wrote a bit here
http://dizwell.bloghi.com/2005/11/16/corrupting-fun.html however, its the old dizwell site, not sure , how long it remain online...

Best regards

Maxim

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 02 2006 - 11:12:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US