RE: events to corrupt a database
Date: Tue, 13 May 2014 22:33:47 +0530
Message-ID: <BAY180-W82CE9A083B3B25471C2383D6340_at_phx.gbl>
Hi,
Internal corruptions can be done , run catproc of a previous/newer version .2. if running 11G , run utlmail.sql , prvtmail.plb from 10G in 11g db to possibly corrupt xdb./3. recreate controlfile and try to restore datafile from previous bkp in time recovery .....
Thanks & Regards,
Ori
From: Josh.Collier_at_banfield.net
To: martin.a.berger_at_gmail.com
CC: oracle-l_at_freelists.org
Subject: RE: events to corrupt a database
Date: Tue, 13 May 2014 16:00:55 +0000
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-lReceived on Tue May 13 2014 - 19:03:47 CEST