SRL日志thread变成0导致无法进行同步

环境 11.2.0.4
保护模式：最大性能。
lgwr sync
现象: 备端数据库启用实时日志应用，但是主库发生的事务部能及时应用到备份数据库系统。


分析日志： 发现rfs进行不能识别到thread 1 线程的SRL日志。


SELECT THREAD# FRom v$standby_log;
0
0
0
0


RFS[2]: No standby redo logfiles created for thread 1 
RFS[2]: Opened log for thread 1 sequence 28 dbid 1507099248 branch 979318514
Thu Jun 21 14:12:59 2018
Media Recovery Log /DBBackup/Archive/1_27_979318514.dbf
Media Recovery Waiting for thread 1 sequence 28 (in transit)
Thu Jun 21 14:14:54 2018
Archived Log entry 19 added for thread 1 sequence 28 rlc 979318514 ID 0x59d48270 dest 2:
RFS[2]: No standby redo logfiles created for thread 1 
RFS[2]: Opened log for thread 1 sequence 29 dbid 1507099248 branch 979318514
Thu Jun 21 14:14:55 2018
Media Recovery Log /DBBackup/Archive/1_28_979318514.dbf
Media Recovery Waiting for thread 1 sequence 29 (in transit)
Thu Jun 21 14:18:35 2018
alter database drop logfile group 4
ORA-1156 signalled during: alter database drop logfile group 4...
Thu Jun 21 14:19:37 2018
alter database add standby logfile thread 1 group 8 '/u01/app/oracle/oradata/orcl/sbredo071' size 50M
ORA-1156 signalled during: alter database add standby logfile thread 1 group 8 '/u01/app/oracle/oradata/orcl/sbredo071' size 50M..
.
Thu Jun 21 14:20:15 2018
alter database recover managed standby database cancel
Thu Jun 21 14:20:15 2018
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/sty/orcl/trace/orcl_pr00_5219.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Thu Jun 21 14:20:15 2018
MRP0: Background Media Recovery process shutdown (orcl)
Managed Standby Recovery Canceled (orcl)
Completed: alter database recover managed standby database cancel
alter database add standby logfile thread 1 group 8 '/u01/app/oracle/oradata/orcl/sbredo071' size 50M
Completed: alter database add standby logfile thread 1 group 8 '/u01/app/oracle/oradata/orcl/sbredo071' size 50M
Thu Jun 21 14:20:45 2018
alter database add standby logfile thread 1 group 9 '/u01/app/oracle/oradata/orcl/sbredo072' size 50M
Completed: alter database add standby logfile thread 1 group 9 '/u01/app/oracle/oradata/orcl/sbredo072' size 50M
Thu Jun 21 14:20:57 2018
alter database drop logfile group 4
Completed: alter database drop logfile group 4
Thu Jun 21 14:21:23 2018
alter database drop logfile group 5
Completed: alter database drop logfile group 5
alter database drop logfile group 6
Completed: alter database drop logfile group 6
Thu Jun 21 14:21:38 2018
alter database drop logfile group 7
Completed: alter database drop logfile group 7
Thu Jun 21 14:22:53 2018
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (orcl)
Thu Jun 21 14:22:54 2018
MRP0 started with pid=25, OS id=5268 
MRP0: Background Managed Standby Recovery process started (orcl)
 started logmerger process
Thu Jun 21 14:22:59 2018
Managed Standby Recovery starting Real Time Apply






（接受日志的还是主库的arch ping进程进行日志传输（在不存在srl的情况下进行恢复））
[oracle@redhat59 trace]$ 
处理方案：
停止MRP应用


1 alter database recover managed standby database cancel
在线程1 添加srl日志
2 alter database add standby logfile thread 1 group 8 '/u01/app/oracle/oradata/orcl/sbredo071' size 50M
  alter database add standby logfile thread 1 group 9 '/u01/app/oracle/oradata/orcl/sbredo072' size 50M
启动实时应用
  alter database recover managed standby database using current logfile disconnect from session
主库切换日志
alter system switch logfile;