ApplyInstances

The ApplyInstances property lets you specify how many physical standby instances run Redo Apply.

This property is used to specifiy a value for the INSTANCES keyword used with the SQL ALTER RECOVER MANAGED STANDBY DATABASE statement (only for Oracle Real Application Clusters (Oracle RAC) or Oracle RAC One Node databases). When used, it causes Redo Apply to run on each active running physical standby instance that is running in the same mode as the instance on which Redo Apply was started. You can specify ALL or you can specify a specific number to restrict the number of instances that Redo Apply uses. If a database has already been set up to run Redo Apply on multiple instances, then you can use the Data Guard broker property ApplyInstances to restrict the number of instances that are involved in Redo Apply on an Oracle RAC physical standby database.

See Also:

Oracle Data Guard Concepts and Administration for more information about setting up multi-instance Redo Apply.

Category	Description
Datatype	Integer
Valid values	0 to 16, ALL ALL: indicates that redo apply will be started on all currently active instances 0 and 1: recovery will be started in single instance mode. >1: indicates that redo apply should not run on any more than the number of instances specified.
Broker default	The default is 0.
Imported?	Yes
Parameter class	Not applicable
Role	Standby
Standby type	Physical standby
Corresponds to	`INSTANCES` keyword of `ALTER DATABASE RECOVER MANAGED STANDBY DATABASE` command.
Scope	Database
Cloud Control name	Not applicable