RE: RMAN backup fails - unable to open file
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: 'Joel Slowik' <jslowik@xxxxxxxxx>, 'Jared Still' <jkstill@xxxxxxxxx>
- Date: Fri, 13 Jul 2012 14:42:10 -0500
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@xxxxxxxxx]
Sent: Friday, July 13, 2012 2:36 PM
To: 'Jared Still'
Cc: Taylor, Chris David; GiantPanda@xxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Friday, July 13, 2012 3:32 PM
To: Joel Slowik
Cc: Taylor, Chris David; GiantPanda@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN backup fails - unable to open file
On Fri, Jun 29, 2012 at 12:52 PM, Joel Slowik
<jslowik@xxxxxxxxx<mailto:jslowik@xxxxxxxxx>> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
