2 Replies Latest reply: Jan 7, 2013 1:07 PM by damorgan RSS

    Online Log Failed to Open

    user10364473
      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
          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
            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.