-----------------------------------------
select max(sequence#) from v$archived_log
where archived = 'YES'
and RESETLOGS_TIME = (select max(RESETLOGS_TIME) from v$archived_log);
Sample Output
Code: Select all
MAX(SEQUENCE#)
---------------
116
------------------------------------------
select max(sequence#) from v$archived_log
where applied = 'YES'
and RESETLOGS_TIME = (select max(RESETLOGS_TIME) from v$archived_log);
Sample Output:
Code: Select all
MAX(SEQUENCE#)
--------------
116