备库wait_for_log -- ORA-16086

主库查看通道

select error,status from gv$archive_dest where dest_id=11;

备库查看并增加日志组个数

select group#,thread#,sequence#,archived,status,bytes/1024/1024 MB from v$standby_log;

alter database recover managed standby database cancel;

alter database add standby logfile [thread 1] size 2G;

select group#,thread#,sequence#,archived,status,bytes/1024/1024 MB from v$standby_log;

同步状态

--查看延迟--
--stblag.sql--
col value for a20
col name for a24
col DATUM_TIME for a20
col TIME_COMPUTED for a25
SELECT name, value, datum_time, time_computed FROM V$DATAGUARD_STATS;

--查看传输速率--
--stbspeed.sql--
set lines 200
col type format a15
col ITEM format a26
col units format a15
col comments format a25
select * from v$recovery_progress where START_TIME = (select max(START_TIME) from v$recovery_progress);

--查看备库状态--
--stbstatus.sql--
select PID,PROCESS,STATUS,SEQUENCE#,THREAD#,BLOCKS,DELAY_MINS from v$managed_standby;

--查看GAP--
--gap.sql--
select * from v$archive_gap;

--查看剩余归档量--
--arch.sql--
SELECT SUM(BLOCKS*BLOCK_SIZE)/1024/1024 MB FROM V$ARCHIVED_LOG WHERE REGISTRAR = 'RFS' AND APPLIED='NO' AND name like '/arc%';