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 13:19:26 -0800
Message-ID: <>

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


  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



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 - 15:19:26 CST

Original text of this message