Hi,

I use RMAN to backup the 2 nodes RAC. the backup command I use is:
"backup database plus archivelog delete input". I also set controlfile autobackup on. A question here:
let's say I have this backup :

  List of Archived Logs in backup set 39
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    5       107837     19-SEP-04 107905     19-SEP-04

  List of Archived Logs in backup set 40
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       107833     19-SEP-04 107902     19-SEP-04

Here , in thread 1, the backup archivedlog sequence is 4, the next SCN is 107902, and in thread 2, the backup archivelog sequence is 5, the next SCN is 107905.

In this case, if I do a incomplete recovery using the backup controlfile in this backupset, what should I set until to ?

According to the note in metalink, I should use the maximum SCN available, so I should put
run{
set until sequence 6 thread 2;
restore database;
recover database;
alter database open resetlogs;
}
However, if I do this, Oracle will have this:
unable to find archive log
archive log thread=1 sequence=5

RMAN-06054: media recovery requesting unknown log: thread 1 scn 107902

This looks reasonable since oracle backup set don't have sequence 5 for thread 1.

so I have to do my incomplete recovery with
set until sequence 5 thread 1.

This ofcourse works.

My question is: In this case, is it correct ?

Many thanks for any input.

regards/Yerong