Standby RFS & MRP Process
select process, status,sequence#,block#,blocks, delay_mins from v$managed_standby;PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 23760 813056 1925 0
ARCH CLOSING 23713 567296 1119 0
ARCH CLOSING 23759 958464 656 0
ARCH CLOSING 23715 1 116 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 23761 200510 1 0
MRP0 APPLYING_LOG 23761 200510 1024000 0
RFS IDLE 0 0 0 0
10 rows selected.
Here RFS process is idle its mean there is no archive log generation on primary.
SQL> select thread#, process,status,sequence#, block#,blocks from v$managed_standby where process='RFS';
THREAD# PROCESS STATUS SEQUENCE# BLOCK# BLOCKS
---------- --------- ------------ ---------- ---------- ----------
0 RFS IDLE 0 0 0
0 RFS IDLE 0 0 0
1 RFS IDLE 23761 204221 1
0 RFS IDLE 0 0 0
SQL> select process,pid,status from v$managed_standby;
PROCESS PID STATUS
--------- ------------------------ ------------
ARCH 9352 CONNECTED
ARCH 9354 CLOSING
ARCH 9356 CLOSING
ARCH 9358 CLOSING
ARCH 9360 CLOSING
RFS 1468 IDLE
RFS 1462 IDLE
RFS 1464 IDLE
MRP0 9376 APPLYING_LOG
RFS 1466 IDLE
10 rows selected.
SQL> !ps -ef|grep 9376
oraprod 7178 7176 0 12:09:19 pts/1 0:00 grep 9376
oraprod 9376 1 0 Mar 06 ? 1:30 ora_mrp0_QASKDR
oraprod 7176 7149 0 12:09:19 pts/1 0:00 /usr/bin/bash -c ps -ef|grep 9376
SQL> !ps -ef|grep 1466
oraprod 7181 7179 0 12:09:49 pts/1 0:00 grep 1466
oraprod 1466 1 0 Apr 15 ? 0:00 oracleQASKDR (LOCAL=NO)
oraprod 7179 7149 0 12:09:49 pts/1 0:00 /usr/bin/bash -c ps -ef|grep 1466
SQL>
No comments:
Post a Comment