F Zero Downtime Migration Logical Migration Response File Parameters Reference
Zero Downtime Migration response file parameters supported for logical migrations.
DATA_TRANSFER_MEDIUM
Specifies how data will be transferred from the source database system to the target database system.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
Yes |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_CREATEAUTHTOKEN
Indicates whether to create a new OCI Auth Token.
If you are not using a network database link for Data Pump Import, an OCI Auth Token is created for the specified OCI user to import Data Pump dump files from the Object Storage into an Autonomous Database.
To reuse an existing Auth Token, set this property to
FALSE
.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATABASELINKDETAILS_NAME
Specifies the name of the database link from the OCI database to the on-premise database.
Zero Downtime Migration creates the database link if the link does not already exist.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
The DATAPUMPSETTINGS_DATABASELINKDETAILS_*
parameters
are optional details for creating a network database link from OCI database to the
on-premise database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_BUCKETNAME
Specifies the OCI Object Storage bucket.
The DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_*
parameters are used with Autonomous Database migration targets. These parameters
settings specify the OCI Object Storage details used to store the wallet containing
the certificate for on-premise database to create a database link from the
Autonomous Database to the on-premise database using TLS.
Not required for a TCP connection from Autonomous Database to the on-premise database.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_NAMESPACENAME
Specifies the Object Storage namespace.
The DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_*
parameters are used with Autonomous Database migration targets. These parameters
settings specify the OCI Object Storage details used to store the wallet containing
the certificate for on-premise database to create a database link from the
Autonomous Database to the on-premise database using TLS.
Not required for a TCP connection from Autonomous Database to the on-premise database.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME
In lieu of a network database link, the OCI Object Storage bucket specified
in DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME
is used to store Data Pump dump
files for migrating to an Autonomous Database.
DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME
is one of the optional
settings for logical migrations using Data Pump.
Use with DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Enter the storage bucket name |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME
In lieu of a network database link, the OCI Object Storage bucket specified
with DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME
is used to store Data Pump
dump files for migrating to an Autonomous Database.
DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME
is one of the
optional settings for logical migrations using Data Pump.
Use with DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Enter the storage bucket namespace |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_ESTIMATEBYSTATISTICS
Specifies the STATISTICS method for Data Pump dump size estimation.
Zero Downtime Migration estimates the Data Pump dump size using the BLOCKS or STATISTICS methods. You are expected to apply discretion in arriving at the FILESYSTEM space required for the dump path, considering other factors that affect the actual dump size expected. The estimated dump size and actual size varies based on the data compression applied on the data in the database.
- If data is compressed, then it would be the same as that of the reported ESTIMATE
- If data is uncompressed, then Zero Downtime Migration exports with COMPRESSION set as MEDIUM and the resulting dump would be ~50% of estimate
- There is deviation in dump size expected between data having HCC vs. Advanced compression modes
Note that by default, Zero Downtime Migration performs estimation using
the BLOCKS method as part of the precheck and as part of the actual migration part
of phase ZDM_DATAPUMP_ESTIMATE_SRC
.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_TABLEEXISTSACTION
Specifies the action to be performed when data is loaded into a preexisting table.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
See |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_USERMETADATA
For EXPORT and Network IMPORT, if set to a nonzero value for schema-mode operations, specifies that the metadata to re-create the user's schemas should also be part of the operation.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETER_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE
Specifies the maximum number of worker processes that can be used for a Data Pump Import job.
For migration to an Autonomous Database target, Zero Downtime Migration automatically queries its CPU core count and sets this parameter.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE
Specifies the maximum number of worker processes that can be used for a Data Pump Import job.
For migration to an Autonomous Database target, Zero Downtime Migration automatically queries its CPU core count and sets this parameter.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXCLUDETYPELIST
Specifies a comma separated list of object types to exclude.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more
information.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default |
Valid values |
A comma separated list of object types |
Required |
No |
Modifiable on Resume |
No |
Example
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXCLUDETYPELIST=cluster,dblink,comment
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_SKIPCURRENT
Specifies whether actions that were "in progress" on a previous execution of the job are skipped when the job restarts.
This mechanism allows you to skip actions that trigger fatal bugs and cause the premature termination of a job. Multiple actions can be skipped on a restart. The log file identifies which actions are skipped.
The skip is only honored for Import jobs.
If a domain index was being processed, all pieces of the domain index are skipped, even if the error only occurred in a sub-component of the domain index.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more
information.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable in Resume |
Until |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER
Specifies whether all Data Pump workers are started on the current instance or on instances usable by the job.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more
information.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_RETAININDEX
Specifies whether to retain the index.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
DATAPUMPSETTINGS_DATAPUMPPARAMETERS_*
are optional
parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more
information.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_DELETEDUMPSINOSS
Indicates whether to retain dump files which are uploaded to Object Storage as part of the migration.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME
Specifies the object name of a directory on server file system of an on-premises database.
In lieu of a network database link, a directory on the server file system of an
on-premises database, specified with the
DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_*
properties is used to
store Data Pump Export dump files.
Zero Downtime Migration creates this object if it does not already exist
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Name of directory object in the database. |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH
Specifies the object path of a directory on server file system of an on-premises database.
In lieu of a network database link, a directory on the server file system of an
on-premises database, specified with the
DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_*
properties is used to
store Data Pump Export dump files.
Zero Downtime Migration creates this object if it does not already exist
Note:
For Oracle Database 19c and later releases, theUTL_FILE_DIR
initialization parameter is desupported, which means symbolic links for Data Pump
directories are not supported.
If you attempt to use an affected feature configured with symbolic links, then you encounter ORA-29283: invalid file operation: path traverses a symlink. Oracle recommends that you instead use directory objects in place of symbolic links.
See How Does Oracle Data Pump Move Data? for more information.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Absolute path of directory on database server |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_FIXINVALIDOBJECTS
Specifies whether invalid objects are recompiled in the database as part of the migration job.
Migration can result in invalid schema objects. Typically, invalid objects fix themselves as they are accessed or run. However, Oracle recommends that invalid objects are recompiled in the database as part of the Zero Downtime Migration migration job so that issues with invalid objects, and any required dependencies, are resolved before users encounter these invalid objects.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH
Specifies the path of an import directory object.
In lieu of a network database link, a directory on the server file system of OCI database is used to store Data Pump dump files.
Zero Downtime Migration creates this object if it does not already exist.
For Autonomous Database migration targets, the
DATA_PUMP_DIR
object will already exist.
Note:
For Oracle Database 19c and later releases, theUTL_FILE_DIR
initialization parameter is desupported, which means symbolic links for Data Pump
directories are not supported.
If you attempt to use an affected feature configured with symbolic links, then you encounter ORA-29283: invalid file operation: path traverses a symlink. Oracle recommends that you instead use directory objects in place of symbolic links.
See How Does Oracle Data Pump Move Data? for more information.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Absolute path of directory on database server |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME
Specifies the name of an import directory object.
In lieu of a network database link, a directory on the server file system of OCI database is used to store Data Pump dump files.
Zero Downtime Migration creates this object if it does not already exist.
For Autonomous Database migration targets, the
DATA_PUMP_DIR
object will already exist.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Name of directory object in database |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_JOBMODE
Specifies the Data Pump export mode.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Usage
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
See Oracle Data Pump Export Modes for more information. |
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_METADATAFILTERS-LIST_ELEMENT_NUMBER
Defines the name, the object type, and the value of the filter for the Data
Pump METADATA_FILTER
property.
To add multiple filters, increment the integer appended to the parameter name, as shown in the examples below.
DATAPUMPSETTINGS_METADATAFILTERS-1=name:nameValue1st, objectType:objectTypeValue1st, value:valueValue1st
DATAPUMPSETTINGS_METADATAFILTERS-2=name:nameValue2nd, objectType:objectTypeValue2nd, value:valueValue2nd
To exclude select SCHEMA
Objects for FULL
mode:
DATAPUMPSETTINGS_METADATAFILTERS-1=name:NAME_EXPR,value:'NOT IN(' 'SYSMAN' ')',objectType:SCHEMA
DATAPUMPSETTINGS_METADATAFILTERS-2=name:NAME_EXPR,value:'NOT IN(' 'SH' ')',objectType:SCHEMA
Note that the SCHEMA
name SYSMAN
is surrounded by
two single quotes and not a double quote.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
An entry specifying the name, type, and value is expected, as shown in the examples above. |
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_METADATAREMAPS-LIST_ELEMENT_NUMBER
Defines remapping to be applied to objects as they are processed.
To add multiple remappings, increment the integer appended to the parameter name, as shown in the examples below.
DATAPUMPSETTINGS_METADATAREMAPS-1=type:typeValue1st, oldValue:oldValueValue1st, newValue:newValueValue1st
DATAPUMPSETTINGS_METADATAREMAPS-2=type:typeValue2nd, oldValue:oldValueValue2nd, newValue:newValueValue2nd
See METADATA_REMAP Procedure for more information.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
An entry specifying the new value, old value and type is expected, as shown in the examples above. |
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_METADATATRANSFORMS-LIST_ELEMENT_NUMBER
Defines the name, the object type, and the value for the Data Pump
METADATA_TRANSFORM
property.
To add multiple filters, increment the integer appended to the parameter name, as shown in the examples below.
DATAPUMPSETTINGS_METADATATRANSFORMS-1=name:nameValue1st, objectType:objectTypeValue1st, value:valueValue1st
DATAPUMPSETTINGS_METADATATRANSFORMS-2=name:nameValue2nd, objectType:objectTypeValue2nd, value:valueValue2nd
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
An entry specifying the name, type, and value is expected, as shown in the examples above. |
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_MONITORINTERVALMINUTES
Specifies the Data Pump monitor interval in minutes. This setting is optional.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
10 |
Range of values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_OMITENCRYPTIONCLAUSE
Sets TRANSFORM=OMIT_ENCRYPTION_CLAUSE
, which directs Data
Pump to suppress any encryption clauses associated with objects using encrypted
columns.
This parameter is valid for targets on Oracle Database 19c and later releases.
OMIT_ENCRYPTION_CLAUSE
applies to materialized view, table, and
tablespace objects, and enables objects which were using encrypted columns in the
source to get created in a target database environment where encryption attributes
are not supported.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_SECUREFILELOB
Sets TRANSFORM=LOB_STORAGE:SECUREFILE
, which directs Data
Pump to transform basic LOBs into securefile LOBs during the Data Pump import.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
No |
DATAPUMPSETTINGS_SCHEMABATCHCOUNT
Specifies the number of schemas to be processed in parallel as batches.
When DATAPUMPSETTINGS_JOBMODE=SCHEMA
you can specify the number of
schemas to be migrated in parallel. If this count is specified, then Zero Downtime
Migration determines the set of schemas included in each batch from the list of user
schemas identified from the database.
DATAPUMPSETTINGS_SCHEMABATCHCOUNT
is mutually exclusive with the
DATAPUMPSETTINGS_SCHEMABATCH
parameter.
Note:
Database initialization parameterMAX_DATAPUMP_JOBS_PER_PDB
determines the maximum number of concurrent Oracle Data Pump jobs for each
PDB.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
An integer equal to or less than database initialization parameter
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_SCHEMABATCH-LIST_ELEMENT_NUMBER
Specifies which schemas are batched together to be migrated in parallel.
When DATAPUMPSETTINGS_JOBMODE=SCHEMA
you can specify
which schemas are migrated together in parallel as a batch. Increment the -LIST_ELEMENT_NUMBER value to differentiate the
batches.
In this example there are two batches, each containing two schemas that are migrated in parallel.
DATAPUMPSETTINGS_SCHEMABATCH-1=n1,n2
DATAPUMPSETTINGS_SCHEMABATCH-2=n3,n4
DATAPUMPSETTINGS_SCHEMABATCH
is mutually exclusive with the
DATAPUMPSETTINGS_SCHEMABATCHCOUNT
parameter.
Note:
Database initialization parameterMAX_DATAPUMP_JOBS_PER_PDB
determines the maximum number of
concurrent Oracle Data Pump jobs for each PDB.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value. |
Range of values |
LIST_ELEMENT_NUMBER must be a unique integer value for each batch specified
|
Required |
No |
Modifiable on Resume |
Until |
DATAPUMPSETTINGS_SKIPDEFAULTTRANSFORM
Skips default transform parameters.
Set this property to TRUE
to avoid all internal Zero Downtime
Migration transform defaults.
Parameter Relationships
The optional DATAPUMPSETTINGS_*
parameters let you customize Oracle
Data Pump Export and Import jobs.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
No |
DUMPTRANSFERDETAILS_PARALLELCOUNT
Specifies the maximum number of Export dump files to transfer to Object Storage or remote node in parallel.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details
to transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
Property | Description |
---|---|
Syntax |
|
Default value |
3 |
Range of values |
This parameter accepts integer values |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_RETRYCOUNT
Specifies the number of times to retry upload or transfer of dump failure.
Intermittent network failures observed during the transfer of Data Pump
dumps can mitigated by setting the DUMPTRANSFERDETAILS_RETRYCOUNT
parameter.
Parameter Relationships
The DUMPTRANSFERDETAILS
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
Property | Description |
---|---|
Syntax |
|
Default value |
3 |
Range of values |
This parameter accepts integer values |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_RSYNCAVAILABLE
Specifies that the transfer dump files are using the Linux rsync utility.
Ensure rsync is installed in both source and target servers. Oracle Exadata does not ship with rsync, refer to MOS Doc ID 1556257.1 for details. ZDM defaults to scp command for transfer.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_S3BUCKET_ACCESSKEY
Specifies the access key of the Amazon Simple Storage Service (Amazon S3) bucket.
When you set DATA_TRANSFER_MEDIUM=AMAZON3
to migrate an Amazon Web
Services RDS Oracle database to Oracle Autonomous Database using an S3 bucket, you
must also set the DUMPTRANSFERDETAILS_S3BUCKET_*
parameters.
See Migrating from Amazon Web Services RDS to Oracle Autonomous Database for details.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details
to transfer dumps from the source node to the target node.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_S3BUCKET_NAME
Specifies the name of the Amazon Simple Storage Service (Amazon S3) bucket.
When you set DATA_TRANSFER_MEDIUM=AMAZON3
to migrate an Amazon Web
Services RDS Oracle database to Oracle Autonomous Database using an S3 bucket, you
must also set the DUMPTRANSFERDETAILS_S3BUCKET_*
parameters.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_S3BUCKET_REGION
Specifies the region of the Amazon Simple Storage Service (Amazon S3) bucket.
When you set DATA_TRANSFER_MEDIUM=AMAZON3
to migrate an Amazon Web
Services RDS Oracle database to Oracle Autonomous Database using an S3 bucket, you
must also set the DUMPTRANSFERDETAILS_S3BUCKET_*
parameters.
See Migrating from Amazon Web Services RDS to Oracle Autonomous Database for details.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_OCIHOME
Specifies the Oracle Cloud OCI-CLI Binary path.
Parameter Relationships
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_PARTSIZEMB
Specifies the part size in MB for chunked transfer.
Parameter Relationships
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_DUMPDIRPATH
Specifies the absolute path of the directory to copy or upload dump files.
The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node. Supported modes of transfer
are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or
Curl.
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_HOST
Specifies the dump transfer node host name.
The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node. Supported modes of transfer
are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or
Curl.
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_SUDOPATH
Specifies the Sudo path on the dump transfer node.
The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node. Supported modes of transfer
are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or
Curl.
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USER
Specifies the user allowed to execute OCI CLI in the dump transfer node.
The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USERKEY
Specifies the user's authentication key.
The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node. Supported modes of transfer
are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or
Curl.
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_SOURCE_USEOCICLI
Indicates that transfer dump files use Oracle Cloud Infrastructure command line interface (CLI).
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_SOURCE_*
parameters specify
details to upload the Dump files from source node Data Pump dump location to Oracle
Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_OCIHOME
Specifies the Oracle Cloud Infrastructure command line interface (CLI) Binary path.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_PARTSIZEMB
Specifies the part size in MB for chunked transfer.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_DUMPDIRPATH
Specifies the absolute path of the directory to copy or upload dump files.
The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using the OCI CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_HOST
Specifies the dump transfer node host name.
The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_SUDOPATH
Specifies the Sudo path on the dump transfer node.
The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USER
Specifies the user allowed to execute OCI CLI in the dump transfer node.
The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node. Supported modes of transfer
are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud
Infrastructure command line interface (CLI) or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USERKEY
Specifies the user's authentication key.
The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_*
parameters are configured when you use a standalone server as transfer server.
Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.
This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TARGET_USEOCICLI
Indicates that transfer dump files use Oracle Cloud Infrastructure command line interface (CLI).
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TARGET_*
parameters specify
details to download the Dump files to the target node Data Pump dump location from
Oracle Cloud Object Storage.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TRANSFERTARGET_DUMPDIRPATH
Specifies the absolute path of the directory to copy or upload dump files.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TRANSFERTARGET_*
parameters
specify details for the target node to copy the Dump files from source node Data
Pump dump location or transfer node directory path specified. Default target
database host.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TRANSFERTARGET_HOST
DUMPTRANSFERDETAILS_TRANSFERTARGET_HOST
specifies the dump
transfer node host name.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TRANSFERTARGET_*
parameters
specify details for the target node to copy the Dump files from source node Data
Pump dump location or transfer node directory path specified. Default target
database host.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TRANSFERTARGET_SUDOPATH
Specifies the Sudo path on the dump transfer node.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TRANSFERTARGET_*
parameters
specify details for the target node to copy the Dump files from source node Data
Pump dump location or transfer node directory path specified. Default target
database host.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TRANSFERTARGET_USER
Specifies the host user name that has write permission to the indicated dump storage path.
The user specified in
DUMPTRANSFERDETAILS_TRANSFERTARGET_USER
should be allowed
to
-
Execute OCI CLI in the specified host to download the dumps from the Object Storage bucket if
DATA_TRANSFER_MEDIUM=OSS
-
Copy the dump files from the source node to the target host specified if
DATA_TRANSFER_MEDIUM=COPY
.
See Configuring the Transfer Medium and Specifying Transfer Nodes for more information about configuring the dump transfer details parameters.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TRANSFERTARGET_*
parameters
specify details for the target node to copy the Dump files from source node Data
Pump dump location or transfer node directory path specified. Default target
database host.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Required |
No |
Modifiable on Resume |
Until |
DUMPTRANSFERDETAILS_TRANSFERTARGET_USERKEY
Specifies the user's authentication key.
Parameter Relationships
The DUMPTRANSFERDETAILS_*
parameters specify details to
transfer dumps from the source node to the target node.
Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.
The DUMPTRANSFERDETAILS_TRANSFERTARGET_*
parameters
specify details for the target node to copy the Dump files from source node Data
Pump dump location or transfer node directory path specified. Default target
database host.
Property | Description |
---|---|
Syntax |
|
Default value |
No default value |
Range of values |
A string value is expected |
Required |
No |
Modifiable on Resume |
Until |
EXCLUDEOBJECTS-LIST_ELEMENT_NUMBER
Specifies database objects to exclude from migration.
To exclude multiple objects, increment the integer appended to the parameter name, as shown in the examples below.
EXCLUDEOBJECTS-1=owner:ownerValue1,
objectName:objectNameValue1,
objectType:objectTypeValue1
EXCLUDEOBJECTS-2=owner:ownerValue2,
objectName:objectNameValue2,
objectType:objectTypeValue2
See Selecting Objects for Migration for more information about using EXCLUDEOBJECTS
.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value. |
Range of values |
An entry specifying the owner, object name, and object type is expected, as shown in the examples above. |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATEHUB_ADMINUSERNAME
Specifies the GoldenGate hub administrator user name.
Parameter Relationships
For online logical migration, you must set the
GOLDENGATEHUB_*
parameters to provide Zero Downtime Migration
with details about Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Oracle GoldenGate hub's administrator user name |
Required |
No* *Required for online logical migration |
Modifiable on Resume |
Until |
GOLDENGATEHUB_COMPUTEID
Specifies the Oracle Cloud identifier of the VM.
Parameter Relationships
For online logical migration, you must set the
GOLDENGATEHUB_*
parameters to provide Zero Downtime Migration
with details about Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Oracle Cloud identifier of the VM |
Required |
No* *Required for online logical migration |
Modifiable on Resume |
Until |
GOLDENGATEHUB_SOURCEDEPLOYMENTNAME
Specifies the name of the GoldenGate Microservices deployment to operate on the source database.
Parameter Relationships
For online logical migrations, you must set the GOLDENGATEHUB
parameters to provide Zero Downtime Migration with details about Oracle GoldenGate
Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Name of the GoldenGate Microservices deployment to operate on the source database |
Required |
No* *Required for online logical migration |
Modifiable on Resume |
Until |
GOLDENGATEHUB_TARGETDEPLOYMENTNAME
Specifies the name of the GoldenGate Microservices deployment to operate on the target database.
Parameter Relationships
For online logical migrations, you must set the GOLDENGATEHUB
parameters to provide Zero Downtime Migration with details about Oracle GoldenGate
Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Name of the GoldenGate Microservices deployment to operate on the target database |
Required |
No* *Required for online logical migration |
Modifiable on Resume |
Until |
GOLDENGATEHUB_URL
Specifies the Oracle GoldenGate hub's REST endpoint.
Parameter Relationships
For online logical migrations, you must set the GOLDENGATEHUB
parameters to provide Zero Downtime Migration with details about Oracle GoldenGate
Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
Oracle GoldenGate hub's REST endpoint |
Required |
No* *Required for online logical migration |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_ACCEPTABLELAG
Specifies GoldenGate end-to-end latency lag time
GOLDENGATESETTINGS_ACCEPTABLELAG
.
Parameter Relationships
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
30 seconds |
Required |
No |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_EXTRACT_PERFORMANCEPROFILE
Tunes Oracle GoldenGate Integrated Capture.
Use this setting to automatically configure relevant parameters to achieve the desired throughput and latency.
Parameter Relationships
The GOLDENGATESETTINGS_EXTRACT_*
parameters define
settings for the Integrated Extract process.
Only one Extract can be configured.
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Valid values |
|
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_CHECKINTERVAL
Specifies the frequency in seconds with which Oracle GoldenGate checks for long-running transactions.
Parameter Relationships
GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_*
parameters
specify a length of time in seconds that a transaction can be open before Extract
generates a warning message that the transaction is long-running.
The GOLDENGATESETTINGS_EXTRACT_*
parameters define
settings for the Integrated Extract process.
Only one Extract can be configured.
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_DURATION
Specifies a length of time in seconds that a transaction can be open before the GoldenGate Extract process generates a warning message that the transaction is long-running.
Parameter Relationships
GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_*
parameters
specify a length of time in seconds that a transaction can be open before Extract
generates a warning message that the transaction is long-running.
The GOLDENGATESETTINGS_EXTRACT_*
parameters define
settings for the Integrated Extract process.
Only one Extract can be configured.
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_REPLICAT_MAPPARALLELISM
Specifies the number of threads used to read GoldenGate trail files.
Valid for Parallel Replicat.
Parameter Relationships
The GOLDENGATESETTINGS_REPLICAT_*
parameters define
settings for the Parallel Replicat process.
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
4 |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_REPLICAT_MAXAPPLYPARALLELISM
Defines the range in which the GoldenGate Replicat automatically adjusts its apply parallelism.
Valid for Parallel Replicat.
Parameter Relationships
The GOLDENGATESETTINGS_REPLICAT_*
parameters define
settings for the Parallel Replicat process.
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
50 |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_REPLICAT_MINAPPLYPARALLELISM
Defines the range in which the GoldenGate Replicat automatically adjusts its apply parallelism.
Valid for Parallel Replicat.
Parameter Relationships
The GOLDENGATESETTINGS_REPLICAT_*
parameters define
settings for the Parallel Replicat process.
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
4 |
Valid values |
An integer value is expected |
Required |
No |
Modifiable on Resume |
Until |
GOLDENGATESETTINGS_REPLICATEDDL
Specifies whether to set
Oracle GoldenGate Extract parameter DDLOPTIONS
CAPTUREGLOBALTEMPTABLE
.
DDL replication: If you set parameter GOLDENGATESETTINGS_REPLICATEDDL
= TRUE
, then Zero Downtime Migration sets Oracle GodenGate Extract
parameter DDLOPTIONS CAPTUREGLOBALTEMPTABLE
.
Note:
Zero Downtime Migration 21.3 users must apply Patch 33509650: ZDM PATCH USING MOS to use this feature.Parameter Relationships
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Required |
No |
Modifiable on Resume |
GOLDENGATESETTINGS_USEFLASHBACKQUERY
Specifies whether to set Oracle GoldenGate Extract parameters that allow ID KEY support mode objects to be replicated.
If you set parameter GOLDENGATESETTINGS_USEFLASHBACKQUERY = TRUE
,
Zero Downtime Migration sets the following Oracle GoldenGate Extract parameters that
allow ID KEY support mode objects to be replicated.
Note:
Zero Downtime Migration 21.3 users must apply Patch 33509650: ZDM PATCH USING MOS to use this feature.Parameter Relationships
For online logical migrations, you can set the optional
GOLDENGATESETTINGS_*
parameters to provide Zero Downtime
Migration with details about the Oracle GoldenGate Microservices configuration.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Required |
No |
Modifiable on Resume |
INCLUDEOBJECTS-LIST_ELEMENT_NUMBER
Specifies database objects to include for migration.
To include multiple objects, increment the integer appended to the parameter name, as shown in the examples below.
INCLUDEOBJECTS-1=owner:ownerValue1,
objectName:objectNameValue1,
objectType:objectTypeValue1
INCLUDEOBJECTS-2=owner:ownerValue2,
objectName:objectNameValue2,
objectType:objectTypeValue2
See Selecting Objects for Migration for more information about using INCLUDEOBJECTS
.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Range of values |
An entry specifying the owner, object name, and object type is expected, as shown in the examples above. |
Required |
No |
Modifiable on Resume |
Until |
MIGRATION_METHOD
In a logical migration, specifies whether the migration is online logical or offline logical
The required MIGRATION_METHOD
parameter specifies whether the
migration is online (Data Pump with Oracle GoldenGate replication) or offline (Data
Pump only).
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
Yes |
Modifiable on Resume |
No |
OCIAUTHENTICATIONDETAILS_REGIONID
Specifies the OCI region identifier.
See the Region Identifier column in the table at Regions and Availability Domains.
Parameter Relationships
To call REST APIs, you must configure the
OCIAUTHENTICATIONDETAILS_*
parameters.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
Yes |
OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT
Specifies the fingerprint of the public API key.
See Required Keys and OCIDs for more information.
Parameter Relationships
To call REST APIs, you must configure the
OCIAUTHENTICATIONDETAILS_*
parameters.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
Yes |
OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE
Specifies the absolute path of API private key file.
See Required Keys and OCIDs for more information.
Parameter Relationships
To call REST APIs, you must configure the
OCIAUTHENTICATIONDETAILS_*
parameters.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
Yes |
OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID
Specifies the OCID of the OCI tenancy.
You can find the tenant OCID on OCI at Governance and Administration, Administration, Tenancy Details. The tenancy OCID is shown under Tenancy Information.
Example: ocid1.tenancy.oc1..aaaaaaaaba3pv6wkcr4jqae5f44n2b2m2yt2j6rx32uzr4h25vqstifsfdsq
See Managing the Tenancy and Required Keys and OCIDs for more information.
Parameter Relationships
To call OCI REST APIs, you must configure the
OCIAUTHENTICATIONDETAILS_*
parameters.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
A string value is expected |
Required |
Yes |
Modifiable on Resume |
Yes |
OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID
Specifies the OCID of the IAM user.
You can find the IAM OCID on OCI at Console, Profile, User Settings.
See Managing Users and Required Keys and OCIDs for more information.
Parameter Relationships
To call OCI REST APIs, you must configure the
OCIAUTHENTICATIONDETAILS_*
parameters.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
Yes |
OCIPROXY_HOSTNAME
Specifies the HTTP proxy host name.
Parameter Relationships
The OCIPROXY_*
parameters specify details about the
proxy for connecting to OCI REST endpoints.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
OCIPROXY_PORT
Specifies the HTTP proxy port number.
Parameter Relationships
The OCIPROXY_*
parameters specify details about the
proxy for connecting to OCI REST endpoints.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
RUNCPATREMOTELY
Specifies whether Cloud Premigration Advisor Tool (CPAT) should run on the Zero Downtime Migration service host with a remote connection to the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
No |
SOURCECONTAINERDATABASE_ADMINUSERNAME
Specifies the source CDB administrator user name.
Parameter Relationships
For online logical migrations, the SOURCECONTAINERDATABASE_*
parameters specify connection details for the source database CDB root.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
No |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE
Specifies the identity file to access the bastion, as part of the database connection details for bastion-based access to the database.
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB.
The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_*
parameters specify details for bastion based access to the database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP
Specifies the IP address of the source CDB bastion host, as part of the database connection details for bastion-based access to the database.
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_*
parameters specify details for bastion based access to the database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT
Specifies the bastion host port, as part of the database connection details for bastion-based access to the container database (CDB).
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_*
parameters specify details for bastion based access to the database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP
Specifies the remote host IP address to access from the bastion, as part of the database connection details for bastion-based access to the container database (CDB).
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_*
parameters specify details for bastion based access to the database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME
Specifies the user name to access the bastion, as part of the database connection details for bastion-based access to the container database (CDB).
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_*
parameters specify details for bastion based access to the database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_HOST
Specifies the listener host name or IP address for the source container database (CDB).
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required for migrations to Autonomous Database. |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PORT
Specifies the listener port number for the source container database (CDB).
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required for migrations to Autonomous Database. |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME
Specifies the HTTPS proxy host name for the CDB.
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_*
parameters specify connection details for the source CDB root through an HTTP
proxy.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT
Specifies the HTTPS proxy host port number for the CDB.
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_*
parameters specify connection details for the source CDB root through an HTTP
proxy.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_SERVICENAME
Specifies the fully qualified source CDB service name.
Parameter Relationships
For online logical migrations, the SOURCECONTAINERDATABASE_*
parameters specify connection details for the source database CDB root.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required for Autonomous Database |
Modifiable on Resume |
No |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION
Specifies the directory containing client credentials (wallet, keystore, trustfile, etc.) for the CDB.
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_*
parameters specify details for TLS connection to the database CDB. These settings
are not required if you are using TCP.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required for Autonomous Database Not required if you are using TCP |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME
Specifies the distinguished name (DN) of the database server
(SSL_SERVER_CERT_DN
).
Parameter Relationships
For online logical migrations, the
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_*
parameters specify
connection details for the source CDB root.
The
SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_*
parameters specify details for TLS connection to the CDB. These settings are not
required if you are using TCP.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required for Autonomous Database Not required if you are using TCP |
Modifiable on Resume |
Yes |
SOURCECONTAINERDATABASE_GGADMINUSERNAME
Specifies the source CDB GoldenGate administrator user name.
Parameter Relationships
For online logical migrations, the SOURCECONTAINERDATABASE_*
parameters specify connection details for the source database CDB root.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
No |
SOURCEDATABASE_ADMINUSERNAME
Specifies the source database administrator user name.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
No |
SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE
Specifies the identity file to access the bastion for bastion-based access to the database.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP
Specifies the IP address of the bastion host for bastion-based access to the database.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT
Specifies the port number of the bastion host for bastion-based access to the database.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP
Specifies the remote host IP address to access from the bastion for bastion-based access to the database.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME
Specifies the user name to access the bastion for bastion-based access to the database.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_HOST
Specifies the source database listener host name or IP address.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes* *Not required for Autonomous Database. |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_PORT
Specifies the source database listener port number.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes* *Not required for Autonomous Database. |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME
Specifies the proxy host name to connect to the source database through an HTTPS proxy.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT
Specifies the HTTP proxy port number to connect to the source database through an HTTPS proxy.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS
parameters specify
connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME
Specifies the source database fully qualified service name.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes* *Not required for Autonomous Database |
Modifiable on Resume |
No |
SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION
Specifies the directory containing client credentials (wallet, keystore, trustfile, etc.) for a TLS connection to the database.
Parameter Relationships
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required if using TCP Not required for Autonomous Database |
Modifiable on Resume |
Yes |
SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME
Specifies the distinguished name (DN) of the database server
(SSL_SERVER_CERT_DN
) for a TLS connection to the database.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
The SOURCEDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs Not required if using TCP Not required for Autonomous Database |
Modifiable on Resume |
Yes |
SOURCEDATABASE_ENVIRONMENT_DBTYPE
Indicates the type of database to migrate from the specified environment.
If you specify that the source database environment is Amazon Web
Services RDS by setting SOURCEDATABASE_ENVIRONMENT_NAME=AMAZON
,
then you must also set
SOURCEDATABASE_ENVIRONMENT_DBTYPE=RDS_ORACLE
.
See Migrating from Amazon Web Services RDS to Oracle Autonomous Database.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Required |
No |
Modifiable on Resume |
No |
SOURCEDATABASE_ENVIRONMENT_NAME
Specifies the environment of the source database.
You can specify whether the source database environment is Oracle
(ORACLE
) or Amazon Web Services RDS
(AMAZON
).
If you set SOURCEDATABASE_ENVIRONMENT_NAME=AMAZON
you must also set
SOURCEDATABASE_ENVIRONMENT_DBTYPE=RDS_ORACLE
. See Migrating from Amazon Web Services RDS to Oracle Autonomous
Database.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
|
Required |
No |
Modifiable on Resume |
No |
SOURCEDATABASE_GGADMINUSERNAME
Specifies the GoldenGate administrator user name for online logical migrations.
Parameter Relationships
The SOURCEDATABASE_*
parameters specify connection
details for the source database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
No |
TABLESPACEDETAILS_AUTOCREATE
Specifies whether Zero Downtime Migration automatically creates tablespaces at the target database necessary to allocate space in the database to contain schema objects.
This option is prohibited for Autonomous Database Shared targets.
See Automatic Tablespace Creation for more information.
Parameter Relationships
In a logical migration, the TABLESPACEDETAILS_*
parameters specify details that allow Zero Downtime Migration to automatically
create the required tablespaces at target database..
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No This option is prohibited for Autonomous Database Shared targets. |
Modifiable on Resume |
Until |
TABLESPACEDETAILS_AUTOREMAP
Specifies whether Zero Downtime Migration automatically remaps a tablespace at the target database.
See Automatic Tablespace Remap for more information.
Parameter Relationships
In a logical migration, the TABLESPACEDETAILS_*
parameters specify details that allow Zero Downtime Migration to automatically
create the required tablespaces at target database..
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
TABLESPACEDETAILS_EXCLUDE
Specifies tablespaces to be excluded from automatic creation at the target database.
See Automatic Tablespace Creation for more information.
Example
TABLESPACEDETAILS_EXCLUDE='B2B_LOB_TS','B2B_HR_TS'
Parameter Relationships
In a logical migration, the TABLESPACEDETAILS_*
parameters specify details that allow Zero Downtime Migration to automatically
create the required tablespaces at target database..
Property | Description |
---|---|
Syntax |
|
Default value |
By default SYSTEM, SYSAUX, and USERS tablespaces are excluded. |
Required |
No |
Modifiable on Resume |
Until |
TABLESPACEDETAILS_EXTENDSIZEMB
Specifies an extend size for AUTOEXTEND
in support of
automatic tablespace creation.
Properly setting TABLESPACEDETAILS_EXTENDSIZEMB
enables
AUTOEXTEND
to avoid extend errors when automatic tablespace
creation is enabled.
See Automatic Tablespace Creation for more information.
Parameter Relationships
In a logical migration, the TABLESPACEDETAILS_*
parameters specify details that allow Zero Downtime Migration to automatically
create the required tablespaces at target database..
Property | Description |
---|---|
Syntax |
|
Default value |
|
Required |
No |
Modifiable on Resume |
Until |
TABLESPACEDETAILS_REMAPTARGET
Specifies tablespaces to be remapped.
For a tablespace to be used as REMAP target, the user performing the import
operation, for example SYSTEM
, should have some quota on the chosen
tablespace.
See Automatic Tablespace Remap for more information.
Parameter Relationships
In a logical migration, the TABLESPACEDETAILS_*
parameters specify details that allow Zero Downtime Migration to automatically
create the required tablespaces at target database..
Property | Description |
---|---|
Syntax |
|
Default value |
By default the DATA tablespace is remapped. |
Required |
No |
Modifiable on Resume |
Until |
TABLESPACEDETAILS_USEBIGFILE
Specifies whether to use bigfile tablespaces, if Zero Downtime Migration is configured to create tablespaces automatically.
Using bigfile tablespaces, which can be up to 128 TB, significantly reduces the number of data files for your database. Combined with Oracle Managed Files (OMF), bigfile tablespaces simplify data file management.
See Automatic Tablespace Creation for more information.
Parameter Relationships
In a logical migration, the TABLESPACEDETAILS_*
parameters specify details that allow Zero Downtime Migration to automatically
create the required tablespaces at target database..
Property | Description |
---|---|
Syntax |
|
Default value |
|
Range of values |
|
Required |
No |
Modifiable on Resume |
Until |
TARGETDATABASE_ADMINUSERNAME
Specifies the target database administrator user name.
Parameter Relationships
The TARGETDATABASE_*
parameters specify connection
details for the target OCI database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
No |
TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE
Specifies the identity file to access the bastion for bastion-based access to the target database.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migration jobs |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP
Specifies the IP address of the bastion host for bastion-based access to database.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT
Specifies the port number of the bastion host for bastion-based access to database.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP
Specifies the remote host IP address to access from the bastion for bastion-based access to database.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME
Specifies the user name to access the bastion for bastion-based access to database.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_HOST
Specifies the listener host name or IP address.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS
parameters specify
connection details for the target OCI database.
These properties are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_PORT
Specifies the listener port number.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME
Specifies the proxy host name for connecting to the target database through an HTTPS proxy.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT
Specifies the HTTP proxy port number for connecting to the source database through an HTTPS proxy.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME
Specifies the fully qualified service name.
This parameter is optional for Autonomous Database targets; however if an HTTP proxy is required to connect, specify it.
In addition, for Oracle Autonomous Database Dedicated Infrastructure and Autonomous Database on Cloud@Customer with fractional OCPU service you must specify the appropriate service alias in the parameter.
You can specify any predefined fractional service alias available; however, for Autonomous Transaction Processing workloads TP* services are preferred over LOW* services because LOW* is meant for low priority batch jobs.
TP_TLS
,TP
,LOW_TLS
, orLOW
(for Autonomous Transaction Processing workloads)LOW_TLS
orLOW
(for Autonomous Data Warehouse workloads)
See also Connecting to a DB System and About Connecting to a Dedicated Autonomous Database
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters specify connection
details for the target OCI database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Valid values |
For non-Autonomous, specify the fully qualified service name. For Autonomous, you can specify the service alias for fractional OCPU service as:
|
Required |
No |
Modifiable on Resume |
No |
TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION
Specifies the directory containing client credentials (wallet, keystore, trustfile, etc.) for a TLS connection.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migrations Not required if using TCP |
Modifiable on Resume |
Yes |
TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME
Specifies the distinguished name (DN) of the database server
(SSL_SERVER_CERT_DN
) for a TLS connection.
Parameter Relationships
The TARGETDATABASE_CONNECTIONDETAILS_*
parameters
specify connection details for the target OCI database.
These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Not mandatory for migrations Not required if using TCP |
Modifiable on Resume |
Yes |
TARGETDATABASE_GGADMINUSERNAME
Specifies the GoldenGate administrator user name for online logical migrations.
Parameter Relationships
The TARGETDATABASE_*
parameters specify connection
details for the target OCI database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
No |
TARGETDATABASE_OCID
Specifies the Oracle Cloud resource identifier.
Parameter Relationships
The TARGETDATABASE_*
parameters specify connection details for the
target OCI database.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
Yes |
Modifiable on Resume |
No |
WALLET_AMAZONS3SECRET
Specifies the Amazon S3 Secret Key wallet path.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_OCIAUTHTOKEN
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the OCI Auth Token
password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_DATAPUMPENCRYPTION
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the Data Pump encryption
password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_OGGADMIN
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the Oracle GoldenGate hub
administrative password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_SOURCECONTAINER
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the source database
administrative user password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_SOURCECGGADMIN
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the source database
administrative c##ggadmin
user password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_SOURCEGGADMIN
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the source database
administrative user ggadmin
password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_TARGETADMIN
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the target database
administrative admin password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |
WALLET_TARGETGGADMIN
Specifies the absolute path to the directory that contains the auto login
wallet file cwallet.sso
, which is used to get the target database
administrative user ggadmin
password.
The path should be resolvable from the Zero Downtime Migration service host.
About the WALLET_* Parameters
The WALLET_*
parameters specify the full path for the
auto login wallet file on the Zero Downtime Migration service host.
Property | Description |
---|---|
Syntax |
|
Default value |
There is no default value |
Required |
No |
Modifiable on Resume |
Until |