Home » RDBMS Server » Backup & Recovery » cant manually delete a data/log file in windows ?
cant manually delete a data/log file in windows ? [message #400962] Thu, 30 April 2009 13:04 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
is there a way to simulate a redo-log or datafile failure in windows ?

I was trying to delete the file manually but it errors out saying :
'This process cannot access the file because its currently in use by another process'.



Any workarounds to this ?

Re: cant manually delete a data/log file in windows ? [message #400965 is a reply to message #400962] Thu, 30 April 2009 13:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Any workarounds to this ?
shutdown oracle before removing file.
Re: cant manually delete a data/log file in windows ? [message #400969 is a reply to message #400962] Thu, 30 April 2009 13:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
After all these days,
still no Oracle version, no CODE tags.
>>is there a way to simulate a redo-log or datafile failure in windows ?
One of the methods.
http://www.orafaq.com/forum/t/70260/0/

Edit:
Above URL will do talk about that in Unix.
Concept is same. There might be some windows nuances to consider.

[Updated on: Thu, 30 April 2009 13:32]

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #400993 is a reply to message #400962] Thu, 30 April 2009 23:40 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
No.
I think you didnt get my question.

Also its oracle 9i on windows XP / 2000

-
When I try to delete the actual redo file in windows it says :

using command :

prompt> delete c:/oracle/redo01.log
'This process cannot access the file because its currently in use by another process'.


So my question is how this can be done in windows if another process (here oracle) is using it. ??

Re: cant manually delete a data/log file in windows ? [message #400997 is a reply to message #400962] Thu, 30 April 2009 23:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Any workarounds to this ?
shutdown oracle before removing file.
Re: cant manually delete a data/log file in windows ? [message #401009 is a reply to message #400962] Fri, 01 May 2009 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
tridentadm wrote on Thu, 30 April 2009 20:04
is there a way to simulate a redo-log or datafile failure in windows ?

I was trying to delete the file manually but it errors out saying :
'This process cannot access the file because its currently in use by another process'.

Any workarounds to this ?

Remove the disk.

Regards
Michel

Re: cant manually delete a data/log file in windows ? [message #401027 is a reply to message #400993] Fri, 01 May 2009 03:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I think you didnt get my question.
I got your question.
You are not getting what we are saying.
I was addressing this
>>is there a way to simulate a redo-log or datafile failure in windows ?

as other part was already addressed by BlackSwan.
Quote:
shutdown oracle before removing file.
Re: cant manually delete a data/log file in windows ? [message #401204 is a reply to message #401027] Sat, 02 May 2009 09:47 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
Does shift+Delete work?

Just curious. never tried it though!

KV
Previous Topic: diff. between unarchived and inactive.
Next Topic: clone db from datafiles
Goto Forum:
  


Current Time: Fri Dec 06 17:59:53 CST 2024