1.从库没有RFS进程,未拉去主库最新的日志文件。
SQL> select process,status,thread#,sequence#,block#,blocks from V$managed_standby order by 1,4;
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 CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 1 84583 0 0
RFS进程未启动。
SYS@coredb1> col DEST_NAME for a50
SYS@coredb1> select dest_name,status,error from v$archive_dest;
DEST_NAME STATUS ERROR
-------------------------------------------------- --------- -----------------------------------------------------------------
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2(密码的DM5不相同) ERROR ORA-16191: Primary log shipping client not logged on standby
LOG_ARCHIVE_DEST_3(参数设置为defer) DISABLED ORA-12543: TNS:destination host unreachable
LOG_ARCHIVE_DEST_4 ERROR ORA-16191: Primary log shipping client not logged on standby
LOG_ARCHIVE_DEST_5 INACTIVE
LOG_ARCHIVE_DEST_6 INACTIVE
2.原因分析
检查发现密码的DM5码不相同,RAC1,RAC2,DG库都设置同一个密码文件。
同时DG备库恢复,这里主要原因是修改完sys密码导致密码文件的dm5变更。
主库连接备库通过dm5码进行匹配
SQL> select process,status,thread#,sequence#,block#,blocks from V$managed_standby order by 1,4;
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 2 89584 206848 897
MRP0 WAIT_FOR_LOG 1 84590 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 1 84590 271064 1
3.总结
RFS进程未启动有如下几个原因:
(1).监听未启动。
(2).密码文件的DM5不相同,特别是主库修改过sys密码.
(3).其他参数配置错误。