oracle 启动mrp进程,12.2新特性之ADG多节点启动MRP进程

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.

It has the following restrictions:

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