Oracle-L: Re: Howto drop a corrupt database ?

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Sun, 09 Nov 2003 05:24:25 -0800
Message-ID: <F001.005D6236.20031109052425@fatcity.com>

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:

>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

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

e-mail info.dbalert_at_xs4all.nl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

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 - 07:24:25 CST