1 2 3 4 Previous Next 51 Replies Latest reply: Mar 3, 2012 3:15 PM by 877440 Go to original post RSS
      • 15. Re: Duplicate from active database failed
        877440
        show
        • 16. Re: Duplicate from active database failed
          Shivananda Rao
          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
            877440
            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
              877440
              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
                877440
                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
                  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
                    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
                      877440
                      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
                        877440
                        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
                          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
                            877440
                            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
                              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
                                877440
                                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
                                  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
                                    877440
                                    oh, sorry ,those errors are in alert log. It was not in rman session. Rman session is not moving.