12.2新特性，ADG是RAC环境，在多个实例可以启动MRP进程recover，命令如ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION INSTANCES ALL
该特性只适用RAC和RAC one node环境数据库,不支持块跟踪,不支持In-Memeory列存储 注：MRP进程只在执行命令的节点运行，其他节点会产生pr* recovery processes进程。
D.1.1 Setting Up Multi-Instance Redo Apply
As of Oracle Database 12
c
Release 2 (12.2.0.1), a new
INSTANCES [ ALL |
integer
]
clause is available on the SQL
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
command.
The clause is applicable only for Oracle Real Application Clusters (Oracle RAC) or Oracle RAC One Node databases.
Block Change tracking is not supported.
In-Memory column store is not supported with multi-instance redo apply in an Active Data Guard (ADG) environment.
The
ALL
option causes redo apply to run on all instances in an Oracle RAC standby database that are in an open or mounted state at the time recovery is started. .All instances must be in the same state — either open or mounted. A mix of states is not allowed.
The
integer
option restricts the number of instances that redo apply uses to the number you specify. For integer, specify an integer value from 1 to the number of instances in the standby database. The database chooses the instances on which to perform Redo Apply; you cannot specify particular instances.
The
V$RECOVERY_PROGRESS
view is only populated on the instance where recovery was started (where the MRP0 process resides).
If you omit the
INSTANCES
clause, then recovery happens on only one instance where the command was issued.
Because recovery processes ship redo among instances, redo apply performance is directly related to network bandwidth and latency.
编辑推荐：
- 12.2新特性之ADG多节点启动MRP进程03-03
- exp导出用户和对象报错ora--1215403-03
- Disable the Evolve Job SYS_AUTO_SPM_EVOLVE_TASK in Oracle 12c03-03
- Manually Evolve and Accept SQL PLAN BASELINES in Oracle 12c03-03
- [20190215]sqlplus set arraysize.txt03-03
- Manage SQL Plan Baselines in Oracle 12c03-03
- OGG单向复制03-03
- [20190218]延迟约束问题2.txt03-03
相关推荐
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效
2 月 9 日消息，雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用
2 月 10 日消息，制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- PL/SQL Developer 字体设置 完美（冷淡）配色方案
PL/SQL Developer 字体设置 完美（冷淡）配色方案
26-03-03 - Oracle 19C 下载和安装
Oracle 19C 下载和安装
26-03-03 - Linux 安装 Oracle 11g——手工建库（RAC）
Linux 安装 Oracle 11g——手工建库（RAC）
26-03-03 - ORACLE RMAN备份--差异增量与累积增量的策略实例图
ORACLE RMAN备份--差异增量与累积增量的策略实例图
26-03-03 - 使用正则表达式对数字字符串字段排序
使用正则表达式对数字字符串字段排序
26-03-03 - [20190226]删除tab$记录的恢复6.txt
![[20190226]删除tab$记录的恢复6.txt](https://www.herecours.com/d/file/efpub/2026/03-03/20260303124611829872.jpg?x-oss-process=style/bb "[20190226]删除tab$记录的恢复6.txt")
[20190226]删除tab$记录的恢复6.txt
26-03-03 - 为何Oracle Database 12R2输入正确的用户名密码口令验证依然不能通过？
- Oracle Data Guard 部署调试试验【一主一备/单机】
Oracle Data Guard 部署调试试验【一主一备/单机】
26-03-03 - Oracle的SCN显示问题
Oracle的SCN显示问题
26-03-03 - WRH$_ACTIVE_SESSION_HISTORY未自动清理导致SYSAUX空间过度增长的处理方法
