Re: How does one manually corrupt a database (database file, redo logs and backups)
From: Maxim Demenko <mdemenko@xxxxxxxxx>
To: sacrophyte@xxxxxxxxx
Date: Sat, 02 Sep 2006 18:12:26 +0200
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.
