6 Replies Latest reply: May 1, 2013 8:22 AM by Shaon RSS

    ORA-15124: ASM file name contain invalid alias name after creating standby

    877440
      OS level: redhat 5
      db version: 11gr2

      I just created a standby using rman duplicate from active database and the rman duplicate ran successful.

      Then I modified parameter files on standby to include the current controlfile and try to start the db as mounted, I got following error:

      SQL> startup mount;
      ORA-15124: ASM file name '+DAT/prds/controlfile/current.913.794712357, +FRA/prds/controlfile/current.5616.794712357' contains an invalid alias name
      SQL> exit

      I could not figure out what went wrong here.

      Those are two most current controlfile created during duplicate of db.

      I double checked everythng, everything else seems working.

      What should I look at now?

      Thanks for help as always.
        • 1. Re: ORA-15124: ASM file name contain invalid alias name after creating standby
          Shivananda Rao
          SQL> startup mount;
          ORA-15124: ASM file name '+DAT/prds/controlfile/current.913.794712357, +FRA/prds/controlfile/current.5616.794712357' contains an invalid alias name
          SQL> exit
          The parameter control_files in pfile/spfile should have value as '+DAT/prds/controlfile/current.913.794712357','+FRA/prds/controlfile/current.5616.794712357'

          It looks like you have missed out the adding quotes to each controlfile path and you have specified both the files under one quote.
          *ORA-15124: ASM file name '+DAT/prds/controlfile/current.913.794712357, +FRA/prds/controlfile/current.5616.794712357'*                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
          • 2. Re: ORA-15124: ASM file name contain invalid alias name after creating standby
            mseberg
            Would check the control file

            - go to asmcmd
            - asmcmd> ls +FRA/prds/controlfile

            Make sure your control is the correct one.

            Best Regards

            mseberg
            • 3. Re: ORA-15124: ASM file name contain invalid alias name after creating standby
              CKPT
              Hello,

              It looks issue not with controlfile location as of now, because you have issue even in startup of instance.
              So probabaly it may be issue with file locations.

              If you are using SPFILE, then create prime from SPFILE.
              And then check exact locations from ASMCMD, then specify control file in PFILE as below.

              Control_files='+DAT/prds/controlfile/current.913.79471235','FRA/prds/controlfile/current.5616.794712357'

              Then start in nomount, if you able to start then mount standby instance.

              Ensure file locations are correct.
              • 4. Re: ORA-15124: ASM file name contain invalid alias name after creating standby
                877440
                I found out it is the problem of other issue. still debugging it now. THank you guys.
                • 5. Re: ORA-15124: ASM file name contain invalid alias name after creating standby
                  877440
                  Somehow the problem was the netmask it changed by OS folks did not change in node 2.
                  • 6. Re: ORA-15124: ASM file name contain invalid alias name after creating standby
                    Shaon
                    may be you created a alias for your control file in asm or your control file location is in correct in pfile/spfile with asm location. if u created a alias then remove alias from asm otherwise put the exact location of asm control file in pfile.