C Zero Downtime Migration Process Phases
The migration job process in Zero Downtime Migration runs in operational phases as a work flow. The tables below describe the phases for physical and logical migrations.
Example C-1 Listing Zero Downtime Migration Process Phases
Run the ZDMCLI migrate database command with the
-listphases option to list the operational phases for your
migration job, as shown here.
zdmuser> $ZDM_HOME/bin/zdmcli migrate database -sourcedb zdmsdb
-sourcenode ocicdb1 -srcauth zdmauth -srcarg1 user:opc
-srcarg2 identity_file:/home/zdmuser/.ssh/zdm_service_host.ppk
-srcarg3 sudo_location:/usr/bin/sudo -targetnode ocidb1
-backupuser backup_user@example.com
-rsp /u01/app/zdmhome/rhp/zdm/template/zdm_template_zdmsdb.rsp
-tgtauth zdmauth -tgtarg1 user:opc
-tgtarg2 identity_file:/home/zdmuser/.ssh/zdm_service_host.ppk
-tgtarg3 sudo_location:/usr/bin/sudo -listphasesTable C-1 Physical Migration Phase Descriptions
| Phase name | Online/Offline | Description |
|---|---|---|
|
ZDM_GET_SRC_INFO |
Both |
Gets information about the source database |
|
ZDM_GET_TGT_INFO |
Both |
Gets information about the target database |
|
ZDM_SETUP_SRC |
Both |
Sets up Zero Downtime Migration helper modules on the source server |
|
ZDM_SETUP_TGT |
Both |
Sets up Zero Downtime Migration helper modules on the target server |
|
ZDM_PREUSERACTIONS |
Both |
Runs migration pre-user actions, if any, at the source |
|
ZDM_PREUSERACTIONS_TGT |
Both |
Runs migration pre-user actions, if any, at the target |
|
ZDM_VALIDATE_SRC |
Both |
Perform validations at the source |
|
ZDM_VALIDATE_TGT |
Both |
Performs validations at the target |
|
ZDM_OBC_INST_SRC |
Both |
Installs Oracle Database Cloud Backup Module at the source |
|
ZDM_OBC_INST_TGT |
Both |
Installs Oracle Database Cloud Backup Module at the target |
|
ZDM_BACKUP_FULL_SRC |
Both |
Performs full backup of the source database |
|
ZDM_BACKUP_INCREMENTAL_SRC |
Both |
Performs incremental backup of the source database |
|
ZDM_DISCOVER_SRC |
Both |
Performs database discovery at the source for setting up Data Guard |
|
ZDM_COPYFILES |
Both |
Copies Oracle password file and TDE wallets from source to target |
|
ZDM_SETUP_TDE_TGT |
Both |
Copies TDE wallet files from the source to the target keystore location |
| ZDM_RESTORE_TARGET | Online | |
| ZDM_RECOVER_TARGET | Online | ... |
|
ZDM_OSS_RESTORE_TGT |
Offline |
Performs full database restore |
|
ZDM_BACKUP_DIFFERENTIAL_SRC |
Offline |
Performs differential backup of the source database |
|
ZDM_OSS_RECOVER_TGT |
Offline |
Performs incremental restore, recovery database, and opens database with reset logs |
|
ZDM_PREPARE_TGT |
Both |
Prepares target for Data Guard standby creation |
|
ZDM_CLONE_TGT |
Online |
Creates Data Guard standby from the Cloud backup |
|
ZDM_FINALIZE_TGT |
Both |
Finalizes Data Guard standby preparation of the target. Converts the target database to RAC if originally provisioned as Oracle RAC. |
|
ZDM_CONFIGURE_DG_SRC |
Online |
Registers the Cloud standby with the source |
|
ZDM_SWITCHOVER_SRC |
Online |
Initiates switchover actions at the source |
|
ZDM_SWITCHOVER_TGT |
Online |
Completes switchover actions at the target |
|
ZDM_POST_DATABASE_OPEN_TGT |
Both |
Performs activities after database is opened, such as restore pluggable database state, DBA directories, RMAN configuration |
|
ZDM_DATAPATCH_TGT |
Both |
Runs datapatch at the target |
|
ZDM_SHUTDOWN_SRC |
Both |
Shuts down source database at the end of the migration |
|
ZDM_POSTUSERACTIONS |
Both |
Performs any post-migration user actions at the source |
|
ZDM_POSTUSERACTIONS_TGT |
Both |
Performs any post-migration user actions at the target |
|
ZDM_CLEANUP_SRC |
Both |
Performs clean up at the source |
|
ZDM_CLEANUP_TGT |
Both |
Performs clean up at the target |
Table C-2 Logical Migration Phase Descriptions
| Phase name | Online/Offline | Description |
|---|---|---|
|
ZDM_VALIDATE_TGT |
Both |
Verifies that the target database exists, discovers the database type, and validates access credentials, security, and connectivity. For an Autonomous Database target, sets up the access to the target database from the Zero Downtime Migration node by downloading the target database access wallet with OCI REST services and discovers the target OCPU. Online only: verifies |
|
ZDM_VALIDATE_SRC |
Both |
Validates the source database access credentials, database parameter settings. Online only: verifies |
|
ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC |
Both |
Validates the export directory object (if applicable), and checks for sufficient space and permission for specified user in the source database to export dumps. Checks if the specified Oracle Cloud Object Store buckets, data bucket, and wallet bucket are accessible from the source. Also validates the proxy configuration if applicable. |
|
ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT |
Both |
Verifies that the Data Pump import directory object exists. If a pre-existing DBLINK was specified, checks if it exists and is valid, and ensures that the Autonomous Database requirements for the DBLINK and wallet files are met. For a co-managed target database, ensures that the OCI OSS data bucket and wallet bucket are valid and accessible from the target server. Ensures that the local path to download the dump is valid and has sufficient space. |
|
ZDM_PREPARE_DATAPUMP_SRC |
Both |
Creates a new directory object for Data Pump, if required. Creates OCI Auth Token to access OCI OSS bucket if required. |
|
ZDM_DATAPUMP_ESTIMATE_SRC |
Both |
Performs Data Pump export dump size estimation. See also, DATAPUMPSETTINGS_DATAPUMPPARAMETERS_ESTIMATEBYSTATISTICS. Not used with DBLINK |
|
ZDM_PREPARE_DATAPUMP_TGT |
Both |
Creates a new directory object for Data Pump, if required. Stores OCI Auth token in the database for secure OSS access. If migrating via DBLINK, and a DBLINK must be created, creates the necessary database credentials to access the source and create a new DBLINK. Ensures Autonomous Database security requirements are met using DBLINK over SSL. |
|
ZDM_DATAPUMP_EXPORT_SRC |
Both |
Starts and monitors the Data Pump Export on the source database. |
|
ZDM_UPLOAD_DUMPS_SRC |
Both |
Uploads Data Pump dump files from the source to OCI OSS. |
|
ZDM_DATAPUMP_IMPORT_TGT |
Both |
Starts import of Data Pump Dumps to the target database, either from the OCI OSS bucket or via DBLINK, and monitors the Data Pump import progress. |
|
ZDM_POST_DATAPUMP_SRC |
Both |
Removes any Data Pump directory object created by Zero Downtime Migration. |
|
ZDM_POST_DATAPUMP_TGT |
Both |
Fixes any invalid objects in the target database. Removes the database access and OCI OSS access credentials that were created for the migration. Removes any DBLINK created by Zero Downtime Migration. Optionally, removes source database dumps stored in OCI OSS bucket. |
|
ZDM_POST_ACTIONS |
Both |
Removes Autonomous Database access wallet from the Zero Downtime Migration node. |
|
ZDM_PRE_MIGRATION_ADVISOR |
Both |
Runs the Oracle Database Premigration Advisor Tool on the migration job. |
|
ZDM_VALIDATE GG_HUB |
Online |
Verifies GoldenGate Microservices REST endpoints, software configuration, health, and connectivity to the source and target databases. |
|
ZDM_PREPARE_GG_HUB |
Online |
Registers database connection details and credentials with GoldenGate Microservices. |
|
ZDM_ADD_HEARTBEAT_SRC |
Online |
Creates GoldenGate heartbeat table in the source database. If the table already exists, sets update frequency to 60 seconds. |
|
ZDM_ADD_SCHEMA_TRANDATA_SRC |
Online |
Prepares the source database schemas for instantiation by enabling schema level supplemental logging. |
|
ZDM_CREATE_GG_EXTRACT_SRC |
Online |
Starts the GoldenGate Extract process at the source database |
|
ZDM_ADD_HEARTBEAT_TGT |
Online |
Creates the GoldenGate heartbeat table in the target database. If the table already exists, sets update frequency to 60 seconds. |
|
ZDM_ADD_CHECKPOINT_TGT |
Online |
Creates GoldenGate checkpoint table in the target database to track Replicat progress. |
|
ZDM_CREATE_GG_REPLICAT_TGT |
Online |
Starts GoldenGate Replicat process for the target database. |
|
ZDM_MONITOR_GG_LAG |
Online |
Polls the GoldenGate checkpoint and heartbeat data to measure end-to-end apply lag until lag decreases below desired threshold. |
|
ZDM_SWITCHOVER_APP |
Online |
If the source database is idle, stops GoldenGate Extract, waits for GoldenGate Replicat to complete apply, and stops GoldenGate Replicat. |
|
ZDM_RM_GG_EXTRACT_SRC |
Online |
Deletes GoldenGate Extract process on source database |
|
ZDM_RM_GG_REPLICAT_TGT |
Online |
Deletes GoldenGate Replicat process on target database |
|
ZDM_DELETE_SCHEMA_TRANDATA_SRC |
Online |
Disables schema level supplemental logging on source database |
| ZDM_RM_HEARTBEAT_SRC |
Online |
Drops the GoldenGate heartbeat table in source database, if the table was created by Zero Downtime Migration. Otherwise, resets update frequency to original setting. |
|
ZDM_RM_CHECKPOINT_TGT |
Online |
Drops the GoldenGate checkpoint table in the target database. |
|
ZDM_RM_HEARTBEAT_TGT |
Online |
Drops the GoldenGate heartbeat table in the target database, if the table was created by Zero Downtime Migration. Otherwise, resets the update frequency to the original value. |
|
ZDM_CLEAN_GG_HUB |
Online |
Deletes the database connection details and credentials saved with GoldenGate Microservices |