Originally posted by Axr2

select ads.dest_id,max(sequence#) "Current Sequence",max(log_sequence) "Last Archived",
max(applied_seq#) "Last Sequence Applied"
from v$archived_log al, v$archive_dest ad, v$archive_dest_status ads
where ad.dest_id=al.dest_id
and al.dest_id=ads.dest_id
group by ads.dest_id;
I don't think this query is accurate. Right now, by alert.log says:
Code:
Media Recovery Log /u07/oraarch/tstore1/1_37032.dbf
Mon Sep 13 16:51:25 2004
Media Recovery Waiting for thread 1 seq# 37033
Media Recovery Log /u07/oraarch/tstore1/1_37033.dbf
Mon Sep 13 17:21:22 2004
Media Recovery Waiting for thread 1 seq# 37034
and this query shows:
Code:
[email protected]> l
  1  select ads.dest_id,max(al.sequence#) "Current Sequence",max(ad.log_sequence) "Last Archived",
  2  max(ads.applied_seq#) "Last Sequence Applied"
  3  from v$archived_log al, v$archive_dest ad, v$archive_dest_status ads
  4  where ad.dest_id=al.dest_id
  5  and al.dest_id=ads.dest_id
  6* group by ads.dest_id
[email protected]> /
 
   DEST_ID Current Sequence Last Archived Last Sequence Applied
---------- ---------------- ------------- ---------------------
         1            37033         37033                     0
         2            37033         37033                 37032
The query is telling me 37032 was the last applied and the alert.log is telling me 37033 was applied.