This discussion is archived
6 Replies Latest reply: May 1, 2013 6:22 AM by Shaon RSS

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

user301176 Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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
    user301176 Explorer
    Currently Being Moderated
    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
    user301176 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

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