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]
Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel.
fax
mobile
e-mail [EMAIL PROTECTED]
