Home » Server Options » Data Guard » ora_mrp0 in Oracle 10g
ora_mrp0 in Oracle 10g [message #253799] Tue, 24 July 2007 18:26 Go to next message
Messages: 26
Registered: June 2007
Junior Member
Hi All,
Our application has a Oracle 10g database where we have an Active and Physical Standby database.
We understand that there's an ora_mrp0 Managed Recovery Oracle background process that is used to apply redo information to the Physical Standby database.

When we see the list of Oracle background processes running we are not able to see the ora_mrp0 running on the Physical Standby database.

In the earlier version of our product we were using Oracle 9i. And we always use to see ora_mrp0 process running on the Standby side.

Has this changed in Oracle 10g? I mean does this process run intermittently or there is some other process in Oracle 10g which applies the redo information to physical standby database.

Thanks and regards,
Kaustubh Kane.
Re: ora_mrp0 in Oracle 10g [message #253800 is a reply to message #253799] Tue, 24 July 2007 18:34 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
No it still exists
ndcint08: ps -ef |grep mrp
  oracle  9380     1   0   May 21 ?          57:33 ora_mrp0_FLPS
  oracle 18874     1   0   May 23 ?          33:45 ora_mrp0_FLPSA
  oracle 18992 18837   0 23:39:39 pts/3       0:00 grep mrp

SQL> select name from v$bgprocess
  2  where name like '%MRP%';


  • Attachment: dg_pres1.ppt
    (Size: 669.00KB, Downloaded 3213 times)
Previous Topic: Standby Database error
Next Topic: ORA 16009 and ORA 16766 errors on Physical Standby (RAC)
Goto Forum:

Current Time: Thu May 23 07:41:25 CDT 2024