|
Just for the record, in 10g you actually can use
drop database command ;)
Tanel.
----- Original Message -----
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
[EMAIL PROTECTED]
|
