|
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 -----
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 [EMAIL PROTECTED]
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]
|
