13 lines
440 B
SQL
13 lines
440 B
SQL
set linesize 120
|
|
set pagesize 999
|
|
break on dest_id skip 2 on thread# skip 1;
|
|
|
|
select dest_id, thread#, sequence#, next_change#, to_char(next_time, 'DD/MM/YYYY HH24:MI:SS') next_time,
|
|
to_char(completion_time,'DD/MM/YYYY HH24:MI:SS') completion_time, archived, applied, deleted, status, fal
|
|
from v$archived_log
|
|
where standby_dest='YES'
|
|
and completion_time >= trunc(sysdate) -1
|
|
order by dest_id, thread#, sequence#;
|
|
|
|
clear breaks
|