This discussion is archived
1 2 3 4 Previous Next 51 Replies Latest reply: Mar 3, 2012 1:15 PM by user301176 Go to original post RSS
  • 15. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    show
  • 16. Re: Duplicate from active database failed
    Shivananda Rao Guru
    Currently Being Moderated
    So the files are OMF

    Refer this MOS document *RMAN restore to ASM - ORA-17503: ksfdopn:2 Failed to open file [ID 336200.1]*

    Would be posting more once I get access to my system !!!
  • 17. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    thanks. this error comes when the standby instance starts and it tried to use primary redo log path which not exists in standby asm.

    why this happen? the duplicate session is still going, it will take hours before it disconnect with ora-3113 error.

    please help here.
  • 18. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    when I created standby database, the redo logs were created. why it tried to start the instance with primary redo log informaiton?

    I did not get it.
  • 19. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    Actually I think this redo log file name path issue is not the issue causing this duplicate from active database hang.

    It might be something else.

    This round I added per msberg instruction sqlnet timeout parameters. so let's see if they will time out or they will go through it.
  • 20. Re: Duplicate from active database failed
    CKPT Guru
    Currently Being Moderated
    ORA-00312: online log 14 thread 2: '+HY_FRA/hyqa/onlinelog/group_14.505.776449007'
    ORA-17503: ksfdopn:2 Failed to open file +HY_FRA/hyqa/onlinelog/group_14.505.776449007
    ORA-15012: ASM file '+HY_FRA/hyqa/onlinelog/group_14.505.776449007' does not exist
    These errors may occurred when starting MRP after successful restore.
    Then it's normal behaviour.

    These errors I don't believe they are from RMAN log file.
    These errors you will get for all the online redo log files what ever exist in primary.

    Now tell what is the status from RMAN log file?
    If restored successfully, create standby redo log files if it's real time apply & start MRP.
    Or post errors from RMAN log & alert log file again.
  • 21. Re: Duplicate from active database failed
    CKPT Guru
    Currently Being Moderated
    Angelina wrote:
    when I created standby database, the redo logs were created. why it tried to start the instance with primary redo log informaiton?
    It's A good question, I will explain it.
    Lets suppose datafiles, when you perform duplicate those files will be backed up & restore on standby, so they are exist physically , so as per primary datafiles are in a diskgroup and in standby its in another diskgroup , so by using db_file_name_convert it will renames because those exist as physically. I hope you are clear with this point.

    Now coming to your question related to online redo logs, RMAN does not contain backup of online redo log files. So as per script it will try to locate those files, but RMAN won't have backup & won't create also in terms of standby. Moreover if you restore from database when you open data ass with resetlogs, those files will be created even if it's not exist.
    Then it will give these errors like, clearing online redo logs & so on.
    These errors you can ignore.
    I did not get it.
    Now? :)
  • 22. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    I don't even know where is rman log. It just stays at this place:


    input datafile file number=00013 name=+HY_DAT/hyqa/datafile/arsystem1.289.77 6745673
    channel prmy2: starting datafile copy
    input datafile file number=00014 name=+HY_DAT/hyqa/datafile/arsystem1.290.77 6745675
    channel prmy3: starting datafile copy
    input datafile file number=00020 name=+HY_DAT/hyqa/datafile/arsystem1.296.77 6745679
    channel prmy4: starting datafile copy
    input datafile file number=00010 name=+HY_DAT/hyqa/datafile/arsystem1.286.77 6745671
  • 23. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    my question here is : has anybody ever successfully created a standby database by using rman duplicate from active database?


    google shows a lot failure by running that command. So I want to know if it really will work.
  • 24. Re: Duplicate from active database failed
    CKPT Guru
    Currently Being Moderated
    I don't even know where is rman log. It just stays at this place:
    Are you running duplicate using any shell script with background or not?
    Is your session hangs so it was showing only that status?

    Now refer the log file that all the datafiles are restored into standby , those errors will be occurred only after successful restore of database.
    Now check the status of database from other session, check where all the datafiles are pointing to standby location or some of them still points to primary?

    Always these RMAN or duplicate scripts should execute in background or nohup.
    Post your findings now.

    I posted two times above before this post, read carefully.
    google shows a lot failure by running that command. So I want to know if it really will work.
    YES it will work. Don't worry. Of course there may issues but it will work.
  • 25. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    I ran it through unix command line, so the session opens there, and it stays there, not move.
  • 26. Re: Duplicate from active database failed
    CKPT Guru
    Currently Being Moderated
    Angelina wrote:
    I ran it through unix command line, so the session opens there, and it stays there, not move.
    When performing such tasks you should run either nohup or shell script file. Ok.
    Now I asked you to check whether datafiles are restore or not you can see as "restore completed of datafile with checkpoint" , check how many are done
    &
    What is the status later after redo log errors, now where it stands? Still any errors.
    Check the instance status & each datafile points to new location. Post all your findings once.
  • 27. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    under asmcmd, there is no datafile at all .

    and the session still stay in the same position, not moving at all.

    thanks
  • 28. Re: Duplicate from active database failed
    CKPT Guru
    Currently Being Moderated
    under asmcmd, there is no datafile at all .

    and the session still stay in the same position, not moving at all.
    Ok, but those error messages should occur at the end of restore. It won't look to online redo errors until unless restore completes.

    Can you post latest information from alert log file? And check the process in primary by using

    SQL> select sofar,totalwork,time_remaining,last_update_time from v$session_longops where Sid=<RMAN session Sid>;
    Last update time in 24 hour format & compare with your current time.

    How much time left?
    Have you configured good amount of large pool on standby?

    Edited by: CKPT on Mar 3, 2012 7:31 AM
  • 29. Re: Duplicate from active database failed
    user301176 Explorer
    Currently Being Moderated
    oh, sorry ,those errors are in alert log. It was not in rman session. Rman session is not moving.

Legend

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