dgmgrl /
SHOW DATABASE orcl2 'RecvQEntries';
sqlplus / as sysdba
SET LINESIZE 200
SELECT status,
resetlogs_id,
thread#,
sequence#,
TO_CHAR(first_time,'DD/MM/YYYY HH24:MI:SS'),
TO_CHAR(completion_time,'DD/MM/YYYY HH24:MI:SS'),
first_change#,
next_change#,
TRUNC(blocks*block_size/1024) "Size (KBs)"
FROM v$archived_log
WHERE registrar = 'RFS'
AND applied = 'NO';