howto drop a corrupt database ?

From: Gorik Vanderreken <gorik_vdr_at_hotmail.com>
Date: 9 Nov 2003 04:19:37 -0800
Message-ID: <8229ce48.0311090419.4405a2d4@posting.google.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 Received on Sun Nov 09 2003 - 06:19:37 CST