Skip to content

Latest commit

 

History

History
27 lines (18 loc) · 2.86 KB

high-availability-support.md

File metadata and controls

27 lines (18 loc) · 2.86 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic
High Availability Support
High Availability Support
chugugrace
chugu
03/14/2017
sql
integration-services
conceptual

High Availability Support

[!INCLUDE oracle-cdc-retirement]

The CDC Service for Oracle is designed for high availability. The following features provide part of the high availability support:

  • The CDC Service for Oracle does not use any file resource (local or otherwise). Its entire state is stored in the target [!INCLUDEssNoVersion] instance. This makes it easy to start the service on a different computer that uses the same [!INCLUDEssNoVersion] instance if the computer the service runs on fails. To reduce recovery time, long or long-running Oracle transactions are kept in a staging table in the target [!INCLUDEssNoVersion], preventing the need to re-scan many Oracle transaction logs following a failure (or service restart).

  • The CDC Service for Oracle can use clustered [!INCLUDEssNoVersion] instances so it can recover after the [!INCLUDEssNoVersion] instance fails over to another cluster node. The Oracle CDC Service Computer Administrator only needs to specify the connection information to the clustered [!INCLUDEssNoVersion] instance when creating an Oracle CDC Service.

  • The CDC Service for Oracle can use the [!INCLUDEssnoversion]Always On database mirroring feature. This support requires that the MSXDBCDC and all the CDC databases are in the same availability group. It also requires the Oracle CDC Service Computer Administrator to specify the appropriate Always On connection information to the [!INCLUDEssNoVersion] availability group (for example, the connection properties Failover_Partner and Network=dbmssocn). This allows the CDC service to automatically resume processing on a secondary replication of the databases following a failover.

  • The CDC Service for Oracle can be configured as a generic service resource on a Windows failover cluster (along with, or separate from [!INCLUDEssNoVersion]), making it simple to fail over and fall back CDC processing with the cluster. To configure the CDC Service for Oracle as a resource in a failover cluster, the system administrator must set the CDC Service for Oracle as a Generic Service Resource on each node on the failover cluster.

  • The CDC Service for Oracle supports Oracle RAC, which allows it to communicate with the Oracle database and process logs even when one of the Oracle RAC nodes is down.