I don't think this query is accurate. Right now, by alert.log says:Quote:
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;
and this query shows: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
The query is telling me 37032 was the last applied and the alert.log is telling me 37033 was applied.Code:system@tstore1.us> 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
system@tstore1.us> /
DEST_ID Current Sequence Last Archived Last Sequence Applied
---------- ---------------- ------------- ---------------------
1 37033 37033 0
2 37033 37033 37032