Re: How to simulate a disk failure

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 Mon Feb 04 2002 - 20:20:28 CST