RFS[3]: No standby redo logfiles available for thread 1

问题描述：备库恢复DG之后，mrp进程一直是wait_for_log，主库创建数据没有正常同步，只有在切换归档的时候备库才能同步主库数据

查看主库日志，主库RFS进程提示没有可用的standby redo在线程1上

主库输出日志：

RFS[3]: Assigned to RFS process 15362

RFS[3]: No standby redo logfiles available for thread 1

RFS[3]: Opened log for thread 1 sequence 712 dbid 1446616449 branch 1051207668

Sat Apr 24 10:19:52 2021

查询主备库standby_log大小

主库：

SQL> select group#,thread#,sequence#,bytes/1024/1024 from v$Log;

    GROUP#    THREAD#  SEQUENCE# BYTES/1024/1024

---------- ---------- ---------- ---------------

	 1	    1	     709	     512

	 2	    1	     710	     512

	 3	    1	     711	     512

	 4	    1	     712	     512

	 5	    1	     707	     512

	 6	    1	     708	     512

备库：

SQL> select group#,thread#,sequence#,bytes/1024/1024 from v$standby_log;

    GROUP#    THREAD#  SEQUENCE# BYTES/1024/1024

---------- ---------- ---------- ---------------

	30	    1	       0	     500

	31	    1	       0	     500

	32	    1	       0	     500

	33	    1	       0	     500

	34	    1	       0	     500

	38	    1	       0	     500

	39	    1	       0	     500

经比较主备库standby_log大小创建不一致，重建备库standby_log

alter database add standby logfile thread 1 group 48'/data/orcl/std_redo48.log' size 512M;

alter database add standby logfile thread 1 group 49'/data/orcl/std_redo49.log' size 512M;

alter database add standby logfile thread 1 group 40'/data/orcl/std_redo40.log' size 512M;

alter database add standby logfile thread 1 group 41'/data/orcl/std_redo41.log' size 512M;

alter database add standby logfile thread 1 group 42'/data/orcl/std_redo42.log' size 512M;

alter database add standby logfile thread 1 group 43'/data/orcl/std_redo43.log' size 512M;

alter database add standby logfile thread 1 group 44'/data/orcl/std_redo44.log' size 512M;

alter database drop logfile group 38;

alter database drop logfile group 39;

alter database drop logfile group 30;

alter database drop logfile group 31;

alter database drop logfile group 32;

alter database drop logfile group 33;

alter database drop logfile group 34;

主库切换归档测试

alter system switch logfile;

备库：

SQL> select process, status, thread#,sequence#, block#, blocks from v$managed_standby;

PROCESS   STATUS	  THREAD#  SEQUENCE#	 BLOCK#     BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

ARCH	  CONNECTED		0	   0	      0 	 0

ARCH	  CONNECTED		0	   0	      0 	 0

ARCH	  CONNECTED		0	   0	      0 	 0

ARCH	  CLOSING		1	 710	      1        416

RFS	  IDLE			0	   0	      0 	 0

MRP0	  APPLYING_LOG		1	 713	 255005    1048576

RFS	  IDLE			0	   0	      0 	 0

RFS	  IDLE			1	 713	 255005 	 1

8 rows selected.

状态正常，mrp进程已经变成applying_log

RFS[3]: No standby redo logfiles available for thread 1的相关教程结束。