Re: howto drop a corrupt database ?

"Bob Jones" <email_at_me.not> wrote in message news:a97ad6c158d846282b584a69b046bc24_at_news.teranews.com...
>
> "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.
>
>

im kind ain two minds about that. i could imagine a situation where someone does drop database and everything goes and they didnt mean to whereas havign to physically delete files is a clear intent of wanting to get rid of it.

But thrn again, if I do wanna remove a database, i dont like having to faff around deleting every single file associated with it Received on Sun Nov 09 2003 - 14:15:23 CST