内容阅读
在知识库中专注阅读，并随时返回相关工具与课程
ORA-16136警告DataGuard
管理恢复进程已停止
Managed Recovery Process has been stopped
错误描述
备用数据库上的管理恢复进程（MRP）已停止。重做应用不再活跃，备库将落后。
可能原因
- DBA 手动取消恢复：ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
- MRP 在日志应用期间遇到错误
- 归档日志间隙导致 MRP 停止等待
解决方案
- 1重启 MRP：ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
- 2先检查并解决任何归档日志间隙
- 3查看备库告警日志了解 MRP 错误详情
诊断命令
SELECT process, status, sequence#, block# FROM v$managed_standby;SELECT thread#, low_sequence#, high_sequence# FROM v$archive_gap;SELECT MAX(sequence#) FROM v$archived_log WHERE applied = 'YES';#dataguard#mrp#recovery#standby