Parm Patram

select sequence# from v$archived_log where recid = (select max(recid) from v$archived_log);

select max(sequence#) from v$archived_logs;

this can then be used in rman as follows:

run{
set until sequence 15 thread 1;
restore database;
recover database;
alter database open resetlogs;
}