Re: RMAN backup fails - unable to open file
From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 13 Jul 2012 12:32:02 -0700
Message-ID: <CAORjz=MzQJXV_XeYsJ8YizjcLb9p7VR7Bv1WEhujGM=tSubH1g_at_mail.gmail.com>
On Fri, Jun 29, 2012 at 12:52 PM, Joel Slowik <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.
Date: Fri, 13 Jul 2012 12:32:02 -0700
Message-ID: <CAORjz=MzQJXV_XeYsJ8YizjcLb9p7VR7Bv1WEhujGM=tSubH1g_at_mail.gmail.com>
On Fri, Jun 29, 2012 at 12:52 PM, Joel Slowik <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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 13 2012 - 14:32:02 CDT