是否同步
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
select recovery_mode from v$archive_dest_status;
# 如果为 MANAGED REAL TIME APPLY 则为实时应用日志。
alter database recover managed standby database cancel;
alter database recover managed standby database disconnect from session;
alter database recover managed standby database using current logfile disconnect from session;
col dest_name format a30;
col error format a20;
select dest_name,error from v$archive_dest;
每天的归档量
select logtime,
count(*),
round(sum(blocks * block_size) / 1024 / 1024) size_mb
from (select trunc(first_time, 'dd') as logtime, a.BLOCKS, a.BLOCK_SIZE
from v$archived_log a
where a.DEST_ID = 1
and a.FIRST_TIME > trunc(sysdate - 7))
group by logtime
order by logtime desc;
