Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Repeatedly Mrp and Rfs goes down in ORACLE 19c

4043550Sep 22 2019 — edited Sep 23 2019

SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

PROCESS STATUS

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

ARCH CLOSING

DGRD ALLOCATED

ARCH CLOSING

ARCH CONNECTED

PROCESS STATUS

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

ARCH CONNECTED

PROCESS STATUS

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

ARCH CONNECTED

Both MRP and RFS process is not running in oracle 19c.

Following troubleshoot done:

1. From standby:

SQL> recover managed standby database cancel;

ORA-16136: Managed Standby Recovery not active

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

Cancelled the session, so that MRP shuld be started, but it will not be started.

ps -ef |grep -i mrp

oracle 37462 36952 0 18:25 pts/0 00:00:00 grep --color=auto -i mrp

Can anyone please guide me how to make sure this MRP and RFS is always up and running?

Regards,

Pooja.G

Added on Sep 22 2019

#general-database-discussions

3 comments

2,973 views