Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: howto drop a corrupt database ?
"Gorik Vanderreken" <gorik_vdr_at_hotmail.com> wrote in message
news:8229ce48.0311090419.4405a2d4_at_posting.google.com...
> 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
make sure it is all shut down (as it is) remove all database file, control files, redo log file archive log files and oratab entries
then you can re-create as you wish. Just simple remove everything to do with that database, there is no 'drop database' command
You could just drop that tablespace as well, save you some effort Received on Sun Nov 09 2003 - 06:32:20 CST