Oracle
Data Guard

Recovery Queue

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';