Forum Stats

  • 3,760,188 Users
  • 2,251,661 Discussions
  • 7,871,018 Comments

Discussions

recover to latest archivelog

Robeen
Robeen Member Posts: 2,091 Silver Badge

Oracle DB 12.1.0.2


Hello Team,


could you please advise how to restore archivelogs from min recovery scn to latest scn of archivelogs backed up? Assume source is RAC 2 nodes and target standalone filesystem.

select min(FHSCN) "LOW FILEHDR SCN" , max(FHSCN) "MAX FILEHDR SCN" , max(FHAFS) "Min PITR ABSSCN" from X$KCVFH ;

minimum scn will be 'low scn'.


Thanks,


Roshan

Best Answer

Answers