This discussion is archived
4 Replies Latest reply: Nov 6, 2012 9:36 AM by JohnWatson RSS

Finding the order of archive logs in RAC to NON-RAC manual cloning

User412521 Newbie
Currently Being Moderated
Hi,

I am in the process of automating a RAC to NON-RAC clone using traditional method [ not using RMAN ].

Here are the steps:
On Source:

Record the sequence number and thread of the instance
put the database in begin backup mode
copy the files
disable the backup mode
record the sequence number and thread of the instance
prepare the order of the archive logs which will be needed for recovery ==> Here is where I need help

On Target:
Restore the backup
Issue recovery using the order of archive logs identified ==> Failing as order is not correct.


I am finding the archive logs based on FIRST_TIME# and preparing the order which is not correct. I think i should be using SCN but not sure what should be the criteria.

Could you please let me know on what basis we can find the order of the archive logs which will be asked during the recovery ?
Your quick response is appreciated. Thanks in advance for your help.

Thanks
Suneel

Legend

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