RE: events to corrupt a database

From: Howard.latham <howard.latham_at_gmail.com>
Date: Tue, 13 May 2014 20:19:51 +0100
Message-ID: <hd7e1dbaxy2mxmyyqv26slut.1400008680354_at_email.android.com>



I once had a problem where users couldnt connect, turned out an index on aud$ was corrupt. Drop it and all was well, so you could create an error by filling up the ts where aud$ is stored. For example. 

Sent from Samsung tablet

  • Original message -------- From Josh Collier <Josh.Collier_at_banfield.net> Date: 13/05/2014 17:00 (GMT+00:00) To Martin Berger <martin.a.berger_at_gmail.com> Cc oracle-l_at_freelists.org Subject RE: events to corrupt a database

Hi Martin
 
The purpose is to break a database and then give it to someone else so they can practice troubleshooting and recovery steps.  
From: Martin Berger [mailto:martin.a.berger_at_gmail.com] Sent: Monday, May 12, 2014 11:55 AM
To: Josh Collier
Cc: oracle-l_at_freelists.org
Subject: Re: events to corrupt a database  
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 Tue May 13 2014 - 21:19:51 CEST

Original text of this message