oracle关闭mrp进程卡死,ORA-38760_DG无法启动MRP进程 | YallonKing

记录一次ORA-38760_DG无法启动MRP进程

现象是监控报警称主备库日志应用不同步，登到备库查看mrp进程不存在，随即启动mrp进程，前台正常返回无报错，但是mrp进程还是没有启动起来。

如下：

前台执行

SQL> alter database recover managed standby database disconnect from session parallel 2;

Database altered.

正常返回，但是mrp进程没有启动

alert报错

Thu Oct 16 09:58:40 2014

MRP0: Background Media Recovery terminated with error 38760

Errors in file /oradata/diag/rdbms/xxxxxs2/xxxxxs2/trace/xxxxxs2_pr00_15195.trc:

ORA-38760: This database instance failed to turn on flashback database

Slave exiting with ORA-38760 exception

Errors in file /oradata/diag/rdbms/xxxxxs2/xxxxxs2/trace/xxxxxs2_pr00_15195.trc:

ORA-38760: This database instance failed to turn on flashback database

Recovery Slave PR00 previously exited with exception 38760

MRP0: Background Media Recovery process shutdown (xxxxxs2)

Completed: alter database recover managed standby database disconnect from session parallel 2

删除闪回恢复点后正常

SQL> select flashback_on from v$database;

FLASHBACK_ON

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

RESTORE POINT ONLY

SQL> select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE</