linux guard什么进程,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.

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

on primary database:Log writer process (LGWR):把数据写到在线日志中

Data Guard除了以上传统的Arch日志传送过程外，还可以采用联机日志的传送，在备用端建议创建一组备用日志，并保持与主数据库备用日志相同大小，而且最好比主数据库的联机日志多一组以上。

如果LGWR传送日志，但是不在备用端创建备用日志的话，联机日志将自动写到备用端的归档日志中。

即使是用LGWR进行日志的传输，备用库的online redo log的内容是不能马上被应用的，必须当归档完成后才由MRPn进程应用到备用数据库，所以说，恢复不是连续的，但是，传送过程可以是连续的。

即使备用数据库不是在归档的模式，所有的在线日志还是会进行归档的操作，前提是ARCn进程必须打开。Archiver process (ARCn)：COPY在线日志到本地或远程。这就是归档日志。

Fetch archive log (FAL) process (physical standby databases only)：

FAL提供一个client/server的机制来检测主备机上的归档是否有间断。由standby上的FAL client和和primary上FAL server来实现此工作。由FAL_CLIENT和FAL_SERVER参数决定primary database和standby database。

On the standby location，log transport services使用下面的进程Remote file server (RFS)：用于从primary上接受归档文件ARCn process

当standby使用online redo的时候，也就是maximum protection或maximum availability模式下，ARCn用于归档。

_ On the standby location, log apply services使用下面的进程Managed recovery process (MRP)(For physical standby databases only)：用于把归档应用到standby database

Logical standby process (LSP)(For logical standby databases only):用SQL接口把归档应用到logical database

_ On the primary and standby locations, the Data Guard broker使用下面进程Data Guard broker monitor (DMON):用于监控数据库的状态，管理log transport services and log apply services