OraFAQ Forum: Backup & Recovery » cant manually delete a data/log file in windows ?

Home » RDBMS Server » Backup & Recovery » cant manually delete a data/log file in windows ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cant manually delete a data/log file in windows ? [message #400962]

Thu, 30 April 2009 13:04

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 ?

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #400965 is a reply to message #400962]

Thu, 30 April 2009 13:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Any workarounds to this ?
shutdown oracle before removing file.

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #400969 is a reply to message #400962]

Thu, 30 April 2009 13:22

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

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. ??

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #400997 is a reply to message #400962]

Thu, 30 April 2009 23:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Any workarounds to this ?
shutdown oracle before removing file.

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #401009 is a reply to message #400962]

Fri, 01 May 2009 01:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

tridentadm wrote on Thu, 30 April 2009 20:04

Remove the disk.

Regards
Michel

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #401027 is a reply to message #400993]

Fri, 01 May 2009 03:04

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.

Report message to a moderator

Re: cant manually delete a data/log file in windows ? [message #401204 is a reply to message #401027]

Sat, 02 May 2009 09:47

kudur_kv
Messages: 75
Registered: February 2005

Member

Does shift+Delete work?

Just curious. never tried it though!

KV

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:55:59 CST 2024