standby database No RFS 进程

最新推荐文章于 2022-02-12 11:14:05 发布

cmbpr28628

最新推荐文章于 2022-02-12 11:14:05 发布

阅读量260

点赞数

文章标签：数据库

standby database

点击(此处)折叠或打开

SQL> select * from v$managed_standby;

PROCESS PID STATUS     CLIENT_P CLIENT_P CLIENT_DBID GROUP# RESETLOG_ID THREAD# SEQUENCE# BLOCK#    BLOCKS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS
--------- ------ ------------ -------- -------- --------------- ---------- ----------- ---------- ---------- ---------- ---------- ---------
ARCH 2602 CONNECTED ARCH     2602 845781194     N/A          0    0 0     0     0        0     0         0
ARCH 2604 CONNECTED ARCH     2604 845781194     N/A          0    0 0     0     0        0     0         0
ARCH 2606 CONNECTED ARCH     2606 845781194     N/A          0 0 0     0     0        0     0         0
ARCH 2608 CONNECTED ARCH     2608 845781194     N/A          0 0 0     0     0        0     0         0
MRP0 2655 WAIT_FOR_LOG   N/A N/A     N/A N/A      881314188 1     33     0     0        0     0         0

看到没有RFS进程，从库接受不到了
查看主库

点击(此处)折叠或打开

SQL> select dest_id,error from v$archive_dest;

   DEST_ID ERROR
---------- -----------------------------------------------------------------
     1
     2 ORA-12541: TNS:no listener

启备库监听

点击(此处)折叠或打开

SQL> r
  1* select * from v$managed_standby

PROCESS PID STATUS CLIENT_P CLIENT_PID CLIENT_DBID GROUP# RESETLOG_ID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS
--------- ---------- ------------ -------- ---------- ------------------ -------- ----------- ---------- ---------- ---------- ---------- ----
ARCH 2602 CONNECTED     ARCH     2602 845781194      N/A 0     0     0   0        0     0        0     0
ARCH 2604 CONNECTED     ARCH     2604 845781194      N/A 0     0     0   0        0     0        0     0
ARCH 2606 CONNECTED     ARCH     2606 845781194      N/A 0     0     0   0        0     0        0     0
ARCH 2608 CLOSING ARCH     2608 845781194      4   881314188     1     33    124928     867     0        0     0
MRP0 2655 WAIT_FOR_LOG N/A N/A   N/A N/A     881314188     1     42 0        0     0        0     0
RFS        2691 IDLE   UNKNOWN   2600 845781194      N/A 0     0     0   0        0     0        0     0
RFS        2693 IDLE   UNKNOWN   2604 845781194      N/A 0     0     0   0        0     0        0     0
RFS        2687 IDLE   UNKNOWN   2606 845781194      N/A 0     0     0   0        0     0        0     0
RFS        2689 IDLE LGWR     2608 845781194      3   881314188     1     42    32        1     0        0     0