RE: RMAN backup fails - unable to open file
Date: Fri, 13 Jul 2012 14:42:10 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B2DCF8FE_at_SPOBMEXC14.adprod.directory>
There's unlocker for windows, there's the built-in windows tool fsmgmt.msc (hat tip to Google for the above)
Chris Taylor
"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)
Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.
From: Joel Slowik [mailto:jslowik_at_cps92.com]
Sent: Friday, July 13, 2012 2:36 PM
To: 'Jared Still'
Cc: Taylor, Chris David; GiantPanda_at_gmx.net; oracle-l_at_freelists.org
Subject: RE: RMAN backup fails - unable to open file
Well the problem is still occurring (it's a small db that is not a high priority) so I still have a few chances to look at what's locking the file.
I am using process explorer and who-locked-me to find the locks; all locks just say oracle.exe at the times prior to, during, and after running an rman backup (or just an rman validate).
Any other utilities come to mind that I could use?
From: Jared Still [mailto:jkstill_at_gmail.com]
Sent: Friday, July 13, 2012 3:32 PM
To: Joel Slowik
Cc: Taylor, Chris David; GiantPanda_at_gmx.net; oracle-l_at_freelists.org
Subject: Re: RMAN backup fails - unable to open file
On Fri, Jun 29, 2012 at 12:52 PM, Joel Slowik <jslowik_at_cps92.com<mailto:jslowik_at_cps92.com>> wrote: The only locks in process explorer were oracle, so we shut down the database and started it back up and that did not solve the issue. We then shut down the instance of the database and restarted the instance and that helped; we now have no issues writing data to the data files.
What could be going on here?
Antivirus comes to mind.
Closing the instance may have been a coincidence.
As instance was restarted before determining what the lock were, there's nothing to do but guess.
Being on windows complicates matters.
You should considering finding a good utility that shows all locks on a file.
Jared
Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 13 2012 - 14:42:10 CDT