This content has been marked as final. Show 4 replies
I'm working from memory, but I thought you would be promptd for the archivelogs from both threads in whatever order is necessary. And if there is any doubt, querying v$recovery_log after the restore and mount should tell what will be needed.
What are the prompts and errors you are getting? (Note that "Failing as order is not correct" is not an Oracle error message).
Yes, When we execute recover database using backup controlfile until cancel, will prompt for the redo log sequences.
But as i mentioned before, I am trying script everything and cannot manually enter the sequence numbers required. I need to know the archives and thread it is going to ask [ in what order as well ] so that recovery command can be scripted in shell.
Please let me know if there is a away to find the order of archive logs which needs to be applied to recover [ if this is a NON-RAC, we can simply go with the sequence numbers but since it is a RAC, i should know the thread number as well ].