Re: "ORA-00270: error creating archive log" on Standby Database

From: Ramnivas Chaurasia <ramnivaschaurasia_at_gmail.com>
Date: Tue, 24 Nov 2015 03:43:48 +0530
Message-ID: <CAGwus2VkMfqFqqVGSX8DGWYFUi+U7=DbBtvFRBXmbNX6K5ewsQ_at_mail.gmail.com>



That was the only error being reported repeatedly.

Thanks!
Ramniwas

On Mon, Nov 23, 2015 at 9:23 AM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Are there any other messages in the alert log?
>
> Sent from my iPhone
>
> On Nov 22, 2015, at 3:21 AM, Ramnivas Chaurasia <
> ramnivaschaurasia_at_gmail.com> wrote:
>
>
> I am able to create directory in archive log location manually without any
> issue.
>
> Regards,
> Ramniwas
>
> On Sun, Nov 22, 2015 at 12:26 AM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> What happens when you try to manually create a file on the location for
>> the archive logs?
>>
>> Sent from my iPad
>>
>> On Nov 21, 2015, at 12:52 PM, Ramnivas Chaurasia <
>> ramnivaschaurasia_at_gmail.com> wrote:
>>
>> Hi,
>> We are not using DG broker in our environment.
>>
>> Regards
>> Ramniwas
>>
>> On Sat, Nov 21, 2015 at 7:12 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
>> wrote:
>>
>>> Are you using data guard broker? The parameters for broker can be
>>> different than what you define in the spfile.
>>>
>>> Sent from my iPad
>>>
>>> On Nov 21, 2015, at 7:28 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
>>>
>>> Also check permissions; is it possible someone restarted the stack
>>> manually as the wrong user?
>>>
>>>
>>>
>>> *From:* oracle-l-bounce_at_freelists.org [
>>> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
>>> Behalf Of *Mladen Gogala
>>> *Sent:* Friday, November 20, 2015 9:29 PM
>>> *To:* oracle-l_at_freelists.org
>>> *Subject:* Re: "ORA-00270: error creating archive log" on Standby
>>> Database
>>>
>>>
>>>
>>> On 11/19/2015 02:37 PM, Ramnivas Chaurasia wrote:
>>>
>>> Hi,
>>>
>>>
>>>
>>> We have been receiving the below error on our standby database
>>> continuously since last 4-5 days.
>>>
>>>
>>>
>>>
>>> *ORA-00270: error creating archive log ORA-17611: ksfd: file '31' cannot
>>> be accessed, global open closed*
>>>
>>>
>>>
>>> There is no FRA space issue on Primary as well as Standby Database. No
>>> abnormal shutdown on Standby Instance. Redo logs are still being applied on
>>> Standby.
>>>
>>>
>>>
>>> Please let me know if anyone has faced similar issue or have come across
>>> solution. We have raised SR with Oracle on same, but have not progressed
>>> much.
>>>
>>>
>>>
>>> DB Version: EE 11.2.0.3.0 - 64bit Production on AIX
>>>
>>>
>>>
>>> Thanks!
>>>
>>> Ramniwas
>>>
>>>
>>>
>>> ORA-00270: error creating archive log %s
>>>
>>> *Cause: An error was encountered when either creating or opening
>>>
>>> the destination file for archiving.
>>>
>>> *Action: Check that the archive destination is valid and that there
>>>
>>> is sufficient space on the destination device.
>>>
>>>
>>> Regards
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Mladen Gogala
>>>
>>> Oracle DBA
>>>
>>> http://mgogala.freehostia.com
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 23 2015 - 23:13:48 CET

Original text of this message