list current archive logs

on September 4, 2009 at 7:52 am
Posted In: Oracle Data Guard Notes (Cat)

select inst_id,thread#,sequence#,status
from gv$log
where status=’CURRENT’
order by inst_id,thread#,sequence#