Database In-Memory feature works in an Oracle Active Data Guard environment.

dataguard 支持内存列存储但是又限制条件，仅支持一体机和云平台。

Starting in Oracle Database 12c Release 2 (12.2.0.1), Oracle Database In-Memory is supported in an Oracle Active Data Guard environment using Oracle Engineered Systems or Oracle Cloud Platform as a Service

#前提条件

Prerequisites

You must meet the following requirements:

• The standby database must run on an Oracle Engineered System or in Oracle Cloud Platform as a Service.

• The COMPATIBLE initialization parameter must be 12.2.0 or greater.

• To populate different objects in each database, configure the appropriate services.

#配置方式

To configure IM column stores in an Oracle Active Data Guard environment:

1. Set the INMEMORY_SIZE initialization parameter on the database instances that will contain an IM column store.

   Follow these guidelines:

   • To configure IM column stores on the primary and standby databases, set INMEMORY_SIZE on both database instances.

   • To configure IM column stores on the standby database only, set INMEMORY_SIZE on the standby database instance.

2. Ensure that the INMEMORY_ADG_ENABLED initialization parameter is set to TRUE (default) on the standby database instance.

3. Optionally, if you want to enable Multi-Instance Redo Apply with the IM column store, set the ENABLE_IMC_WITH_MIRA initialization parameter to TRUE.

4. On the primary database, execute DDL statements with the INMEMORY attribute.

   The task depends on where the IM column stores exist, and in which IM column stores you want the objects to be populated:

   • To populate an object on the standby database only, then set the INMEMORY attribute with a DISTRIBUTE FOR SERVICE clause that specifies a valid service running only on the standby database.

     During redo transfer, the standby database receives this DDL statement from the primary database. Population occurs on the standby database in the normal way. For example, if sales has the INMEMORY attribute and priority NONE, then the table must undergo a full scan for population to occur.

   • To populate an object on the primary database only, then set the INMEMORY attribute with a DISTRIBUTE FOR SERVICE clause that specifies a valid service running only on the primary database.

   • To populate an object on both primary and standby databases, then perform one of the following actions:

     • Do not set the DISTRIBUTE FOR SERVICE clause.

     • Set DISTRIBUTE FOR SERVICE servicename, where servicename is a service that is running on both the primary and standby databases.

     • Set DISTRIBUTE FOR SERVICE DEFAULT so that the object is eligible for population on all instances specified with the PARALLEL_INSTANCE_GROUP initialization parameter.

     • Set DISTRIBUTE FOR SERVICE ALL so that the object is eligible for population on all instances, regardless of the setting of the PARALLEL_INSTANCE_GROUP initialization parameter.

     Population of an object occurs on the primary or standby database according to the priority setting. For example, if sales on the standby database has priority NONE, then a query of the standby database that triggers a full scan of sales populates this table in the standby IM column store.

参考地址：

https://docs.oracle.com/en/database/oracle/oracle-database/19/inmem/deploying-im-column-store-with-adg.html#GUID-D7307BB7-2C8D-4A2C-98F6-B3F6000EFC20