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

  • From: Ramnivas Chaurasia <ramnivaschaurasia@xxxxxxxxx>
  • To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • Date: Tue, 24 Nov 2015 03:43:48 +0530

That was the only error being reported repeatedly.

Thanks!
Ramniwas

On Mon, Nov 23, 2015 at 9:23 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxx> wrote:

Also check permissions; is it possible someone restarted the stack
manually as the wrong user?



*From:* oracle-l-bounce@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *On
Behalf Of *Mladen Gogala
*Sent:* Friday, November 20, 2015 9:29 PM
*To:* oracle-l@xxxxxxxxxxxxx
*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




Other related posts: