1、检查主备库服务名(tnsnames)是否配置且正常访问。
2、若备库是RAC环境关闭多余节点。
3、关闭mrp进程,rman执行
##关闭mrp
alter database recover managed standby database cancel;
##rman执行增量恢复
recover standby database from service primdb;
4、完成增量开启同步
##关闭mrp
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect;
##rman执行增量恢复
报错处理
2023-12-07T15:47:58.152113+08:00<br />Errors in file /oracle/app/diag/rdbms/repdg/rep/trace/rep_mrp0_86917.trc:<br />ORA-19909: datafile 1 belongs to an orphan incarnation<br />ORA-01110: data file 1: '/oradata/rep/system.281.1137415925'<br />
检查主备 rman> list incarnation;
化身信息
若不一致 将备库恢复时的化身设置为 主库最后一个化身ID;
参考文档 MRP Recovery Failed With ORA-19909 [ID 554358.1]