oracle 11g data guard 中RFS、MRP程式的說明

下面是主備庫程式的一張關聯圖



RFS（remote file server）：執行在備庫上的程式，用於在備庫上進行主庫的日誌恢復。預設，這個程式用於接收從主庫傳送過來的歸檔日誌。
當物理備庫啟用了 Redo Apply時，備庫可以通過實時應用這個特性，直接使用這個程式從 standby redo log 中直接應用 redo 日誌。


下面是在備庫的 alert 日誌中擷取的一段關於 RFS 的資訊


2851 RFS[1]: Selected log 7 for thread 1 sequence 40 dbid 3135732069 branch 895320808
2852 Sun Nov 15 01:00:48 2015
2853 Archived Log entry 17 added for thread 1 sequence 39 ID 0xbae9db91 dest 1:
2854 Mon Nov 16 22:01:29 2015
2855 RFS[1]: Selected log 6 for thread 1 sequence 41 dbid 3135732069 branch 895320808
2856 Mon Nov 16 22:01:30 2015
2857 Archived Log entry 18 added for thread 1 sequence 40 ID 0xbae9db91 dest 1:
2858 Tue Nov 17 14:15:33 2015
2859 Primary database is in MAXIMUM PERFORMANCE mode
2860 RFS[2]: Assigned to RFS process (PID:21867)
2861 RFS[2]: Selected log 7 for thread 1 sequence 42 dbid 3135732069 branch 895320808
2862 Tue Nov 17 14:15:33 2015
2863 RFS[3]: Assigned to RFS process (PID:21869)
2864 RFS[3]: Selected log 6 for thread 1 sequence 41 dbid 3135732069 branch 895320808
2865 Tue Nov 17 14:15:33 2015
2866 Archived Log entry 19 added for thread 1 sequence 41 ID 0xbae9db91 dest 1:
2867 Tue Nov 17 14:44:20 2015
2868 Primary database is in MAXIMUM PERFORMANCE mode
2869 RFS[4]: Assigned to RFS process (PID:23281)
2870 RFS[4]: Selected log 6 for thread 1 sequence 43 dbid 3135732069 branch 895320808
2871 Tue Nov 17 14:44:20 2015
2872 RFS[5]: Assigned to RFS process (PID:23285)
2873 RFS[5]: Selected log 7 for thread 1 sequence 42 dbid 3135732069 branch 895320808
2874 Tue Nov 17 14:44:22 2015
2875 Archived Log entry 20 added for thread 1 sequence 42 ID 0xbae9db91 dest 1:
2876 Tue Nov 17 16:10:46 2015
2877 Primary database is in MAXIMUM PERFORMANCE mode
2878 RFS[6]: Assigned to RFS process (PID:27628)
2879 RFS[6]: Selected log 7 for thread 1 sequence 44 dbid 3135732069 branch 895320808
2880 Tue Nov 17 16:10:47 2015
2881 RFS[7]: Assigned to RFS process (PID:27632)
2882 RFS[7]: Selected log 6 for thread 1 sequence 43 dbid 3135732069 branch 895320808

在主庫的報錯日誌中，有如下一段，是主庫嘗試連線到備庫的RFS程式


 4111 Error 12541 received logging on to the standby
 4112 Check whether the listener is up and running.
 4113 Tue Nov 10 14:57:49 2015
 4114 Error 1034 received logging on to the standby
 4115 Tue Nov 10 15:02:51 2015
 4116 ARC2: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (1094)
 4117 ARC2: Error 1094 attaching to RFS for reconnect
 4118 Tue Nov 10 15:03:01 2015
 4119 ARC2: Error 1094 attaching to RFS for reconnect
 4120 ARC2: Error 1094 attaching to RFS for reconnect
 4121 Tue Nov 10 15:03:11 2015
 4122 ARC2: Error 1094 attaching to RFS for reconnect
 4123 ARC2: Error 1094 attaching to RFS for reconnect
 4124 Tue Nov 10 15:03:21 2015
 4125 ARC2: Error 1094 attaching to RFS for reconnect
 4126 ARC2: Error 1094 attaching to RFS for reconnect
 4127 Tue Nov 10 15:03:31 2015
 4128 ARC2: Error 1094 attaching to RFS for reconnect
 4129 ARC2: Error 1094 attaching to RFS for reconnect
 4130 Tue Nov 10 15:03:41 2015
 4131 ARC2: Error 1094 attaching to RFS for reconnect
 4132 ARC2: Error 1094 attaching to RFS for reconnect
 4133 ARC2: Error 1094 attaching to RFS for reconnect

MRP：當物理備庫啟用了實時應用的時候，會建立這個程式，用於日誌的實時應用。


下面是擷取備庫 alert 日誌中的一段資訊


2348 Starting background process MRP0
2349 Wed Nov 11 11:24:25 2015
2350 MRP0 started with pid=7, OS id=8220
2351 Wed Nov 11 11:24:26 2015
2352 MRP0: Background Managed Standby Recovery process started (newdb)


當資料庫主備角色切換時，備庫會殺掉這個程式，下面是 alert 日誌中的一段


 4777 MRP0: Background Media Recovery process shutdown (newdb)
 4778 Wed Nov 11 11:22:51 2015
 4779 Role Change: Canceled MRP
 4780 Killing 2 processes (PIDS:27972,20487) (all RFS) in order to disallow current and future RFS connections. Requested by OS process 27978
 4781 Stopping Emon pool
 4782 All dispatchers and shared servers shutdown
 4783 CLOSE: killing server sessions.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26506993/viewspace-1846999/，如需轉載，請註明出處，否則將追究法律責任。