ORA-16086 Redo data cannot be written to the standby redo log

oerr ora 16086
16086, 0000, "Redo data cannot be written to the standby redo log"
// *Cause: The primary database was in MAXIMUM PROTECTION or MAXIMUM
// AVAILABILITY mode, but redo data could not be written to the
// standby redo log at the standby database(s).
// *Action: Check the Remote File Server (RFS) trace file for specific errors
// and reconfigure the standby redo log as appropriate.


set line 300
col dest_name for a30
col status for a20
select dest_name,status,error from v$archive_dest where rownum<5;
--ORA-16086: Redo data cannot be written to the standby redo log


备库查看并增加日志组个数
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 group 11 ('+DATA') size 1024M;
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%';