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

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 22 Nov 2015 21:53:07 -0600
Message-Id: <78DF2901-1029-4C7B-A89B-DED20BCB991E_at_gmail.com>

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] 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 - 04:53:07 CET