Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Howto drop a corrupt database ?
How will that drop corrupt datafiles? Did you already try that?
Carel-Jan
At 13:19 9-11-03 -0800, you wrote:
>Just for the record, in 10g you actually can use drop database command ;)
>
>Tanel.
>
>----- Original Message -----
>From: <mailto:cjpengel.dbalert_at_xs4all.nl>Carel-Jan Engel
>To: <mailto:ORACLE-L_at_fatcity.com>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:
>
>>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
>
>
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: 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 - 15:59:33 CST