Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction to Zero Downtime Migration
- 2 Setting Up Zero Downtime Migration Software
-
3
Configuring Required
Connections
- Configuring Connectivity From the Zero Downtime Migration Service Host to the Source and Target Database Servers
- Configuring SUDO Access
- Configuring Connectivity Between the Source and Target Database Servers
- Additional Connectivity Prerequisites for Oracle GoldenGate Hub
- Validating Connections to and from the Oracle GoldenGate Marketplace Instance
- Zero Downtime Migration Port Requirements
- Generate SSH Keys Without a Passphrase
-
4
Preparing for a Physical Database
Migration
- Preparing the Source and Target Databases
- Source Database Prerequisites
- Target Database Prerequisites
- Setting Up the Transparent Data Encryption Keystore
- Setting Physical Migration Parameters
- Using Supported Data Transfer Media
- Using an Existing RMAN Backup as a Data Source
- Using Direct Data Transfer
- Using an Existing Standby to Instantiate the Target Database
- Preparing for Automatic Application Switchover
- Using Oracle Data Guard Broker Role Switchover
- Configuring Resiliency to Intermittent Network Failures
- Converting a Non-CDB Database to a CDB During Migration
- Migrating an On-Premises Database to an On-Premises Exadata Database Machine
-
5
Preparing for a Logical Database
Migration
- Source Database Prerequisites for Logical Migration
- Target Database Prerequisites for Logical Migration
- Additional Logical Migration Prerequisites
- Setting Logical Migration Parameters
- Configuring the Transfer Medium and Specifying Transfer Nodes
- Selecting Objects for Migration
- Setting Advanced Data Pump Parameters
- Migrating Schemas in Parallel Using Batches
- Migrating from Amazon Web Services RDS Oracle to Oracle Cloud
- Migrating to Oracle Autonomous Database on Exadata Cloud@Customer
-
6
Customizing a Migration Job
- About Custom Plug-ins with User Actions
- Parameters Supplied for Custom Plug-ins with User Actions
- User Action Scripts
- Registering User Actions
- Creating an Action Template
- Associating an Action Template with a Migration Job
- Querying Action Plug-ins
- Updating Action Plug-ins
- Modifying User Action Scripts
- Modifying an Action Template
- Chained User Action Output
-
7
Migrating Your Database with Zero Downtime Migration
- Evaluate the Migration Job
- Migrate the Database
- Post-Migration Tasks
- Query Migration Job Status
- List Migration Job Phases
- Pause a Migration Job
- Resume a Migration Job
- Suspend and Resume a Migration Job
- Rerun a Migration Job
- Terminate a Running Migration Job
- Modify Oracle GoldenGate Processes During a Migration Job
- Handling Application Switchover in a Logical Migration
- Zero Downtime Migration Centralized Fleet Migration Management
-
8
Managing the Zero Downtime Migration
Service
- Starting and Stopping the Zero Downtime Migration Service
- Checking Zero Downtime Migration Service Status
- Updating Zero Downtime Migration Software
- Uninstalling Zero Downtime Migration Software
- Performing a Silent Update or Deinstallation
- Viewing the Cloud Premigration Advisor Tool Version
- Updating the Cloud Premigration Advisor Tool
- Setting the MySQL Port
- 9 Troubleshooting Zero Downtime Migration
- A Database Server Connectivity Using a Bastion Host
- B Zero Downtime Migration Encryption Requirements
- C Providing Passwords Non-Interactively Using a Wallet
- D Zero Downtime Migration Process Phases
-
E
Zero Downtime Migration Physical Migration
Response File Parameters Reference
- BACKUP_PATH
- DATA_TRANSFER_MEDIUM
- DATAPATCH_WITH_ONE_INSTANCE_RUNNING
- HOST
- MAX_DATAPATCH_DURATION_MINS
- MIGRATION_METHOD
- NONCDBTOPDB_CONVERSION
- NONCDBTOPDB_SWITCHOVER
- OPC_CONTAINER
- PLATFORM_TYPE
- SHUTDOWN_SRC
- SKIP_FALLBACK
- SKIP_SRC_SERVICE_RETENTION
- SRC_BASTION_HOST_IP
- SRC_BASTION_IDENTITY_FILE
- SRC_BASTION_PORT
- SRC_BASTION_USER
- SRC_CONFIG_LOCATION
- SRC_DB_LISTENER_PORT
- SRC_HOST_IP
- SRC_HTTP_PROXY_PORT
- SRC_HTTP_PROXY_URL
- SRC_OSS_PROXY_HOST
- SRC_OSS_PROXY_PORT
- SRC_PDB_NAME
- SRC_RMAN_CHANNELS
- SRC_SSH_RETRY_TIMEOUT
- SRC_TIMEZONE
- SRC_ZDLRA_WALLET_LOC
- TGT_BASTION_HOST_IP
- TGT_BASTION_IDENTITY_FILE
- TGT_BASTION_PORT
- TGT_BASTION_USER
- TGT_CONFIG_LOCATION
- TGT_DATAACFS
- TGT_DATADG
- TGT_DB_UNIQUE_NAME
- TGT_HOST_IP
- TGT_HTTP_PROXY_PORT
- TGT_HTTP_PROXY_URL
- TGT_OSS_PROXY_HOST
- TGT_OSS_PROXY_PORT
- TGT_RECOACFS
- TGT_RECODG
- TGT_REDOACFS
- TGT_REDODG
- TGT_RETAIN_DB_UNIQUE_NAME
- TGT_RMAN_CHANNELS
- TGT_SKIP_DATAPATCH
- TGT_SSH_RETRY_TIMEOUT
- TGT_SSH_TUNNEL_PORT
- TGT_ZDLRA_WALLET_LOC
- ZDLRA_CRED_ALIAS
- ZDM_BACKUP_DIFFERENTIAL_SRC_MONITORING_INTERVAL
- ZDM_BACKUP_FULL_SRC_MONITORING_INTERVAL
- ZDM_BACKUP_INCREMENTAL_SRC_MONITORING_INTERVAL
- ZDM_BACKUP_RETENTION_WINDOW
- ZDM_BACKUP_TAG
- ZDM_CLONE_TGT_MONITORING_INTERVAL
- ZDM_CURL_LOCATION
- ZDM_LOG_OSS_PAR_URL
- ZDM_OPC_RETRY_COUNT
- ZDM_OPC_RETRY_WAIT_TIME
- ZDM_OSS_RECOVER_TGT_MONITORING_INTERVAL
- ZDM_OSS_RESTORE_TGT_MONITORING_INTERVAL
- ZDM_RMAN_COMPRESSION_ALGORITHM
- ZDM_RMAN_DIRECT_METHOD
- ZDM_SHARD_ID
- ZDM_SKIP_DG_CONFIG_CLEANUP
- ZDM_SRC_DB_RESTORE_SERVICE_NAME
- ZDM_SRC_TNS_ADMIN
- ZDM_STANDBY_DB_CONNECT_STRING
- ZDM_USE_DG_BROKER
- ZDM_USE_EXISTING_BACKUP
- ZDM_USE_EXISTING_STANDBY
- ZDM_USE_EXISTING_UNDO_SIZE
-
F
Zero Downtime Migration Logical Migration
Response File Parameters Reference
- DATA_TRANSFER_MEDIUM
- DATAPUMPSETTINGS_CREATEAUTHTOKEN
- DATAPUMPSETTINGS_DATABASELINKDETAILS_NAME
- DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_BUCKETNAME
- DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_NAMESPACENAME
- DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME
- DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_ESTIMATEBYSTATISTICS
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_TABLEEXISTSACTION
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_USERMETADATA
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXCLUDETYPELIST
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_SKIPCURRENT
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER
- DATAPUMPSETTINGS_DATAPUMPPARAMETERS_RETAININDEX
- DATAPUMPSETTINGS_DELETEDUMPSINOSS
- DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME
- DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH
- DATAPUMPSETTINGS_FIXINVALIDOBJECTS
- DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH
- DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME
- DATAPUMPSETTINGS_JOBMODE
- DATAPUMPSETTINGS_METADATAFILTERS-LIST_ELEMENT_NUMBER
- DATAPUMPSETTINGS_METADATAREMAPS-LIST_ELEMENT_NUMBER
- DATAPUMPSETTINGS_METADATATRANSFORMS-LIST_ELEMENT_NUMBER
- DATAPUMPSETTINGS_MONITORINTERVALMINUTES
- DATAPUMPSETTINGS_OMITENCRYPTIONCLAUSE
- DATAPUMPSETTINGS_SECUREFILELOB
- DATAPUMPSETTINGS_SCHEMABATCHCOUNT
- DATAPUMPSETTINGS_SCHEMABATCH-LIST_ELEMENT_NUMBER
- DATAPUMPSETTINGS_SKIPDEFAULTTRANSFORM
- DUMPTRANSFERDETAILS_PARALLELCOUNT
- DUMPTRANSFERDETAILS_RETRYCOUNT
- DUMPTRANSFERDETAILS_RSYNCAVAILABLE
- DUMPTRANSFERDETAILS_S3BUCKET_ACCESSKEY
- DUMPTRANSFERDETAILS_S3BUCKET_NAME
- DUMPTRANSFERDETAILS_S3BUCKET_REGION
- DUMPTRANSFERDETAILS_SOURCE_OCIHOME
- DUMPTRANSFERDETAILS_SOURCE_PARTSIZEMB
- DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_DUMPDIRPATH
- DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_HOST
- DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_SUDOPATH
- DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USER
- DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USERKEY
- DUMPTRANSFERDETAILS_SOURCE_USEOCICLI
- DUMPTRANSFERDETAILS_TARGET_OCIHOME
- DUMPTRANSFERDETAILS_TARGET_PARTSIZEMB
- DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_DUMPDIRPATH
- DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_HOST
- DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_SUDOPATH
- DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USER
- DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USERKEY
- DUMPTRANSFERDETAILS_TARGET_USEOCICLI
- DUMPTRANSFERDETAILS_TRANSFERTARGET_DUMPDIRPATH
- DUMPTRANSFERDETAILS_TRANSFERTARGET_HOST
- DUMPTRANSFERDETAILS_TRANSFERTARGET_SUDOPATH
- DUMPTRANSFERDETAILS_TRANSFERTARGET_USER
- DUMPTRANSFERDETAILS_TRANSFERTARGET_USERKEY
- EXCLUDEOBJECTS-LIST_ELEMENT_NUMBER
- GOLDENGATEHUB_ADMINUSERNAME
- GOLDENGATEHUB_COMPUTEID
- GOLDENGATEHUB_SOURCEDEPLOYMENTNAME
- GOLDENGATEHUB_TARGETDEPLOYMENTNAME
- GOLDENGATEHUB_URL
- GOLDENGATESETTINGS_ACCEPTABLELAG
- GOLDENGATESETTINGS_EXTRACT_PERFORMANCEPROFILE
- GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_CHECKINTERVAL
- GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_DURATION
- GOLDENGATESETTINGS_REPLICAT_MAPPARALLELISM
- GOLDENGATESETTINGS_REPLICAT_MAXAPPLYPARALLELISM
- GOLDENGATESETTINGS_REPLICAT_MINAPPLYPARALLELISM
- GOLDENGATESETTINGS_REPLICATEDDL
- GOLDENGATESETTINGS_USEFLASHBACKQUERY
- INCLUDEOBJECTS-LIST_ELEMENT_NUMBER
- MIGRATION_METHOD
- OCIAUTHENTICATIONDETAILS_REGIONID
- OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT
- OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE
- OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID
- OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID
- OCIPROXY_HOSTNAME
- OCIPROXY_PORT
- RUNCPATREMOTELY
- SOURCECONTAINERDATABASE_ADMINUSERNAME
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_HOST
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PORT
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_SERVICENAME
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION
- SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME
- SOURCECONTAINERDATABASE_GGADMINUSERNAME
- SOURCEDATABASE_ADMINUSERNAME
- SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE
- SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP
- SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT
- SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP
- SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME
- SOURCEDATABASE_CONNECTIONDETAILS_HOST
- SOURCEDATABASE_CONNECTIONDETAILS_PORT
- SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME
- SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT
- SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME
- SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION
- SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME
- SOURCEDATABASE_ENVIRONMENT_DBTYPE
- SOURCEDATABASE_ENVIRONMENT_NAME
- SOURCEDATABASE_GGADMINUSERNAME
- TABLESPACEDETAILS_AUTOCREATE
- TABLESPACEDETAILS_AUTOREMAP
- TABLESPACEDETAILS_EXCLUDE
- TABLESPACEDETAILS_EXTENDSIZEMB
- TABLESPACEDETAILS_REMAPTARGET
- TABLESPACEDETAILS_USEBIGFILE
- TARGETDATABASE_ADMINUSERNAME
- TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE
- TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP
- TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT
- TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP
- TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME
- TARGETDATABASE_CONNECTIONDETAILS_HOST
- TARGETDATABASE_CONNECTIONDETAILS_PORT
- TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME
- TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT
- TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME
- TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION
- TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME
- TARGETDATABASE_GGADMINUSERNAME
- TARGETDATABASE_OCID
- WALLET_AMAZONS3SECRET
- WALLET_OCIAUTHTOKEN
- WALLET_DATAPUMPENCRYPTION
- WALLET_OGGADMIN
- WALLET_SOURCECONTAINER
- WALLET_SOURCECGGADMIN
- WALLET_SOURCEGGADMIN
- WALLET_TARGETADMIN
- WALLET_TARGETGGADMIN
- G Zero Downtime Migration ZDMCLI Command Reference
- Index