Oracle-L: Re: how to crash a db ?

From: <Jared.Still_at_radisys.com>
Date: Fri, 21 Feb 2003 15:54:01 -0800
Message-ID: <F001.005557B7.20030221155401@fatcity.com>

Try this. Turn your server off, pull the drives, remove the outer plates from the individual drive enclosures, and scratch the platters with a nail.

That should do it.

Or, you could just shutdown your database, rename the system tablespace file and try to restart, and subsequently recover.

Using dbed to 'modify' the system tablespace comes to mind, but that's for the real byteheads.

How about 'delete from sys.fet$; commit;' . That should bring in down in a few minutes.

If you want a faster reaction, try 'delete from sys.tab$; commit;'.

That will have a more immediate effect.

Any of these should be sufficient to require recovery.

;)

Jared

<netmadcap_at_netzero.com>
Sent by: root_at_fatcity.com
02/21/2003 03:23 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        how to crash a db ?

Hi Listers ...

sorry, no bad intentions or anything like that :) but i want to learn some recovery options. atleast, the basic point-in-time etc.

so how can i try to crash a db ? r there any other ways to learn this w/out
crashing the db ?

wishing y'all a happy wknd !

thanks,
-sam

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <netmadcap_at_netzero.com
INET: netmadcap_at_netzero.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message