Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Howto drop a corrupt database ?

Re: Howto drop a corrupt database ?

From: Tanel Poder <>
Date: Sun, 09 Nov 2003 15:34:25 -0800
Message-ID: <>

I've never tried (actually I'm not even in beta program currently), but it works only on exclusively mounted and not open database, and with restricted session instance mode. During drop, controlfiles are scanned for datafile locations and the datafiles found from there are deleted from OS. So, if the files are deletable in principle (on RW media and with correct permissions) the drop will succeed, how corrupt the data inside a datafile is, doesn't matter at all.

Drop database, will also delete redologs, controlfiles and spfile. Dont remember about passwordfile, here we might have an exception, because sometimes a single passwordfile is used for several instances in a server.


  How will that drop corrupt datafiles? Did you already try that?


  At 13:19 9-11-03 -0800, you wrote:

    Just for the record, in 10g you actually can use drop database command ;)      


      From: Carel-Jan Engel

      To: Multiple recipients of list ORACLE-L

      Sent: Sunday, November 09, 2003 3:24 PM

      Subject: Re: Howto drop a corrupt database ?

      Hi Gorik,

      Do you want to drop the database as a whole, i.e. including your system tablespace etc?

      Just delete all your controlfiles, datafiles and redologfiles, keep the init<SID>.ora and start creating the database all over again. (You do have a create-script, don't you?).

      Of course you can execute the create database command using the REUSE clause for all files, but I hate including this in a script. When someone, it might be even be you, inadvertently re-executes the script all your files might be gone. Not using the REUSE clause will simply cause the script to fail.

      Regards, Carel-Jan

      At 04:09 9-11-03 -0800, you wrote:


        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,


      DBA!ert, Independent Oracle Consultancy

      Kastanjelaan 61C

      2743 BX Waddinxveen

      The Netherlands

      tel. +31 (0) 182 640 428

      fax +31 (0) 182 640 429

      mobile +31 (0) 653 911 950


  DBA!ert, Independent Oracle Consultancy   Kastanjelaan 61C
  2743 BX Waddinxveen
  The Netherlands

  tel.    +31 (0) 182 640 428
  fax     +31 (0) 182 640 429
  mobile  +31 (0) 653 911 950



Please see the official ORACLE-L FAQ:

Author: Tanel Poder

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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 - 17:34:25 CST

Original text of this message