RE: how to crash a db ?

You can also shutdown the database (anyway you would like). Then delete a couple of datafiles, or the controlfiles, then try to bring the database back up.

Another good way to do it is to null out one of your redo log files.

-Scott

>===== Original Message From ORACLE-L_at_fatcity.com =====
>A shutdown abort is always a good start. I had a collegue (spelling?) in
>Support, who put redo logs on a diskette and then removed the diskette
>from the drive. That worked, too.
>
>And I've had crazy Greenlanders deleting from the dictionary until the
>whole thing finally came down hard.
>
>Good tables to delete from would include those mentioned at the top of
>sql.bsq . Jared's idea with FET$ is good. So is OBJ$, I think :).
>
>Mogens
>
>Jared.Still_at_radisys.com wrote:
>
>>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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> INET: mln_at_miracleas.dk
>
>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: sstefick
  INET: sstefick_at_harper.cc.il.us

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).