Interface CfnEndpoint.OracleSettingsProperty
- All Superinterfaces:
software.amazon.jsii.JsiiSerializable
- All Known Implementing Classes:
CfnEndpoint.OracleSettingsProperty.Jsii$Proxy
- Enclosing class:
CfnEndpoint
This information includes the output format of records applied to the endpoint and details of transaction and control table data information. For information about other available settings, see Extra connection attributes when using Oracle as a source for AWS DMS and Extra connection attributes when using Oracle as a target for AWS DMS in the AWS Database Migration Service User Guide .
Example:
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import software.amazon.awscdk.services.dms.*;
OracleSettingsProperty oracleSettingsProperty = OracleSettingsProperty.builder()
.accessAlternateDirectly(false)
.additionalArchivedLogDestId(123)
.addSupplementalLogging(false)
.allowSelectNestedTables(false)
.archivedLogDestId(123)
.archivedLogsOnly(false)
.asmPassword("asmPassword")
.asmServer("asmServer")
.asmUser("asmUser")
.charLengthSemantics("charLengthSemantics")
.directPathNoLog(false)
.directPathParallelLoad(false)
.enableHomogenousTablespace(false)
.extraArchivedLogDestIds(List.of(123))
.failTasksOnLobTruncation(false)
.numberDatatypeScale(123)
.oraclePathPrefix("oraclePathPrefix")
.parallelAsmReadThreads(123)
.readAheadBlocks(123)
.readTableSpaceName(false)
.replacePathPrefix(false)
.retryInterval(123)
.secretsManagerAccessRoleArn("secretsManagerAccessRoleArn")
.secretsManagerOracleAsmAccessRoleArn("secretsManagerOracleAsmAccessRoleArn")
.secretsManagerOracleAsmSecretId("secretsManagerOracleAsmSecretId")
.secretsManagerSecretId("secretsManagerSecretId")
.securityDbEncryption("securityDbEncryption")
.securityDbEncryptionName("securityDbEncryptionName")
.spatialDataOptionToGeoJsonFunctionName("spatialDataOptionToGeoJsonFunctionName")
.standbyDelayTime(123)
.useAlternateFolderForOnline(false)
.useBFile(false)
.useDirectPathFullLoad(false)
.useLogminerReader(false)
.usePathPrefix("usePathPrefix")
.build();
- See Also:
-
Nested Class Summary
Nested ClassesModifier and TypeInterfaceDescriptionstatic final classA builder forCfnEndpoint.OracleSettingsPropertystatic final classAn implementation forCfnEndpoint.OracleSettingsProperty -
Method Summary
Modifier and TypeMethodDescriptionbuilder()default ObjectSet this attribute tofalsein order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.default NumberSet this attribute withArchivedLogDestIdin a primary/ standby setup.default ObjectSet this attribute to set up table-level supplemental logging for the Oracle database.default ObjectSet this attribute totrueto enable replication of Oracle tables containing columns that are nested tables or defined types.default NumberSpecifies the ID of the destination for the archived redo logs.default ObjectWhen this field is set toTrue, AWS DMS only accesses the archived redo logs.default StringFor an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.default StringFor an Oracle source endpoint, your ASM server address.default StringFor an Oracle source endpoint, your ASM user name.default StringSpecifies whether the length of a character column is in bytes or in characters.default ObjectWhen set totrue, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.default ObjectWhen set totrue, this attribute specifies a parallel load whenuseDirectPathFullLoadis set toY.default ObjectSet this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.default ObjectSpecifies the IDs of one more destinations for one or more archived redo logs.default ObjectWhen set totrue, this attribute causes a task to fail if the actual size of an LOB column is greater than the specifiedLobMaxSize.default NumberSpecifies the number scale.default StringSet this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.default NumberSet this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).default NumberSet this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).default ObjectWhen set totrue, this attribute supports tablespace replication.default ObjectSet this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.default NumberSpecifies the number of seconds that the system waits before resending a query.default StringThe full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value inSecretsManagerSecret.default StringRequired only if your Oracle endpoint uses Advanced Storage Manager (ASM).default StringRequired only if your Oracle endpoint uses Advanced Storage Manager (ASM).default StringThe full ARN, partial ARN, or display name of theSecretsManagerSecretthat contains the Oracle endpoint connection details.default StringFor an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.default StringFor an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.default StringUse this attribute to convertSDO_GEOMETRYtoGEOJSONformat.default NumberUse this attribute to specify a time in minutes for the delay in standby sync.default ObjectSet this attribute totruein order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.default ObjectSet this attribute to True to capture change data using the Binary Reader utility.default ObjectSet this attribute to True to have AWS DMS use a direct path full load.default ObjectSet this attribute to True to capture change data using the Oracle LogMiner utility (the default).default StringSet this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.Methods inherited from interface software.amazon.jsii.JsiiSerializable
$jsii$toJson
-
Method Details
-
getAccessAlternateDirectly
Set this attribute tofalsein order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.This tells the DMS instance to not access redo logs through any specified path prefix replacement using direct file access.
Returns union: either
BooleanorIResolvable- See Also:
-
getAdditionalArchivedLogDestId
Set this attribute withArchivedLogDestIdin a primary/ standby setup.This attribute is useful in the case of a switchover. In this case, AWS DMS needs to know which destination to get archive redo logs from to read changes. This need arises because the previous primary instance is now a standby instance after switchover.
Although AWS DMS supports the use of the Oracle
RESETLOGSoption to open the database, never useRESETLOGSunless necessary. For additional information aboutRESETLOGS, see RMAN Data Repair Concepts in the Oracle Database Backup and Recovery User's Guide .- See Also:
-
getAddSupplementalLogging
Set this attribute to set up table-level supplemental logging for the Oracle database.This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
If you use this option, you still need to enable database-level supplemental logging.
Returns union: either
BooleanorIResolvable- See Also:
-
getAllowSelectNestedTables
Set this attribute totrueto enable replication of Oracle tables containing columns that are nested tables or defined types.Returns union: either
BooleanorIResolvable- See Also:
-
getArchivedLogDestId
Specifies the ID of the destination for the archived redo logs.This value should be the same as a number in the dest_id column of the v$archived_log view. If you work with an additional redo log destination, use the
AdditionalArchivedLogDestIdoption to specify the additional destination ID. Doing this improves performance by ensuring that the correct logs are accessed from the outset.- See Also:
-
getArchivedLogsOnly
When this field is set toTrue, AWS DMS only accesses the archived redo logs.If the archived redo logs are stored on Automatic Storage Management (ASM) only, the AWS DMS user account needs to be granted ASM privileges.
Returns union: either
BooleanorIResolvable- See Also:
-
getAsmPassword
For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.You can set this value from the
*asm_user_password*value. You set this value as part of the comma-separated value that you set to thePasswordrequest parameter when you create the endpoint to access transaction logs using Binary Reader. For more information, see Configuration for change data capture (CDC) on an Oracle source database .- See Also:
-
getAsmServer
For an Oracle source endpoint, your ASM server address.You can set this value from the
asm_servervalue. You setasm_serveras part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .- See Also:
-
getAsmUser
For an Oracle source endpoint, your ASM user name.You can set this value from the
asm_uservalue. You setasm_useras part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .- See Also:
-
getCharLengthSemantics
Specifies whether the length of a character column is in bytes or in characters.To indicate that the character column length is in characters, set this attribute to
CHAR. Otherwise, the character column length is in bytes.Example:
charLengthSemantics=CHAR;- See Also:
-
getDirectPathNoLog
When set totrue, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.Returns union: either
BooleanorIResolvable- See Also:
-
getDirectPathParallelLoad
When set totrue, this attribute specifies a parallel load whenuseDirectPathFullLoadis set toY.This attribute also only applies when you use the AWS DMS parallel load feature. Note that the target table cannot have any constraints or indexes.
Returns union: either
BooleanorIResolvable- See Also:
-
getEnableHomogenousTablespace
Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.Returns union: either
BooleanorIResolvable- See Also:
-
getExtraArchivedLogDestIds
Specifies the IDs of one more destinations for one or more archived redo logs.These IDs are the values of the
dest_idcolumn in thev$archived_logview. Use this setting with thearchivedLogDestIdextra connection attribute in a primary-to-single setup or a primary-to-multiple-standby setup.This setting is useful in a switchover when you use an Oracle Data Guard database as a source. In this case, AWS DMS needs information about what destination to get archive redo logs from to read changes. AWS DMS needs this because after the switchover the previous primary is a standby instance. For example, in a primary-to-single standby setup you might apply the following settings.
archivedLogDestId=1; ExtraArchivedLogDestIds=[2]In a primary-to-multiple-standby setup, you might apply the following settings.
archivedLogDestId=1; ExtraArchivedLogDestIds=[2,3,4]Although AWS DMS supports the use of the Oracle
RESETLOGSoption to open the database, never useRESETLOGSunless it's necessary. For more information aboutRESETLOGS, see RMAN Data Repair Concepts in the Oracle Database Backup and Recovery User's Guide .Returns union: either Listinvalid input: '<'
Number> orIResolvable- See Also:
-
getFailTasksOnLobTruncation
When set totrue, this attribute causes a task to fail if the actual size of an LOB column is greater than the specifiedLobMaxSize.If a task is set to limited LOB mode and this option is set to
true, the task fails instead of truncating the LOB data.Returns union: either
BooleanorIResolvable- See Also:
-
getNumberDatatypeScale
Specifies the number scale.You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
Example:
numberDataTypeScale=12- See Also:
-
getOraclePathPrefix
Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.This value specifies the default Oracle root used to access the redo logs.
- See Also:
-
getParallelAsmReadThreads
Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).You can specify an integer value between 2 (the default) and 8 (the maximum). Use this attribute together with the
readAheadBlocksattribute.- See Also:
-
getReadAheadBlocks
Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).You can specify an integer value between 1000 (the default) and 200,000 (the maximum).
- See Also:
-
getReadTableSpaceName
When set totrue, this attribute supports tablespace replication.Returns union: either
BooleanorIResolvable- See Also:
-
getReplacePathPrefix
Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.This setting tells DMS instance to replace the default Oracle root with the specified
usePathPrefixsetting to access the redo logs.Returns union: either
BooleanorIResolvable- See Also:
-
getRetryInterval
Specifies the number of seconds that the system waits before resending a query.Example:
retryInterval=6;- See Also:
-
getSecretsManagerAccessRoleArn
The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value inSecretsManagerSecret.The role must allow the
iam:PassRoleaction.SecretsManagerSecrethas the value of the AWS Secrets Manager secret that allows access to the Oracle endpoint.You can specify one of two sets of values for these permissions. You can specify the values for this setting and
SecretsManagerSecretId. Or you can specify clear-text values forUserName,Password,ServerName, andPort. You can't specify both.For more information on creating this
SecretsManagerSecret, the correspondingSecretsManagerAccessRoleArn, and theSecretsManagerSecretIdthat is required to access it, see Using secrets to access AWS Database Migration Service resources in the AWS Database Migration Service User Guide .- See Also:
-
getSecretsManagerOracleAsmAccessRoleArn
Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).The full ARN of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the
SecretsManagerOracleAsmSecret. ThisSecretsManagerOracleAsmSecrethas the secret value that allows access to the Oracle ASM of the endpoint.You can specify one of two sets of values for these permissions. You can specify the values for this setting and
SecretsManagerOracleAsmSecretId. Or you can specify clear-text values forAsmUser,AsmPassword, andAsmServerName. You can't specify both.For more information on creating this
SecretsManagerOracleAsmSecret, the correspondingSecretsManagerOracleAsmAccessRoleArn, and theSecretsManagerOracleAsmSecretIdthat is required to access it, see Using secrets to access AWS Database Migration Service resources in the AWS Database Migration Service User Guide .- See Also:
-
getSecretsManagerOracleAsmSecretId
Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).The full ARN, partial ARN, or display name of the
SecretsManagerOracleAsmSecretthat contains the Oracle ASM connection details for the Oracle endpoint.- See Also:
-
getSecretsManagerSecretId
The full ARN, partial ARN, or display name of theSecretsManagerSecretthat contains the Oracle endpoint connection details.- See Also:
-
getSecurityDbEncryption
For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.It is also the
*TDE_Password*part of the comma-separated value you set to thePasswordrequest parameter when you create the endpoint. TheSecurityDbEncryptiansetting is related to thisSecurityDbEncryptionNamesetting. For more information, see Supported encryption methods for using Oracle as a source for AWS DMS in the AWS Database Migration Service User Guide .- See Also:
-
getSecurityDbEncryptionName
For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.The key value is the value of the
SecurityDbEncryptionsetting. For more information on setting the key name value ofSecurityDbEncryptionName, see the information and example for setting thesecurityDbEncryptionNameextra connection attribute in Supported encryption methods for using Oracle as a source for AWS DMS in the AWS Database Migration Service User Guide .- See Also:
-
getSpatialDataOptionToGeoJsonFunctionName
Use this attribute to convertSDO_GEOMETRYtoGEOJSONformat.By default, DMS calls the
SDO2GEOJSONcustom function if present and accessible. Or you can create your own custom function that mimics the operation ofSDOGEOJSONand setSpatialDataOptionToGeoJsonFunctionNameto call it instead.- See Also:
-
getStandbyDelayTime
Use this attribute to specify a time in minutes for the delay in standby sync.If the source is an Oracle Active Data Guard standby database, use this attribute to specify the time lag between primary and standby databases.
In AWS DMS , you can create an Oracle CDC task that uses an Active Data Guard standby instance as a source for replicating ongoing changes. Doing this eliminates the need to connect to an active database that might be in production.
- See Also:
-
getUseAlternateFolderForOnline
Set this attribute totruein order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.This tells the DMS instance to use any specified prefix replacement to access all online redo logs.
Returns union: either
BooleanorIResolvable- See Also:
-
getUseBFile
Set this attribute to True to capture change data using the Binary Reader utility.Set
UseLogminerReaderto False to set this attribute to True. To use Binary Reader with Amazon RDS for Oracle as the source, you set additional attributes. For more information about using this setting with Oracle Automatic Storage Management (ASM), see Using Oracle LogMiner or AWS DMS Binary Reader for CDC .Returns union: either
BooleanorIResolvable- See Also:
-
getUseDirectPathFullLoad
Set this attribute to True to have AWS DMS use a direct path full load.Specify this value to use the direct path protocol in the Oracle Call Interface (OCI). By using this OCI protocol, you can bulk-load Oracle target tables during a full load.
Returns union: either
BooleanorIResolvable- See Also:
-
getUseLogminerReader
Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).Set this attribute to False if you want to access the redo logs as a binary file. When you set
UseLogminerReaderto False, also setUseBfileto True. For more information on this setting and using Oracle ASM, see Using Oracle LogMiner or AWS DMS Binary Reader for CDC in the AWS DMS User Guide .Returns union: either
BooleanorIResolvable- See Also:
-
getUsePathPrefix
Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.This value specifies the path prefix used to replace the default Oracle root to access the redo logs.
- See Also:
-
builder
-