Home » RDBMS Server » Backup & Recovery » I want to Crash Non - system Datafile for testing purpose
I want to Crash Non - system Datafile for testing purpose [message #161737] Mon, 06 March 2006 23:16 Go to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hi everyone,

I've one test database in my company.
The OS is Windows 2003 Server.
Now i want to purposefully crash the system i.e delete the USERS01.DBF datafile from physical location but it is showing an error.saying that some program is using the file.I've attached one file please take a look at it.But previously when worked on Linux, i could able to remove the file without any hesitations.
i.e SQL>! rm USERS01.DBF

but why I am not able to delete on Windows while database is up and running.

Thanks in advance.

Report message to a moderator

Re: I want to Crash Non - system Datafile for testing purpose [message #161739 is a reply to message #161737] Mon, 06 March 2006 23:21 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


It's a normal behavior. Oracle is using that file and you are trying to delete that file. So, OS will not allow you to delete that file.

Report message to a moderator

Re: I want to Crash Non - system Datafile for testing purpose [message #161917 is a reply to message #161737] Tue, 07 March 2006 22:05 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Try using "echo XX > datafile" to reset the datafile.

On the other hand, you could delete the datafile on Linux box.

Alex zeng | Skype me: Hans9zeng

Report message to a moderator

Re: I want to Crash Non - system Datafile for testing purpose [message #162026 is a reply to message #161917] Wed, 08 March 2006 04:45 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Normal behaviour on windows machines.
Its windows system, while oracle service is running you wont be able to rename/delete any of the datafiles.

--Girish

Report message to a moderator

Previous Topic: RMAN jobs done, but failed!
Next Topic: time-based recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 00:05:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.