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

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sun, 09 Nov 2003 15:34:25 -0800
Message-ID: <F001.005D6255.20031109153425@fatcity.com>

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.

Tanel.

Original Message ----- From: Carel-Jan Engel To: Multiple recipients of list ORACLE-L Sent: Sunday, November 09, 2003 11:59 PM Subject: 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: 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:

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

e-mail info.dbalert_at_xs4all.nl

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee

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 - 17:34:25 CST