This discussion is archived
2 Replies Latest reply: Jan 7, 2013 11:07 AM by damorgan RSS

Online Log Failed to Open

983333 Newbie
Currently Being Moderated
Good morning,

I am wirting this primarily because I have spent several days looking for answers and have been unsuccessful.

This environment is a 2 node RAC running RHL 5 and 11gR2.

I continue to receive the following error on both nodes routinely throughout the day.

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+DATA/devaz/onlinelog/group_1.309.797952801'
ORA-17503: ksfdopn:2 Failed to open file +DATA/devaz/onlinelog/group_1.309.797952801
ORA-15260: permission denied on ASM disk group
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+DATA/devaz/onlinelog/group_1.309.797952801'
ORA-17503: ksfdopn:2 Failed to open file +DATA/devaz/onlinelog/group_1.309.797952801
ORA-15260: permission denied on ASM disk group

I have listed the permissions for these files and all of them are listed as
User     Group     Permission     Name
          rw-rw-rw-     group_1.278.739797513
          rw-rw-rw-     group_1.299.775923039
          rw-rw-rw-     group_1.309.797952801
          rw-rw-rw-     group_2.279.739797513
          rw-rw-rw-     group_2.300.775923039
          rw-rw-rw-     group_2.310.797952801
          rw-rw-rw-     group_3.280.739797513
          rw-rw-rw-     group_3.297.775923037
          rw-rw-rw-     group_3.307.797952801
          rw-rw-rw-     group_4.281.739797515
          rw-rw-rw-     group_4.298.775923039
          rw-rw-rw-     group_4.308.797952803

This is what I show for my log groups
GROUP#     THREAD#
---------- ---------- ----------------     
1 1 CURRENT     
2 1 ACTIVE     
3 2 INACTIVE     
4 2 CURRENT     

I apologize in advance is this post is in the wrong area or has been answered previously, any help would be greatly appreciated.

Respectfully,
J
  • 1. Re: Online Log Failed to Open
    Victor Armbrust Oracle ACE
    Currently Being Moderated
    Hi

    Are you using ASM ACLs?
    Did you start ASM instance as ASM (GI) user?
    How did you create your ONLINE REDO LOG files?
    Have you tried to add more REDO LOGS groups via SQLPLUS*? (alter database add logfile thread .. ...)
    Are you able to add for eg: new tablespaces on that diskgroup?

    Please post more information

    Victor
  • 2. Re: Online Log Failed to Open
    damorgan Oracle ACE Director
    Currently Being Moderated
    You've spent "several days" already? Assuming your organization's reason for investing is RAC is that your systems are mission critical I am left wondering when it will become important enough for you to get value from the money your organization spends each your for a support agreement.
    https://support.oracle.com
    is where you should be focusing your attention. You've paid for it ... utilize it.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points