And for good measure make the shutdown a shutdown abort.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message
news:MjH78.376$Dr7.136294506_at_newssvr21.news.prodigy.com...
> Leigh,
>
> Windows is locking Oracle datafiles so you will not be able to delete them
> while the instance is running.
>
> To test disk failure, just shutdown the db an drename the datafiles. When
> startup again you will have media failure errors all over the place.
>
> Hope that helps.
>
> Trifon Anguelov
> Senior Oracle DBA
>
> http://www.dbaclick.com
>
>
> "Leigh Gold" <intan_5ee_at_yahoo.com> wrote in message
> news:a3n1kh$ni5$1_at_news3.cadvision.com...
> > We have a test machine which we use to test our backup and recovery
> > procedure.
> >
> > I was trying to simulate a disk failure by deleting datafiles from a
> > particular disk drive (D) but kept getting 'sharing violation' error.
> Oracle
> > is running at that time and not other users are on. Any idea why I
> couldn't
> > delete those files?
> >
> > It is Win NT 4.0 with oracle 8.1.6.
> >
> > Thanks,
> >
> > Leigh
> >
> >
> >
>
>
Received on Tue Feb 05 2002 - 02:50:12 CST
