Howto drop a corrupt database ?

From: Gorik Vanderreken <debian_at_gorik.net>
Date: Sun, 09 Nov 2003 04:09:30 -0800
Message-ID: <F001.005D6235.20031109040930@fatcity.com>

Hi,

I'm running Oracle 8.0.4 on AIX: for one of the databases, my datafiles got corrupted and I got NO BACKUP. (and NOARCHIVELOG) :(

SVRMGR> alter database open;

ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/data4/test/testdb01.dbf'
ORA-01251: Unknown File Header Version read for file number 6

. no problem. I'm willing to restart, so I want to drop the whole database and start all over again (using the same name).

How can I drop this database ???

When I try to do this from "svrmgrl", I get: "ORA-01109: database not open", duh !

Any ideas how to proceed ?

Kind regards,

Gorik

--

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

Author: Gorik Vanderreken
  INET: debian_at_gorik.net

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). Received on Sun Nov 09 2003 - 06:09:30 CST