Re: events to corrupt a database

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Mon, 12 May 2014 20:55:16 +0200
Message-ID: <CALH8A90qV0Yd30+0pu8D888UYV9AQSZfEH4wWjuaoR0YhsV1JA_at_mail.gmail.com>

I see it a hard task to corrupt a database at will. Especially if it is set up properly :-)

It depends on the kind of corruption you want to achieve. For some small, but very specific block corruptions I'd use BBED. Or I'd take a previous copy of datafiles/redos and replace some blocks from the current files using dd.
But there are also some funny ways to confuse people: in a running DB, rename any datafile and create a symlink with that name pointing to any other datafile.

It all depends on the type of corruption you want to create? what's the purpose at all?

On Mon, May 12, 2014 at 8:16 PM, Josh Collier <Josh.Collier_at_banfield.net>wrote:

> I am looking for different events to set that will corrupt a database,
> or mimic a crash or error condition. For testing and training purposes? Any
> awesome ways to break an oracle database beyond the standard “delete a live
> redo log”, “delete a live datafile”, and “kill pmon”
>
>
>
> Josh C.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 12 2014 - 20:55:16 CEST