E Zero Downtime Migration Response File Parameters Reference

The following topics describe the Zero Downtime Migration response file parameters.

BACKUP_PATH

BACKUP_PATH specifies a valid path accessible at the source and target for migration backup type.

Property Description

Syntax

BACKUP_PATH = {STORAGEPATH | EXTBACKUP}

Default value

There is no default value.

Range of values

STORAGEPATH - NFS backup location

EXTBACKUP - external backup location

Leave this parameter value blank for other migration backup types

DATAPATCH_WITH_ONE_INSTANCE_RUNNING

DATAPATCH_WITH_ONE_INSTANCE_RUNNING specifies whether or not to stop all instances except one running on the target database server when the datapatch utility is run. When datapatch completes all of the stopped instances are started.

Property Description

Syntax

DATAPATCH_WITH_ONE_INSTANCE_RUNNING ={TRUE | FALSE}

Default value

FALSE

Range of values

TRUE - Stops all instances except one running on the target database server when running the datapatch utility.

FALSE - Does not stop all instances except one running on the target database server when running the datapatch utility.

HOST

HOST specifies the cloud storage REST endpoint URL to access Oracle Cloud Object Storage.

Property Description

Syntax

HOST = rest_endpoint_url

Default value

There is no default value.

Range of values

For Oracle Cloud Infrastructure storage the typical value format is

https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/ObjectStorageNamespace

For Oracle Cloud Infrastructure Classic storage the typical value format is

https://acme.storage.oraclecloud.com/v1/Storage-tenancy name

Usage Notes

To access Oracle Cloud Object Storage, you must set both the HOST and OPC_CONTAINER parameters.

MAX_DATAPATCH_DURATION_MINS

MAX_DATAPATCH_DURATION_MINS specifies a timeout value, in minutes, after which if the datapatch utility has failed to complete then the operation is stopped.

Property Description

Syntax

MAX_DATAPATCH_DURATION_MINS = minutes

Default value

There is no default value. Zero Downtime Migration waits until datapatch completes by default.

MIGRATION_METHOD

MIGRATION_METHOD specifies whether the migration uses Oracle Data Guard (online) or backup and restore (offline) and which media is used for the source database backup.

Property Description

Syntax

MIGRATION_METHOD = {DG_OSS | DG_STORAGEPATH | DG_EXTBACKUP | BACKUP_RESTORE_OSS | BACKUP_RESTORE_NFS}

Default value

DG_OSS

Range of values

DG_OSS - Oracle Data Guard migration using Object Storage Service for standby initialization

DG_STORAGEPATH - Oracle Data Guard migration using backup location such as NFS

DG_EXTBACKUP - Oracle Data Guard migration with existing backup in external location

DG_ZDLRA - Oracle Data Guard migration using Zero Data Loss Recovery Appliance for standby initialization

BACKUP_RESTORE_OSS - Offline migration using backup and restore with Object Storage Service as backup. SQL*Net connectivity is not needed between source and target

BACKUP_RESTORE_NFS - Offline migration using backup and restore with NFS as backup. SQL*Net connectivity is not needed between source and target

OPC_CONTAINER

OPC_CONTAINER specifies the Object Storage bucket (called the container on Oracle Cloud Infrastructure Classic), and is set to access Oracle Cloud Object Storage.

Property Description

Syntax

OPC_CONTAINER = bucket

Default value

There is no default value.

Usage Notes

To access Oracle Cloud Object Storage, you must set both the HOST and OPC_CONTAINER parameters.

The bucket is also referred to as a container for Oracle Cloud Infrastructure Classic storage.

PLATFORM_TYPE

PLATFORM_TYPE specifies the target database platform.

Property Description

Syntax

PLATFORM_TYPE = {VMDB | EXACC | EXACS}

Default value

VMDB

Range of values

VMDB - Oracle Cloud Infrastructure

EXACC - Exadata Cloud at Customer

EXACS - Exadata Cloud Service

SHUTDOWN_SRC

SHUTDOWN_SRC specifies whether or not to shut down the source database after migration completes.

Property Description

Syntax

SHUTDOWN_SRC ={TRUE | FALSE}

Default value

FALSE

Range of values

TRUE - Shut down the source database after migration completes.

FALSE - Dos not shut down the source database after migration completes.

SKIP_FALLBACK

SKIP_FALLBACK specifies whether or not to ship redo logs from the primary (target) database to the standby (source) database, either voluntarily or because there is no connectivity between the target and source database servers.

Property Description

Syntax

SKIP_FALLBACK = {TRUE | FALSE}

Default value

FALSE

Range of values

TRUE - do not ship redo logs from the primary (target) database to the standby (source) database.

FALSE - ship redo logs from the primary (target) database to the standby (source) database.

SKIP_SRC_SERVICE_RETENTION

SKIP_SRC_SERVICE_RETENTION specifies whether or not to retain the source database services and run them on the target database. This parameter is only effective for the BACKUP_RESTORE_OSS and BACKUP_RESTORE_NFS migration methods.

Property Description

Syntax

SKIP_SRC_SERVICE_RETENTION ={TRUE | FALSE}

Default value

FALSE

Range of values

TRUE - Do not retain the source database services.

FALSE - Retain the source database services.

SRC_BASTION_HOST_IP

SRC_BASTION_HOST_IP specifies the bastion host IP address, if you want to connect to the source database server using a bastion host.

Property Description

Syntax

SRC_BASTION_HOST_IP = IP_address

Default value

There is no default value.

Usage Notes

If you want to connect to the source database server using a bastion host, values for the bastion host IP address parameter, SRC_BASTION_HOST_IP, and the source database host IP address parameter, SRC_HOST_IP, are required in the Zero Downtime Migration response file.

If you do not want to use the default value, set the following parameters for bastion host connection.

SRC_BASTION_PORT - The port number defaults to 22 if not specified.

SRC_BASTION_USER - The bastion host source user is only required if the user specified for the source zdmauth plug-in is different from the user of the source bastion host. The bastion user defaults to the user specified for the source zdmauth plug-in if the parameter is not specified.

SRC_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the source zdmauth plug-in.

SRC_BASTION_IDENTITY_FILE

SRC_BASTION_IDENTITY_FILE specifies the bastion user, if you want to connect to the source database server using a bastion host.

Property Description

Syntax

SRC_BASTION_IDENTITY_FILE = identity_file

Default value

If not specified, the value defaults to the value specified for the identity_file argument of the source zdmauth plug-in.

Usage Notes

If you want to connect to the source database server using a bastion host, values for the bastion host IP address parameter, SRC_BASTION_HOST_IP, and the source database server IP address parameter, SRC_HOST_IP, are required in the Zero Downtime Migration response file.

If you do not want to use the default value, set the following parameters for bastion host connection.

SRC_BASTION_PORT - The port number defaults to 22 if not specified.

SRC_BASTION_USER - The bastion host source user is only required if the user specified for the source zdmauth plug-in is different from the user of the source bastion host. The bastion user defaults to the user specified for the source zdmauth plug-in if the parameter is not specified.

SRC_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the source zdmauth plug-in.

SRC_BASTION_PORT

SRC_BASTION_PORT specifies the bastion host port number, if you want to connect to the source database server using a bastion host.

Property Description

Syntax

SRC_BASTION_PORT = port_number

Default value

22

Usage Notes

If you want to connect to the source database server using a bastion host, values for the bastion host IP address parameter, SRC_BASTION_HOST_IP, and the source database server IP address parameter, SRC_HOST_IP, are required in the Zero Downtime Migration response file.

If you do not want to use the default value, set the following parameters for bastion host connection.

SRC_BASTION_PORT - The port number defaults to 22 if not specified.

SRC_BASTION_USER - The bastion host source user is only required if the user specified for the source zdmauth plug-in is different from the user of the source bastion host. The bastion user defaults to the user specified for the source zdmauth plug-in if the parameter is not specified.

SRC_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the source zdmauth plug-in.

SRC_BASTION_USER

SRC_BASTION_USER specifies the bastion user, if you want to connect to the source database server using a bastion host.

Property Description

Syntax

SRC_BASTION_USER = bastion_user

Default value

The bastion user defaults to the user specified for the source zdmauth plug-in if the parameter is not specified.

Usage Notes

If you want to connect to the source database server using a bastion host, values for the bastion host IP address parameter, SRC_BASTION_HOST_IP, and the source database server IP address parameter, SRC_HOST_IP, are required in the Zero Downtime Migration response file.

If you do not want to use the default value, set the following parameters for bastion host connection.

SRC_BASTION_PORT - The port number defaults to 22 if not specified.

SRC_BASTION_USER - The bastion host source user is only required if the user specified for the source zdmauth plug-in is different from the user of the source bastion host. The bastion user defaults to the user specified for the source zdmauth plug-in if the parameter is not specified.

SRC_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the source zdmauth plug-in.

SRC_CONFIG_LOCATION

SRC_CONFIG_LOCATION specifies the SSH configuration file location on the Zero Downtime Migration service host (host where Zero Downtime Migration service is running).

Property Description

Syntax

SRC_CONFIG_LOCATION = SSH_config_file_path

Default value

User_home/.ssh/config

Usage Notes

Set SRC_CONFIG_LOCATION to the full path of the SSH configuration file location on the Zero Downtime Migration service host, for example, /home/crsuser/.ssh/config.

SRC_HOST_IP

SRC_HOST_IP specifies the bastion user, if you want to connect to the source database server using a bastion host.

Property Description

Syntax

SRC_HOST_IP = IP_address

Default value

There is no default value.

Usage Notes

If you want to connect to the source database server using a bastion host, values for the bastion host IP address parameter, SRC_BASTION_HOST_IP, and the source database server IP address parameter, SRC_HOST_IP, are required in the Zero Downtime Migration response file.

If you do not want to use the default value, set the following parameters for bastion host connection.

SRC_BASTION_PORT - The port number defaults to 22 if not specified.

SRC_BASTION_USER - The bastion host source user is only required if the user specified for the source zdmauth plug-in is different from the user of the source bastion host. The bastion user defaults to the user specified for the source zdmauth plug-in if the parameter is not specified.

SRC_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the source zdmauth plug-in.

SRC_HTTP_PROXY_PORT

SRC_HTTP_PROXY_PORT specifies the HTTPS proxy port number on the source database server if an SSH connection needs to connect using a proxy.

Property Description

Syntax

SRC_HTTP_PROXY_PORT = https_proxy_port_number

Default value

There is no default value.

SRC_HTTP_PROXY_URL

SRC_HTTP_PROXY_URL specifies the HTTPS proxy URL on the source database server if an SSH connection needs to connect using a proxy.

Property Description

Syntax

SRC_HTTP_PROXY_URL = https_proxy_url

Default value

There is no default value.

SRC_OSS_PROXY_HOST

SRC_OSS_PROXY_HOST specifies the Object Storage Service proxy host on the source database server if a proxy is needed for connecting to the Object Store.

Property Description

Syntax

SRC_OSS_PROXY_HOST = oss_proxy_host

Default value

There is no default value.

Usage Notes

Set both the SRC_OSS_PROXY_HOST and SRC_OSS_PROXY_PORT parameters if a proxy is needed for connecting to the Object Store.

SRC_OSS_PROXY_PORT

SRC_OSS_PROXY_PORT specifies the Object Storage Service proxy port number on the source database server if a proxy is needed for connecting to the Object Store.

Property Description

Syntax

SRC_OSS_PROXY_PORT = oss_proxy_port_number

Default value

There is no default value.

Usage Notes

Set both the SRC_OSS_PROXY_HOST and SRC_OSS_PROXY_PORT parameters if a proxy is needed for connecting to the Object Store.

SRC_RMAN_CHANNELS

SRC_RMAN_CHANNELS specifies the number of RMAN channels to be allocated at the source database server for performing RMAN backups.

Property Description

Syntax

SRC_RMAN_CHANNELS = number_of_channels

Default value

10

SRC_SSH_RETRY_TIMEOUT

SRC_SSH_RETRY_TIMEOUT specifies a timeout value, in minutes, after which Zero Downtime Migration stops attempting SSH connections after an initial failure to connect.

Property Description

Syntax

SRC_SSH_RETRY_TIMEOUT = number_of_minutes

Default value

There is no default value.

SRC_TIMEZONE

SRC_TIMEZONE specifies the source database server time zone, which is needed for SIDB case when there is no Grid Infrastructure configured.

Property Description

Syntax

SRC_TIMEZONE = source_db_time_zone

Default value

There is no default value.

SRC_ZDLRA_WALLET_LOC

SRC_ZDLRA_WALLET_LOC specifies the path of the Zero Data Loss Recovery Appliance wallet on the source database server.

Property Description

Syntax

SRC_ZDLRA_WALLET_LOC = source_zdlra_wallet_location

The expected format for the location is /u02/app/oracle/product/12.1.0/dbhome_3/dbs/zdlra

Default value

There is no default value.

Usage Notes

When using Zero Data Loss Recovery Appliance as the migration backup medium, you must set the following parameters.

SRC_ZDLRA_WALLET_LOC

TGT_ZDLRA_WALLET_LOC

ZDLRA_CRED_ALIAS

TGT_BASTION_HOST_IP

TGT_BASTION_HOST_IP specifies the bastion host IP address, if you want to connect to the target database server using a bastion host.

Property Description

Syntax

TGT_BASTION_HOST_IP = bastion_ip_address

Default value

There is no default value.

Usage Notes

If you want to connect to the target database server using a bastion host, you are required to configure values for the bastion host IP address parameter, TGT_BASTION_HOST_IP, and the target database server IP address parameter, TGT_HOST_IP, in the Zero Downtime Migration response file.

If you do not want to use the default values for the remaining bastion connection parameters, set the following parameters to configure the bastion host connection.

TGT_BASTION_PORT - The port number defaults to 22 if not specified.

TGT_BASTION_USER - The bastion host target user is only required if the user specified for the target zdmauth plug-in is different from the user of the target bastion host. The bastion user defaults to the user specified for the target zdmauth plug-in if the parameter is not specified.

TGT_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the target zdmauth plug-in.

TGT_BASTION_IDENTITY_FILE

TGT_BASTION_IDENTITY_FILE specifies the bastion user, if you want to connect to the target database server using a bastion host.

Property Description

Syntax

TGT_BASTION_IDENTITY_FILE = identity_file

Default value

If not specified, the value defaults to the value specified for the identity_file argument of the target zdmauth plug-in.

Usage Notes

If you want to connect to the target database server using a bastion host, you are required to configure values for the bastion host IP address parameter, TGT_BASTION_HOST_IP, and the target database server IP address parameter, TGT_HOST_IP, in the Zero Downtime Migration response file.

If you do not want to use the default values for the remaining bastion connection parameters, set the following parameters to configure the bastion host connection.

TGT_BASTION_PORT - The port number defaults to 22 if not specified.

TGT_BASTION_USER - The bastion host target user is only required if the user specified for the target zdmauth plug-in is different from the user of the target bastion host. The bastion user defaults to the user specified for the target zdmauth plug-in if the parameter is not specified.

TGT_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the target zdmauth plug-in.

TGT_BASTION_PORT

TGT_BASTION_PORT specifies the bastion host port number, if you want to connect to the target database server using a bastion host.

Property Description

Syntax

TGT_BASTION_PORT = port_number

Default value

22

Usage Notes

If you want to connect to the target database server using a bastion host, you are required to configure values for the bastion host IP address parameter, TGT_BASTION_HOST_IP, and the target database server IP address parameter, TGT_HOST_IP, in the Zero Downtime Migration response file.

If you do not want to use the default values for the remaining bastion connection parameters, set the following parameters to configure the bastion host connection.

TGT_BASTION_PORT - The port number defaults to 22 if not specified.

TGT_BASTION_USER - The bastion host target user is only required if the user specified for the target zdmauth plug-in is different from the user of the target bastion host. The bastion user defaults to the user specified for the target zdmauth plug-in if the parameter is not specified.

TGT_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the target zdmauth plug-in.

TGT_BASTION_USER

TGT_BASTION_USER specifies the bastion user, if you want to connect to the target database server using a bastion host.

Property Description

Syntax

TGT_BASTION_USER = bastion_user

Default value

The bastion user defaults to the user specified for the target zdmauth plug-in if the parameter is not specified.

Usage Notes

If you want to connect to the target database server using a bastion host, you are required to configure values for the bastion host IP address parameter, TGT_BASTION_HOST_IP, and the target database server IP address parameter, TGT_HOST_IP, in the Zero Downtime Migration response file.

If you do not want to use the default values for the remaining bastion connection parameters, set the following parameters to configure the bastion host connection.

TGT_BASTION_PORT - The port number defaults to 22 if not specified.

TGT_BASTION_USER - The bastion host target user is only required if the user specified for the target zdmauth plug-in is different from the user of the target bastion host. The bastion user defaults to the user specified for the target zdmauth plug-in if the parameter is not specified.

TGT_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the target zdmauth plug-in.

TGT_CONFIG_LOCATION

TGT_CONFIG_LOCATION specifies the SSH configuration file location on the Zero Downtime Migration service host (host where Zero Downtime Migration service is running).

Property Description

Syntax

TGT_CONFIG_LOCATION = SSH_config_file_path

Default value

User_home/.ssh/config

Usage Notes

Set TGT_CONFIG_LOCATION to the full path of the SSH configuration file location on the Zero Downtime Migration service host, for example, /home/crsuser/.ssh/config.

TGT_DATAACFS

TGT_DATAACFS specifies the location for the data files ACFS volume (data) on the target database. Use only if required to override the values discovered automatically by Zero Downtime Migration.

Property Description

Syntax

TGT_DATAACFS = data_location

Default value

There is no default value.

Usage Notes

Zero Downtime Migration discovers the location for ASM and ACFS data, redo, and reco storage volumes from the specified target database, making these target database storage properties optional.

If you need to override the values automatically discovered by Zero Downtime Migration, then you can set the following parameters. For example, TGT_DATADG=+DATAC3

For ASM use these parameters

TGT_DATADG

TGT_REDODG

TGT_RECODG

For ACFS use these parameters

TGT_DATAACFS

TGT_REDOACFS

TGT_RECOACFS

TGT_DATADG

TGT_DATADG specifies the location for the data files ASM disk group (data) on the target database. Use only if required to override the values discovered automatically by Zero Downtime Migration.

Property Description

Syntax

TGT_DATADG = data_location

Default value

There is no default value.

Usage Notes

Zero Downtime Migration discovers the location for ASM and ACFS data, redo, and reco storage volumes from the specified target database, making these target database storage properties optional.

If you need to override the values automatically discovered by Zero Downtime Migration, then you can set the following parameters. For example, TGT_DATADG=+DATAC3

For ASM use these parameters

TGT_DATADG

TGT_REDODG

TGT_RECODG

For ACFS use these parameters

TGT_DATAACFS

TGT_REDOACFS

TGT_RECOACFS

TGT_DB_UNIQUE_NAME

TGT_DB_UNIQUE_NAME is used by Zero Downtime Migration to identify the target database.

Property Description

Syntax

TGT_DB_UNIQUE_NAME = value of target database DB_UNIQUE_NAME

Default value

Usage Notes

Set TGT_DB_UNIQUE_NAME to the target database DB_UNIQUE_NAME value.

If the target database is Oracle Cloud Infrastructure, Exadata Cloud Service, or Exadata Cloud at Customer, the target database DB_UNIQUE_NAME parameter value must be unique to ensure that Oracle Data Guard can identify the target as a different database from the source database.

TGT_HOST_IP

TGT_HOST_IP specifies the bastion user, if you want to connect to the target database server using a bastion host.

Property Description

Syntax

TGT_HOST_IP = IP_address

Default value

There is no default value.

Usage Notes

If you want to connect to the target database server using a bastion host, you are required to configure values for the bastion host IP address parameter, TGT_BASTION_HOST_IP, and the target database server IP address parameter, TGT_HOST_IP, in the Zero Downtime Migration response file.

If you do not want to use the default values for the remaining bastion connection parameters, set the following parameters to configure the bastion host connection.

TGT_BASTION_PORT - The port number defaults to 22 if not specified.

TGT_BASTION_USER - The bastion host target user is only required if the user specified for the target zdmauth plug-in is different from the user of the target bastion host. The bastion user defaults to the user specified for the target zdmauth plug-in if the parameter is not specified.

TGT_BASTION_IDENTITY_FILE - If not specified, the value defaults to the value specified for the identity_file argument of the target zdmauth plug-in.

TGT_HTTP_PROXY_PORT

TGT_HTTP_PROXY_PORT specifies the HTTPS proxy port if an SSH connection needs to use a proxy to connect to the target database server.

Property Description

Syntax

TGT_HTTP_PROXY_PORT = https_proxy_port_number

Default value

There is no default value.

Usage Notes

Set both the TGT_HTTP_PROXY_URL and TGT_HTTP_PROXY_PORT parameters if the SSH connection needs to use an HTTPS proxy to connect to the target database server.

TGT_HTTP_PROXY_URL

TGT_HTTP_PROXY_URL specifies the HTTPS proxy URL if an SSH connection needs to use a proxy to connect to the target database server.

Property Description

Syntax

TGT_HTTP_PROXY_URL = https_proxy_url

Default value

There is no default value.

Usage Notes

Set both the TGT_HTTP_PROXY_URL and TGT_HTTP_PROXY_PORT parameters if the SSH connection needs to use an HTTPS proxy to connect to the target database server.

TGT_OSS_PROXY_HOST

TGT_OSS_PROXY_HOST specifies the Object Storage Service proxy host on the target database server if a proxy is needed for connecting to the Object Store.

Property Description

Syntax

TGT_OSS_PROXY_HOST = oss_proxy_host

Default value

There is no default value.

Usage Notes

Set both the TGT_OSS_PROXY_HOST and TGT_OSS_PROXY_PORT parameters if a proxy is needed for connecting to the Object Store.

TGT_OSS_PROXY_PORT

TGT_OSS_PROXY_PORT specifies the Object Storage Service proxy port number on the target database server if a proxy is needed for connecting to the Object Store.

Property Description

Syntax

TGT_OSS_PROXY_PORT = oss_proxy_port_number

Default value

There is no default value.

Usage Notes

Set both the TGT_OSS_PROXY_HOST and TGT_OSS_PROXY_PORT parameters if a proxy is needed for connecting to the Object Store.

TGT_RECOACFS

TGT_RECOACFS specifies the location for the fast recovery area ACFS volume (reco) on the target database. Use only if required to override the values discovered automatically by Zero Downtime Migration.

Property Description

Syntax

TGT_RECOACFS = reco_location

Default value

There is no default value.

Usage Notes

Zero Downtime Migration discovers the location for ASM and ACFS data, redo, and reco storage volumes from the specified target database, making these target database storage properties optional.

If you need to override the values automatically discovered by Zero Downtime Migration, then you can set the following parameters. For example, TGT_DATADG=+DATAC3

For ASM use these parameters

TGT_DATADG

TGT_REDODG

TGT_RECODG

For ACFS use these parameters

TGT_DATAACFS

TGT_REDOACFS

TGT_RECOACFS

TGT_RECODG

TGT_RECODG specifies the location for the fast recovery area ASM disk group (reco) on the target database. Use only if required to override the values discovered automatically by Zero Downtime Migration.

Property Description

Syntax

TGT_RECODG = reco_location

Default value

There is no default value.

Usage Notes

Zero Downtime Migration discovers the location for ASM and ACFS data, redo, and reco storage volumes from the specified target database, making these target database storage properties optional.

If you need to override the values automatically discovered by Zero Downtime Migration, then you can set the following parameters. For example, TGT_DATADG=+DATAC3

For ASM use these parameters

TGT_DATADG

TGT_REDODG

TGT_RECODG

For ACFS use these parameters

TGT_DATAACFS

TGT_REDOACFS

TGT_RECOACFS

TGT_REDOACFS

TGT_REDOACFS specifies the location for redo log files ACFS volume (redo) on the target database. Use only if required to override the values discovered automatically by Zero Downtime Migration.

Property Description

Syntax

TGT_REDOACFS = redo_location

Default value

There is no default value.

Usage Notes

Zero Downtime Migration discovers the location for ASM and ACFS data, redo, and reco storage volumes from the specified target database, making these target database storage properties optional.

If you need to override the values automatically discovered by Zero Downtime Migration, then you can set the following parameters. For example, TGT_DATADG=+DATAC3

For ASM use these parameters

TGT_DATADG

TGT_REDODG

TGT_RECODG

For ACFS use these parameters

TGT_DATAACFS

TGT_REDOACFS

TGT_RECOACFS

TGT_REDODG

TGT_REDODG specifies the location for redo log files ASM disk group (redo) on the target database. Use only if required to override the values discovered automatically by Zero Downtime Migration.

Property Description

Syntax

TGT_REDODG = redo_location

Default value

There is no default value.

Usage Notes

Zero Downtime Migration discovers the location for ASM and ACFS data, redo, and reco storage volumes from the specified target database, making these target database storage properties optional.

If you need to override the values automatically discovered by Zero Downtime Migration, then you can set the following parameters. For example, TGT_DATADG=+DATAC3

For ASM use these parameters

TGT_DATADG

TGT_REDODG

TGT_RECODG

For ACFS use these parameters

TGT_DATAACFS

TGT_REDOACFS

TGT_RECOACFS

TGT_RMAN_CHANNELS

TGT_RMAN_CHANNELS specifies the number of RMAN channels to be allocated at the target database server for performing RMAN restore.

Property Description

Syntax

TGT_RMAN_CHANNELS = number_of_channels

Default value

10

TGT_SKIP_DATAPATCH

TGT_SKIP_DATAPATCH specifies whether or not Zero Downtime Migration runs the datapatch utility on the target database as part of the post-migration tasks.

Property Description

Syntax

TGT_SKIP_DATAPATCH = {TRUE | FALSE}

Default value

FALSE

Range of values

TRUE - do not allow Zero Downtime Migration to run datapatch

FALSE - allow Zero Downtime Migration to run datapatch

Usage Notes

If the target database environment is at a higher patch level than the source database (for example, if the source database is at Jan 2020 PSU/BP and the target database is at April 2020 PSU/BP), then set the TGT_SKIP_DATAPATCH parameter to FALSE to allow Zero Downtime Migration to run the datapatch utility on the target database as part of the post-migration tasks.

Otherwise, set the parameter to TRUE, and if the target database environment is at a higher patch level than the source database, you will need to run the datapatch utility manually after the migration.

TGT_SSH_RETRY_TIMEOUT

TGT_SSH_RETRY_TIMEOUT specifies the number of minutes during which retries are attempted after SSH connection failures. Retries stop when the timeout value has elapsed.

Property Description

Syntax

TGT_SSH_RETRY_TIMEOUT = number_of_minutes

Default value

There is no default value.

TGT_SSH_TUNNEL_PORT

TGT_SSH_TUNNEL_PORT specifies the forwarding port on the source database server where the SSH tunnel to the target database server for SQL*Net connection is set up.

Property Description

Syntax

TGT_SSH_TUNNEL_PORT = ssh_tunnel_port_number

Default value

There is no default value.

TGT_ZDLRA_WALLET_LOC

TGT_ZDLRA_WALLET_LOC specifies the path of the Zero Data Loss Recovery Appliance wallet on the target database server.

Property Description

Syntax

TGT_ZDLRA_WALLET_LOC = target_zdlra_wallet_location

The expected format for the location is /u02/app/oracle/product/12.1.0/dbhome_3/dbs/zdlra

Default value

There is no default value.

Usage Notes

When using Zero Data Loss Recovery Appliance as the migration backup medium, you must set the following parameters.

SRC_ZDLRA_WALLET_LOC

TGT_ZDLRA_WALLET_LOC

ZDLRA_CRED_ALIAS

ZDLRA_CRED_ALIAS

ZDLRA_CRED_ALIAS specifies the Zero Data Loss Recovery Appliance wallet credential alias.

Property Description

Syntax

ZDLRA_CRED_ALIAS = zdlra_wallet_alias

The expected format for the alias is zdlra scan:listener port/zdlra9:dedicated

Default value

There is no default value.

Usage Notes

When using Zero Data Loss Recovery Appliance as the migration backup medium, you must set the following parameters.

SRC_ZDLRA_WALLET_LOC

TGT_ZDLRA_WALLET_LOC

ZDLRA_CRED_ALIAS

ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL

ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL specifies the time interval, in minutes, at which to monitor and report the progress of the ZDM_BACKUP_DIFFERENTIAL_SRC migration job phase.

Property Description

Syntax

ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL = minutes

Default value

10

Usage Notes

The migration job phase monitoring interval parameters, listed below, monitor and report the backup and restore operations progress at the set time interval, specified in minutes. Note that the migration job phase for which the monitoring interval applies is prefixed to _MONITORING_INTERVAL in each parameter listed above.

  • ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
  • ZDM_CLONE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

To disable a monitoring interval parameter, set it to 0 (zero).

ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL

ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL specifies the time interval, in minutes, at which to monitor and report the progress of the ZDM_BACKUP_FULL_SRC migration job phase.

Property Description

Syntax

ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL = minutes

Default value

10

Usage Notes

The migration job phase monitoring interval parameters, listed below, monitor and report the backup and restore operations progress at the set time interval, specified in minutes. Note that the migration job phase for which the monitoring interval applies is prefixed to _MONITORING_INTERVAL in each parameter listed above.

  • ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
  • ZDM_CLONE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

To disable a monitoring interval parameter, set it to 0 (zero).

ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL

ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL specifies the time interval, in minutes, at which to monitor and report the progress of the ZDM_BACKUP_INCREMENTAL_SRC migration job phase.

Property Description

Syntax

ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL = minutes

Default value

10

Usage Notes

The migration job phase monitoring interval parameters, listed below, monitor and report the backup and restore operations progress at the set time interval, specified in minutes. Note that the migration job phase for which the monitoring interval applies is prefixed to _MONITORING_INTERVAL in each parameter listed above.

  • ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
  • ZDM_CLONE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

To disable a monitoring interval parameter, set it to 0 (zero).

ZDM_BACKUP_RETENTION_WINDOW

ZDM_BACKUP_RETENTION_WINDOW specifies the number of days after which backups created by Zero Downtime Migration become obsolete.

Property Description

Syntax

ZDM_BACKUP_RETENTION_WINDOW = days

Default value

60

ZDM_CLONE_TGT_MONITORING_INTERVAL

ZDM_CLONE_TGT_MONITORING_INTERVAL specifies the time interval, in minutes, at which to monitor and report the progress of the ZDM_CLONE_TGT migration job phase.

Property Description

Syntax

ZDM_CLONE_TGT_MONITORING_INTERVAL = minutes

Default value

10

Usage Notes

The migration job phase monitoring interval parameters, listed below, monitor and report the backup and restore operations progress at the set time interval, specified in minutes. Note that the migration job phase for which the monitoring interval applies is prefixed to _MONITORING_INTERVAL in each parameter listed above.

  • ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
  • ZDM_CLONE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

To disable a monitoring interval parameter, set it to 0 (zero).

ZDM_CURL_LOCATION

ZDM_CURL_LOCATION specifies a custom location for the CURL binary on the source.

Property Description

Syntax

ZDM_CURL_LOCATION = curl_location

Default value

/usr/bin/curl

ZDM_LOG_OSS_PAR_URL

ZDM_LOG_OSS_PAR_URL specifies the pre-authenticated URL to use when uploading logs to Object Storage Service. The logs capture the current migration job phase and the execution status of the phase.

Property Description

Syntax

ZDM_LOG_OSS_PAR_URL = url

Default value

There is no default value. By default this parameter is disabled.

ZDM_OPC_RETRY_COUNT

ZDM_OPC_RETRY_COUNT specifies the number of retry attempts tat will be made after an initial Object Store connection failure.

Property Description

Syntax

ZDM_OPC_RETRY_COUNT = number

Default value

0 (zero)

The default behavior is to attempt no retries.

ZDM_OPC_RETRY_WAIT_TIME

ZDM_OPC_RETRY_WAIT_TIME specifies the number of seconds to wait after an Object Store connection failure before attempting to retry the connection.

Property Description

Syntax

ZDM_OPC_RETRY_WAIT_TIME = seconds

Default value

529 (seconds)

ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL specifies the time interval, in minutes, at which to monitor and report the progress of the ZDM_OSS_RECOVER_TGT migration job phase.

Property Description

Syntax

ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL = minutes

Default value

10

Usage Notes

The migration job phase monitoring interval parameters, listed below, monitor and report the backup and restore operations progress at the set time interval, specified in minutes. Note that the migration job phase for which the monitoring interval applies is prefixed to _MONITORING_INTERVAL in each parameter listed above.

  • ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
  • ZDM_CLONE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

To disable a monitoring interval parameter, set it to 0 (zero).

ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL

ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL specifies the time interval, in minutes, at which to monitor and report the progress of the ZDM_OSS_RESTORE_TGT migration job phase.

Property Description

Syntax

ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL = minutes

Default value

10

Usage Notes

The migration job phase monitoring interval parameters, listed below, monitor and report the backup and restore operations progress at the set time interval, specified in minutes. Note that the migration job phase for which the monitoring interval applies is prefixed to _MONITORING_INTERVAL in each parameter listed above.

  • ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
  • ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
  • ZDM_CLONE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
  • ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL

To disable a monitoring interval parameter, set it to 0 (zero).

ZDM_SRC_TNS_ADMIN

ZDM_SRC_TNS_ADMIN specifies the custom location for TNS_ADMIN on the source database server when there is no Oracle Grid Infrastructure. If a Grid Infrastructure exists, then the TNS_ADMIN property must be set in the CRS resource attribute environment of the database resource.

Property Description

Syntax

ZDM_SRC_TNS_ADMIN = tns_admin_location

Default value

There is no default value.

ZDM_USE_EXISTING_UNDO_SIZE

ZDM_USE_EXISTING_UNDO_SIZE specifies whether Zero Downtime Migration should use the existing undo tablespace size when creating a new undo tablespace, if required.

Property Description

Syntax

ZDM_USE_EXISTING_UNDO_SIZE ={TRUE | FALSE}

Default value

TRUE

By default, Zero Downtime Migration uses the largest size of the existing undo tablespaces.

Range of values

TRUE - Use the existing undo tablespace size.

FALSE - Do not use the existing undo tablespace size.