4 Replies Latest reply: Nov 6, 2012 11:36 AM by JohnWatson RSS

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

    User412521
      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