Archived Log Details

View Archived Log Details

col status for a5
select thread#, sequence#, first_time, first_change#, next_time
,next_change#
,completion_time, name
--,archived,applied
--,deleted, status
--,(blocks*512)
from v$archived_log
where completion_time > sysdate - 5
--and status = 'A'
and deleted = 'NO'
order by sequence#, thread#;


View Log History Details (similar to above)

select thread#, sequence#, first_change#, first_time, next_change#
from v$log_history
where first_time > sysdate - 1/24 /* 1 hour */
order by sequence#;