5 Replies Latest reply: Dec 31, 2013 11:26 PM by CKPT RSS

    ORA-17503: ksfdopn:2 Failed to open file

    vk82

      Dear all,

       

      I am getting error as mentioned below when try to recover standby database

       

      ORA-00308: cacnot open archived log '+FRA/ggn/onlinelog/1_2_835574282.dbf'

      ORA-17503: ksfdopn:2 Failed to open file +FRA/ggn/onlinelog/1_2_835574282.dbf

      ORA-15173: entry '1_2_835574282.dbf' does not exist in dicitionary 'onlinelog'

       

       

       

       

      Kindly suggest me what to do in this scenerio

        • 1. Re: ORA-17503: ksfdopn:2 Failed to open file
          mseberg

          Hello;

           

          Are you using LOG_FILE_NAME_CONVERT?

           

          Does your primary online log location match your standby location?

           

          Best Regards

           

          mseberg

          • 2. Re: ORA-17503: ksfdopn:2 Failed to open file
            vk82

            Yes i am using the same as you mentioned.

             

            One thing more

             

            when i execute

            ON PRIMARY :-

            SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

             

            SWITCHOVER_STATUS

            _________________________

             

            UNRESOLVABLE_GAP

             

             

            ON STANDBY SITE

             

            SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

             

             

            SWITCHOVER_STATUS

            _________________________

             

            RECOVERY NEEDED

             

             

             

            kindly let me know what i need to do now as i don't have the backup of primary site

            • 3. Re: ORA-17503: ksfdopn:2 Failed to open file
              mseberg

              Based on your error messages I would check the Standby ASM for a missing directory under the ASM diskgroup.


              Assuming this is really missing this is causing the other things to fail.


              Best Regards


              mseberg

               

               

               

              • 4. Re: ORA-17503: ksfdopn:2 Failed to open file
                vk82

                I checked the file the mentioned file is not present in primary and on standby

                 

                 

                So what i need to do now.

                 

                Kindly suggest

                • 5. Re: ORA-17503: ksfdopn:2 Failed to open file
                  CKPT

                  ORA-00308: cacnot open archived log '+FRA/ggn/onlinelog/1_2_835574282.dbf'

                  ORA-17503: ksfdopn:2 Failed to open file +FRA/ggn/onlinelog/1_2_835574282.dbf

                  ORA-15173: entry '1_2_835574282.dbf' does not exist in dicitionary 'onlinelog'

                   

                  Am not sure which method you have used to create standby database.

                  First create the directory structure and then start the recovery, as M Seberg already stated the subdirectory online is missing from diskgroup. So go ahead and create it, If you have mentioned LOG_FILE_NAME_CONVERT before duplicate then those redo logs may have created.

                  However go with create the subdirectory and then startup recovery, Wait for some time and monitor and  update status still if you have anything.