Re: howto drop a corrupt database ?

"DJ" <nospamplease_at_goaway.com> wrote in message news:ttqrb.1034$Tc2.6853_at_newsfep4-glfd.server.ntli.net...
>
> "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
>
>

It's kind of sad, with all the advanced features, Oracle failed to provide a "drop database" command until now. Received on Sun Nov 09 2003 - 13:38:22 CST