This content has been marked as final. Show 51 replies
ORA-00312: online log 14 thread 2: '+HY_FRA/hyqa/onlinelog/group_14.505.776449007'These errors may occurred when starting MRP after successful restore.
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
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.
Angelina wrote:It's A good question, I will explain it.
when I created standby database, the redo logs were created. why it tried to start the instance with primary redo log informaiton?
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? :)
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
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.
Angelina wrote:When performing such tasks you should run either nohup or shell script file. Ok.
I ran it through unix command line, so the session opens there, and it stays there, not move.
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.
under asmcmd, there is no datafile 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.
and the session still stay in the same position, not moving at all.
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