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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-758237/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15747463/viewspace-758237/