Dataguard(Standby) 後臺程式

檢查Standby資料庫上是否歸檔有被應用：

 

在standby 上檢視   select process,status from v$managed_standby;       是否出現mrp程式

 

SQL> select process,status from v$managed_standby;

 

PROCESS STATUS

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

ARCH CONNECTED

ARCH CONNECTED

MRP0 WAIT_FOR_LOG

RFS RECEIVING

 

如果沒有MRP程式，說明沒有開啟為 recover managed standby database狀態 ;

 

可以使用  alter database recover managed standby database disconnect from session ； 開standby。

 

MRP就是備庫的恢復程式

RFS程式接受從主庫來的日誌

沒有MRP程式，說明你的備庫沒有處於恢復狀態

 

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

 

程式：

 

RFS：remote file server

On the standby system, the remote file server (RFS) receives redo data over the network from the

LGWR process and writes the redo data to the standby redo log files.

 

LNSn:

On the primary database, the LGWR process submits the redo data to one or more network server

(LNSn) processes, which then initiate the network I/O in parallel to multiple remote destinations.

 

MRP: managed recovery process

The managed recovery process (MRP) applies archived redo log files to the physical standby database,

and automatically determines the optimal number of parallel recovery processes at the time it starts.

The number of parallel recovery slaves spawned is based on the number of CPUs available on the

standby server.

 

LSP:logical standby process

The logical standby process (LSP) uses parallel execution (Pnnn) processes to apply archived redo

log files to the logical standby database, using SQL interfaces.