Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.
In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.
These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.
In Part 1, we discussed how to create and configure the ZDM hub.
In Part 2, we discussed how to create and configure the GoldenGate hub.
In Part 3, we discussed the process of configuring connectivity from the OCI console to both the ZDM and GoldenGate hubs.
In Part 4, we discussed how to configure the source Oracle 12c Release 2 database and the target Oracle 21c database for Zero Downtime Migration.
In this post we will first execute ZDM in Evaluation Mode via zdmcli followed by the actual execution of ZDM as part of a ‘live’ online migration.
Create the ZDM response file on the ZDM Hub compute node.
Specify the type of ZDM migration – Online Logical migration
[zdmuser@zdm-hub ~]$ cat logical_migration.rsp # migration method MIGRATION_METHOD=ONLINE_LOGICAL DATA_TRANSFER_MEDIUM=OSS
Specify the OCID of the target 21c database (obtain this from the OCI console) – and the target database admin account we will use to connect to the database – SYSTEM.
# target db 21c OCID and ADMIN USER TARGETDATABASE_OCID=ocid1.database.oc1.ap-sydney-1.anzxsljrqnlku6qael55wxathimtyjcttsaqepleeiflkv5fyuodcpglr2gq TARGETDATABASE_ADMINUSERNAME=SYSTEM
Specify the admin user account we will use to connect to the source Oracle 12c database as well as the GoldenGate admin user . Provide the details required to connect to the source container as welll as PDB like the host name, port and service name.
# source db 12c SOURCEDATABASE_ADMINUSERNAME=SYSTEM SOURCEDATABASE_CONNECTIONDETAILS_HOST=ora12c.sub12020731300.soormavcn.oraclevcn.com SOURCEDATABASE_CONNECTIONDETAILS_PORT=1521 SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME=ora12c_pdb1.sub12020731300.soormavcn.oraclevcn.com SOURCECONTAINERDATABASE_ADMINUSERNAME=SYSTEM SOURCECONTAINERDATABASE_GGADMINUSERNAME=C##GGADMIN SOURCECONTAINERDATABASE_CONNECTIONDETAILS_HOST=ora12c.sub12020731300.soormavcn.oraclevcn.com SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PORT=1521 SOURCECONTAINERDATABASE_CONNECTIONDETAILS_SERVICENAME=ora12c_syd126.sub12020731300.soormavcn.oraclevcn.com SOURCECONTAINERDATABASE_ENVIRONMENT_NAME=ORACLE SOURCECONTAINERDATABASE_ENVIRONMENT_DBTYPE=ORACLE
Provide the connection details for the source 21c pluggable database.
# target db(PDB) TARGETDATABASE_CONNECTIONDETAILS_HOST=ora21c.sub12020731300.soormavcn.oraclevcn.com TARGETDATABASE_CONNECTIONDETAILS_PORT=1521 TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME=ora21c_pdb1.sub12020731300.soormavcn.oraclevcn.com
Provide the OCI related connectivity information. We can get the required user and tenancy information from the OCI console and also the path to the location of the API public key file (refer to Part 3 of the series where we generated this file).
# oci cli OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID=ocid1.tenancy.oc1..aaaaaaaa4nkaodldkc4jltkndutjhgakrsdjlm5kmfohbtrtl637lxmq236a OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID=ocid1.user.oc1..aaaaaaaaptxleaw7w6ylmhb5ojggt2coxi6vzt2gfrgrcathxpadf5nxq5iq OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT=74:2c:75:f7:15:a8:8a:fa:0f:6a:05:64:50:9c:38:fd OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE=/home/zdmuser/.oci/oci_api_key.pem OCIAUTHENTICATIONDETAILS_REGIONID=ap-sydney-1
Provide the details of the compute node in OCI which is serving the purpose of the OGG hub. (Refer Part 2 of the series)
## GoldenGate TARGETDATABASE_GGADMINUSERNAME=ggadmin SOURCEDATABASE_GGADMINUSERNAME=ggadmin GOLDENGATEHUB_ADMINUSERNAME=oggadmin GOLDENGATEHUB_URL=https://ogghub.sub12020731300.soormavcn.oraclevcn.com GOLDENGATEHUB_SOURCEDEPLOYMENTNAME=ZDM GOLDENGATEHUB_TARGETDEPLOYMENTNAME=ZDM GOLDENGATEHUB_COMPUTEID=ocid1.instance.oc1.ap-sydney-1.anzxsljrqnlku6qcxghwjeu3sry2344wfly4yu3qutitgfsff5dh6javatkq
Provide the details of the OCI Storage Bucket as well as the Data Pump export and import directories.
# data pump DATAPUMPSETTINGS_JOBMODE=SCHEMA DATAPUMPSETTINGS_SCHEMABATCH-1=DEMO DATAPUMPSETTINGS_DATAPUMPPARAMETERS_TABLEEXISTSACTION =REPLACE DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER=TRUE DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE=4 DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE=2 DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME=sdk0bdtnrmys DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME=MIG21C DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME=zdm_export DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH=/u01/app/oracle/zdm_export DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME=zdm_import DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH=/u01/app/oracle/zdm_import DATAPUMPSETTINGS_CREATEAUTHTOKEN=FALSE DATAPUMPSETTINGS_OMITENCRYPTIONCLAUSE=TRUE
[zdmuser@zdm-hub ~]$ cat logical_migration.rsp # migration method MIGRATION_METHOD=ONLINE_LOGICAL DATA_TRANSFER_MEDIUM=OSS # target db 21c OCID and ADMIN USER TARGETDATABASE_OCID=ocid1.database.oc1.ap-sydney-1.anzxsljrqnlku6qael55wxathimtyjcttsaqepleeiflkv5fyuodcpglr2gq TARGETDATABASE_ADMINUSERNAME=SYSTEM # source db 12c SOURCEDATABASE_ADMINUSERNAME=SYSTEM SOURCEDATABASE_CONNECTIONDETAILS_HOST=ora12c.sub12020731300.soormavcn.oraclevcn.com SOURCEDATABASE_CONNECTIONDETAILS_PORT=1521 SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME=ora12c_pdb1.sub12020731300.soormavcn.oraclevcn.com SOURCECONTAINERDATABASE_ADMINUSERNAME=SYSTEM SOURCECONTAINERDATABASE_GGADMINUSERNAME=C##GGADMIN SOURCECONTAINERDATABASE_CONNECTIONDETAILS_HOST=ora12c.sub12020731300.soormavcn.oraclevcn.com SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PORT=1521 SOURCECONTAINERDATABASE_CONNECTIONDETAILS_SERVICENAME=ora12c_syd126.sub12020731300.soormavcn.oraclevcn.com SOURCECONTAINERDATABASE_ENVIRONMENT_NAME=ORACLE SOURCECONTAINERDATABASE_ENVIRONMENT_DBTYPE=ORACLE # target db(PDB) TARGETDATABASE_CONNECTIONDETAILS_HOST=ora21c.sub12020731300.soormavcn.oraclevcn.com TARGETDATABASE_CONNECTIONDETAILS_PORT=1521 TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME=ora21c_pdb1.sub12020731300.soormavcn.oraclevcn.com # oci cli OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID=ocid1.tenancy.oc1..aaaaaaaa4nkaodldkc4jltkndutjhgakrsdjlm5kmfohbtrtl637lxmq236a OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID=ocid1.user.oc1..aaaaaaaaptxleaw7w6ylmhb5ojggt2coxi6vzt2gfrgrcathxpadf5nxq5iq OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT=74:2c:75:f7:15:a8:8a:fa:0f:6a:05:64:50:9c:38:fd OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE=/home/zdmuser/.oci/oci_api_key.pem OCIAUTHENTICATIONDETAILS_REGIONID=ap-sydney-1 ## GoldenGate TARGETDATABASE_GGADMINUSERNAME=ggadmin SOURCEDATABASE_GGADMINUSERNAME=ggadmin GOLDENGATEHUB_ADMINUSERNAME=oggadmin GOLDENGATEHUB_URL=https://ogghub.sub12020731300.soormavcn.oraclevcn.com GOLDENGATEHUB_SOURCEDEPLOYMENTNAME=ZDM GOLDENGATEHUB_TARGETDEPLOYMENTNAME=ZDM GOLDENGATEHUB_COMPUTEID=ocid1.instance.oc1.ap-sydney-1.anzxsljrqnlku6qcxghwjeu3sry2344wfly4yu3qutitgfsff5dh6javatkq # data pump DATAPUMPSETTINGS_JOBMODE=SCHEMA DATAPUMPSETTINGS_SCHEMABATCH-1=DEMO DATAPUMPSETTINGS_DATAPUMPPARAMETERS_TABLEEXISTSACTION =REPLACE DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER=TRUE DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE=4 DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE=2 DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME=sdk0bdtnrmys DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME=MIG21C DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME=zdm_export DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH=/u01/app/oracle/zdm_export DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME=zdm_import DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH=/u01/app/oracle/zdm_import DATAPUMPSETTINGS_CREATEAUTHTOKEN=FALSE DATAPUMPSETTINGS_OMITENCRYPTIONCLAUSE=TRUE
Execute zdmcli in Evaluation mode
./zdmcli migrate database -sourcedb ora12c_syd126 -sourcenode ora12c.sub12020731300.soormavcn.oraclevcn.com -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/.ssh/id_rsa -srcarg3 sudo_location:/usr/bin/sudo -targetnode ora21c.sub12020731300.soormavcn.oraclevcn.com -rsp /home/zdmuser/logical_migration.rsp -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:/home/zdmuser/.ssh/id_rsa -tgtarg3 sudo_location:/usr/bin/sudo -eval
Provide the source and target database SYSTEM passwords as well as the password for the source and target database GoldenGate admin accounts. Also provide the password for the oggadmin account (GoldenGate deployment admin account) and the Auth Token value.
Note the zdmcli job number.
zdm-hub.sub12020731300.soormavcn.oraclevcn.com: Audit ID: 45 Enter source database administrative user "SYSTEM" password: Enter source database administrative user "ggadmin" password: Enter source container database administrative user "SYSTEM" password: Enter source container database administrative user "C##GGADMIN" password: Enter target database administrative user "SYSTEM" password: Enter target database administrative user "ggadmin" password: Enter Oracle GoldenGate hub administrative user "oggadmin" password: Enter Authentication Token for OCI user "ocid1.user.oc1..aaaaaaaaptxleaw7w6ylmhb5ojggt2coxi6vzt2gfrgrcathxpadf5nxq5iq": Operation "zdmcli migrate database" scheduled with the job ID "11".
Use the zdmcli query job command to check the status of the job.
Note the various stages the job goes through.
Since we have only run zdmcli in Evaluation mode, a number of the phases are not attempted.
We will see additional steps when we run zdmcli without the evaluation mode.
[zdmuser@zdm-hub bin]$ ./zdmcli query job -jobid 11 zdm-hub.sub12020731300.soormavcn.oraclevcn.com: Audit ID: 49 Job ID: 11 User: zdmuser Client: zdm-hub Job Type: "EVAL" Scheduled job command: "zdmcli migrate database -sourcedb ora12c_syd126 -sourcenode ora12c.sub12020731300.soormavcn.oraclevcn.com -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/.ssh/id_rsa -srcarg3 sudo_location:/usr/bin/sudo -targetnode ora21c.sub12020731300.soormavcn.oraclevcn.com -rsp /home/zdmuser/logical_migration.rsp -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:/home/zdmuser/.ssh/id_rsa -tgtarg3 sudo_location:/usr/bin/sudo -eval" Scheduled job execution start time: 2023-02-12T02:57:53Z. Equivalent local time: 2023-02-12 02:57:53 Current status: SUCCEEDED Result file path: "/u02/zdmuser/zdmbase/chkbase/scheduled/job-11-2023-02-12-02:57:57.log" Excluded objects file path: "/u02/zdmuser/zdmbase/chkbase/scheduled/job-11-filtered-objects-2023-02-12T02:58:32.741.json" Job execution start time: 2023-02-12 02:57:58 Job execution end time: 2023-02-12 03:04:03 Job execution elapsed time: 6 minutes 5 seconds ZDM_VALIDATE_TGT ...................... COMPLETED ZDM_VALIDATE_SRC ...................... COMPLETED ZDM_SETUP_SRC ......................... COMPLETED ZDM_PRE_MIGRATION_ADVISOR ............. COMPLETED ZDM_VALIDATE_GG_HUB ................... COMPLETED ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC .... COMPLETED ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT .... COMPLETED ZDM_PREPARE_DATAPUMP_SRC .............. COMPLETED ZDM_DATAPUMP_ESTIMATE_SRC ............. COMPLETED ZDM_CLEANUP_SRC ....................... COMPLETED
ZDM_VALIDATE_TGT phase: Checks connectivity to target database container and pluggable database. Checks parameter required for GoldenGate replication and also if the specified GoldenGate admin user has the required privileges.
[zdmuser@zdm-hub bin]$ vi /u02/zdmuser/zdmbase/chkbase/scheduled/job-5-2023-02-08-03:17:26.log zdm-hub: 2023-02-08T03:17:27.693Z : Starting zero downtime migrate operation ... zdm-hub: 2023-02-08T03:17:27.858Z : Executing phase ZDM_VALIDATE_TGT zdm-hub: 2023-02-08T03:17:27.956Z : Fetching details of user-managed OCI database "ocid1.database.oc1.ap-sydney-1.anzxsljrqnlku6qael55wxathimtyjcttsaqepleeiflkv5fyuodcpglr2gq" zdm-hub: 2023-02-08T03:17:29.774Z : Lifecycle state of OCI database : "Available" zdm-hub: 2023-02-08T03:17:31.087Z : Type of OCI database : "Virtual Machine Database System" zdm-hub: 2023-02-08T03:17:38.546Z : Verifying configuration and status of target database "ora21c_pdb1.sub12020731300.soormavcn.oraclevcn.com" zdm-hub: 2023-02-08T03:17:44.403Z : Global database name: ORA21C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM zdm-hub: 2023-02-08T03:17:44.404Z : Target PDB name : ORA21C_PDB1 zdm-hub: 2023-02-08T03:17:44.406Z : Database major version : 21 zdm-hub: 2023-02-08T03:17:44.438Z : obtaining database ORA21C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM tablespace configuration details... zdm-hub: 2023-02-08T03:17:47.717Z : Database parameter ENABLE_GOLDENGATE_REPLICATION is set to true. zdm-hub: 2023-02-08T03:17:47.721Z : Oracle GoldenGate database administrator user "C##GGADMIN" has required privileges. zdm-hub: 2023-02-08T03:17:47.723Z : Execution of phase ZDM_VALIDATE_TGT completed
ZDM_VALIDATE_SRC phase: checks source database container and pluggable database connectivity as well as if database configuration required to support GoldenGate – like archivelog mode, force logging, minimal supplemental logging, enable_goldengate_replication parameter etc.
zdm-hub: 2023-02-08T03:17:48.752Z : Executing phase ZDM_VALIDATE_SRC zdm-hub: 2023-02-08T03:17:50.542Z : Verifying configuration and status of source database "ora12c_pdb1.sub12020731300.soormavcn.oraclevcn.com" zdm-hub: 2023-02-08T03:17:50.548Z : source database host ora12c.sub12020731300.soormavcn.oraclevcn.com service ora12c_pdb1.sub12020731300.soormavcn.oraclevcn.com zdm-hub: 2023-02-08T03:18:01.269Z : Global database name: ORA12C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM zdm-hub: 2023-02-08T03:18:01.274Z : Source PDB name : ORA12C_PDB1 zdm-hub: 2023-02-08T03:18:01.276Z : Database major version : 12 zdm-hub: 2023-02-08T03:18:01.283Z : Validating database time zone compatibility... zdm-hub: 2023-02-08T03:18:01.357Z : Archive log mode : ARCHIVELOG zdm-hub: 2023-02-08T03:18:01.359Z : Minimal supplemental logging : YES zdm-hub: 2023-02-08T03:18:01.360Z : Force logging : YES zdm-hub: 2023-02-08T03:18:01.362Z : Database parameter ENABLE_GOLDENGATE_REPLICATION is set to true. zdm-hub: 2023-02-08T03:18:01.468Z : Oracle GoldenGate database administrator user "C##GGADMIN" has required privileges. zdm-hub: 2023-02-08T03:18:08.944Z : Oracle GoldenGate database administrator user "C##GGADMIN" has required privileges. zdm-hub: 2023-02-08T03:18:08.945Z : Database objects which will be migrated : [DEMO] zdm-hub: 2023-02-08T03:18:09.187Z : Execution of phase ZDM_VALIDATE_SRC completed
ZDM_PRE_MIGRATION_ADVISOR phase – internally executes CPAT ( Cloud Premigration Advisor Tool) – checks things like compatibility for OCI cloud migration, unsupported GoldenGate replication objects, database parameters like streams_pool_size etc
zdm-hub: 2023-02-08T03:18:09.554Z : Executing phase ZDM_SETUP_SRC
zdm-hub: 2023-02-08T03:22:08.925Z : Execution of phase ZDM_SETUP_SRC completed
zdm-hub: 2023-02-08T03:22:10.642Z : Executing phase ZDM_PRE_MIGRATION_ADVISOR
zdm-hub: 2023-02-08T03:22:15.818Z : Running CPAT (Cloud Premigration Advisor Tool) on the source node ora12c.sub12020731300.soormavcn.oraclevcn.com ...
zdm-hub: 2023-02-08T03:22:24.172Z : Premigration advisor output:
Cloud Premigration Advisor Tool Version 22.5.2
Cloud Premigration Advisor Tool completed with overall result: PASS
Cloud Premigration Advisor Tool generated report location: /u01/app/oracle/zdm/zdm_ora12c_5/out/premigration_advisor_report.json
Cloud Premigration Advisor Tool generated report location: /u01/app/oracle/zdm/zdm_ora12c_5/out/premigration_advisor_report.txt
CPAT exit code: 0
RESULT: PASS
Schemas Analyzed (1): DEMO
A total of 19 checks were performed
There were 0 checks with FATAL results
There were 0 checks with BLOCKER results
There were 0 checks with WARNING results
There were 0 checks with INFORMATIONAL results has_low_streams_pool_size
RESULT: PASS
DESCRIPTION: Verify the STREAMS_POOL_SIZE amount is large enough for migrations to start and work efficiently.
ACTION: Increase the minimum amount of memory for the STREAMS_POOL_SIZE as described in Oracle Support Document ID 1611373.1 (note that other database features may use the stream pool, therefor the exact value to use is instance dependent). If you cannot modify the STREAMS_POOL_SIZE dynamically, then you need to set the value in the spfile, and restart the database. Note that you may have to increase your SGA_TARGET or MEMORY_TARGET also.
timezone_table_compatibility_higher
RESULT: PASS
DESCRIPTION: The source database TZ_VERSION cannot be higher than the target TZ_VERSION.
ACTION: Request that Cloud Database Support change the Timezone Version on your target Database.
gg_user_objects_in_ggadmin_schemas
RESULT: PASS
DESCRIPTION: There should be no user objects in schemas that have Golden Gate admin privileges.
ACTION: Exclude these schemas from Golden Gate data migration.
gg_enabled_replication
RESULT: PASS
DESCRIPTION: ENABLE_GOLDENGATE_REPLICATION init.ora parameter is not set.
ACTION: Make sure ENABLE_GOLDENGATE_REPLICATION is set.
gg_supplemental_log_data_min
RESULT: PASS
DESCRIPTION: Minimal supplemental logging is not enabled on the Database.
ACTION: Make sure minimal supplemental logging data is enabled.
gg_force_logging
RESULT: PASS
DESCRIPTION: Forced logging mode forces the logging of all transactions and loads, overriding any user or storage settings to the contrary.
ACTION: Turn force logging on by executing 'ALTER DATABASE FORCE LOGGING'.
has_users_with_10g_password_version
RESULT: PASS
DESCRIPTION: Identify users that will not be able to log in post migration due to 10g password version use.
ACTION: To avoid DataPump migration warnings change the passwords for the listed users before migration. Alternatively, modify these users passwords after migration to avoid login failures. See Oracle Support Document ID 2289453.1 for more information.
nls_national_character_set
RESULT: PASS
DESCRIPTION: Check for issues caused by the conversion of character data from the source to the target national character set, such as expansion of character values beyond data type limits or loss of invalid character codes.
ACTION: If possible, provision the target cloud database with the same national character set as the source database and enable extended data types in the target cloud database.
has_columns_with_media_data_types
RESULT: PASS
DESCRIPTION: Multimedia object types such as those from ORDSYS have been desupported in Oracle Database 19c.
ACTION: Columns with Media data types are not allowed in Autonomous Database and Oracle Multimedia is desupported in 19c. Consider using SecureFiles LOBs.
has_external_tables_default
RESULT: PASS
DESCRIPTION: External tables cannot be migrated unless the DIRECTORY objects the tables rely on have been created.
ACTION: Pre-create the necessary DIRECTORY objects prior to migration or migrate using full mode.
has_profile_not_default
RESULT: PASS
DESCRIPTION: Identify schemas whose PROFILE is not available on the target system.
ACTION: Either use full mode in Data Pump and CPAT; or pre-create the needed profiles on the target system and use the "--analysisprops" option with a properties file created by using CPAT with "--gettargetprops" option.
gg_not_unique
RESULT: PASS
DESCRIPTION: For tables that have no Primary Key, Unique Index or Key Columns a Problematic Column indicates that the table has a column not useful in the predicate (where clause). The table column is defined using an unbounded data type, such as LONG or BLOB.
ACTION: For GoldenGate to identify the logical change, all columns needs to be supplementally logged. Log apply services will attempt to maintain these tables, but you must ensure the application does not allow uniqueness only in the unbounded columns.
gg_tables_not_supported
RESULT: PASS
DESCRIPTION: Ensure all objects can be replicated using Oracle GoldenGate.
ACTION: The listed relevant objects need to be moved to the target database at the time of the switchover using another method such as DataPump.
nls_character_set_conversion
RESULT: PASS
DESCRIPTION: Check for issues caused by conversion of character data from the source to the target database character set, such as expansion of character values beyond column length or loss of invalid character codes.
ACTION: Scan the schemas to be migrated using Database Migration Assistant for Unicode (DMU) and analyze all possible convertibility issues.
nls_nchar_ora_910
RESULT: PASS
DESCRIPTION: Check for NCHAR and NVARCHAR2 columns whose character length are greater than the maximum NCHAR and NVARCHAR2 column length for the national database character set of the target database.
ACTION: If possible, provision the target cloud database with the same national character set as the source database and enable the Extended Data Types in the target cloud database.
has_absent_default_tablespace
RESULT: PASS
DESCRIPTION: Schema Owner's default tablespace must exist.
ACTION: If the schemas are no longer being used then they should be dropped. If the schemas are of use then they should be given a valid default tablespace.
has_absent_temp_tablespace
RESULT: PASS
DESCRIPTION: Schema Owner's temporary tablespace must exist.
ACTION: Create the needed temporary tablespaces on ADBD prior to migration or use tablespace remapping parameters to map other tablespaces into the TEMP tablespace when invoking migration tooling. Oracle's Zero Downtime Migration and Database Migration Service can do tablespace pre-creation and mapping automatically.
has_sqlt_objects_default
RESULT: PASS
DESCRIPTION: SQLTXPLAIN (SQLT) installs objects that are not exported by Data Pump.
ACTION: SQLTXPLAIN users should run sqcreate.sql in the target environment after import. The sqcreate.sql script runs sqdrop.sql and then re-installs all required objects. See Oracle Support Document ID 1614107.1 for more information.
zdm-hub: 2023-02-08T03:22:24.182Z : Execution of phase ZDM_PRE_MIGRATION_ADVISOR completed
ZDM_VALIDATE_GG_HUB phase – checks connectivity to the GoldenGate hub compute node, status of GoldenGate microservices processes, checks connectivity from OGG to both source and target database.
zdm-hub: 2023-02-08T03:22:52.653Z : Executing phase ZDM_VALIDATE_GG_HUB zdm-hub: 2023-02-08T03:22:52.756Z : Verifying status of Oracle GoldenGate Microservices at URL "https://ogghub.sub12020731300.soormavcn.oraclevcn.com" zdm-hub: 2023-02-08T03:22:56.144Z : Oracle GoldenGate Service Manager is healthy. zdm-hub: 2023-02-08T03:22:56.869Z : Status of Oracle GoldenGate deployment "ZDM": RUNNING zdm-hub: 2023-02-08T03:22:58.177Z : Status of Oracle GoldenGate deployment "ZDM": RUNNING zdm-hub: 2023-02-08T03:22:58.179Z : Data directory for Oracle GoldenGate deployment "ZDM": /u02/trails zdm-hub: 2023-02-08T03:22:58.803Z : Oracle GoldenGate Microservice "adminsrvr" in deployment "ZDM" is healthy. zdm-hub: 2023-02-08T03:22:59.464Z : Oracle GoldenGate deployment "ZDM" supports databases of version "ORACLE". zdm-hub: 2023-02-08T03:23:00.274Z : Oracle GoldenGate Microservice "adminsrvr" in deployment "ZDM" is healthy. zdm-hub: 2023-02-08T03:23:04.687Z : Oracle GoldenGate deployment "ZDM" supports databases of version "ORACLE". zdm-hub: 2023-02-08T03:23:06.033Z : created a new alias in credential store in Oracle GoldenGate deployment "ZDM" for target database zdm-hub: 2023-02-08T03:23:08.133Z : verified connection to target database from Oracle GoldenGate deployment "ZDM" zdm-hub: 2023-02-08T03:23:10.178Z : created a new alias in credential store in Oracle GoldenGate deployment "ZDM" for source database zdm-hub: 2023-02-08T03:23:11.567Z : verified connection to source database from Oracle GoldenGate deployment "ZDM" zdm-hub: 2023-02-08T03:23:12.912Z : created a new alias in credential store in Oracle GoldenGate deployment "ZDM" for source database zdm-hub: 2023-02-08T03:23:13.733Z : verified connection to source database from Oracle GoldenGate deployment "ZDM" zdm-hub: 2023-02-08T03:23:14.352Z : Execution of phase ZDM_VALIDATE_GG_HUB completed
ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC and ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT phases – validates Data Pump Export and Import directories and does a test transfer of a dummy export dump file to OCI Object Storage bucket.
zdm-hub: 2023-02-08T03:23:15.832Z : Executing phase ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC zdm-hub: 2023-02-08T03:23:19.572Z : validating Oracle Data Pump dump directory /u01/app/oracle/zdm_export ... zdm-hub: 2023-02-08T03:23:19.595Z : validating Data Pump dump directory path /u01/app/oracle/zdm_export on node ora12c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-08T03:23:21.738Z : validating data transfer medium OSS ... zdm-hub: 2023-02-08T03:23:21.739Z : executing transfer validation using provisional file zdm_validate_transfer_5503 ... zdm-hub: 2023-02-08T03:23:21.958Z : uploading Data Pump dump to object storage from directory path /u01/app/oracle/zdm_export on node ora12c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub.sub12020731300.soormavcn.oraclevcn.com: number of dumps transferred in parallel : 3 zdm-hub.sub12020731300.soormavcn.oraclevcn.com: starting transfer of dump zdm_validate_transfer_5503 zdm-hub.sub12020731300.soormavcn.oraclevcn.com: completed transfer of dump zdm_validate_transfer_5503 zdm-hub: 2023-02-08T03:23:33.631Z : deleting provisional file zdm_validate_transfer_5503 ... zdm-hub: 2023-02-08T03:23:33.637Z : deleting Data Pump dump in directory path /u01/app/oracle/zdm_export on node ora12c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-08T03:23:34.825Z : Execution of phase ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC completed zdm-hub: 2023-02-08T03:23:35.850Z : Executing phase ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT zdm-hub: 2023-02-08T03:23:41.159Z : validating Oracle Data Pump dump directory /u01/app/oracle/zdm_import ... zdm-hub: 2023-02-08T03:23:41.160Z : validating data transfer medium OSS ... zdm-hub: 2023-02-08T03:23:41.162Z : executing transfer validation using provisional file zdm_validate_transfer_5503 ... zdm-hub: 2023-02-08T03:23:53.016Z : deleting provisional file zdm_validate_transfer_5503 ... zdm-hub: 2023-02-08T03:23:53.020Z : deleting Data Pump dump in directory path /u01/app/oracle/zdm_import on node ora21c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-08T03:24:01.844Z : Execution of phase ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT completed zdm-hub: 2023-02-08T03:24:02.347Z : Executing phase ZDM_PREPARE_DATAPUMP_SRC zdm-hub: 2023-02-08T03:24:02.359Z : Execution of phase ZDM_PREPARE_DATAPUMP_SRC completed zdm-hub: 2023-02-08T03:24:02.869Z : Executing phase ZDM_DATAPUMP_ESTIMATE_SRC zdm-hub: 2023-02-08T03:24:02.946Z : starting Data Pump Dump estimate for database "ORA12C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" zdm-hub: 2023-02-08T03:24:04.383Z : running Oracle Data Pump job "ZDM_5_DP_ESTIMATE_4168" for database "ORA12C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" zdm-hub: 2023-02-08T03:24:04.550Z : applying Data Pump dump compression ALL algorithm MEDIUM zdm-hub: 2023-02-08T03:24:05.303Z : applying Data Pump dump encryption ALL algorithm AES128 zdm-hub: 2023-02-08T03:24:05.306Z : Oracle Data Pump Export parallelism set to 2 ... zdm-hub: 2023-02-08T03:24:05.431Z : Oracle Data Pump errors to be ignored are ORA-31684,ORA-39111,ORA-39082... zdm-hub: 2023-02-08T03:24:19.459Z : Oracle Data Pump log located at /u01/app/oracle/zdm_export/ZDM_5_DP_ESTIMATE_4168.log in the Database Server node zdm-hub: 2023-02-08T03:24:49.786Z : Total estimation using BLOCKS method: 13.62 MB zdm-hub: 2023-02-08T03:24:50.271Z : Execution of phase ZDM_DATAPUMP_ESTIMATE_SRC completed zdm-hub: 2023-02-08T03:24:50.672Z : Executing phase ZDM_CLEANUP_SRC zdm-hub: 2023-02-08T03:24:51.951Z : Cleaning up ZDM on the source node ora12c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-08T03:24:53.379Z : Execution of phase ZDM_CLEANUP_SRC completed
Execute zdmcli – migration mode
We execute the same zdmcli command which we had executed earlier, but we are not completing the ZDM migration at this stage.
The phase ZDM_MONITOR_GG_LAG is the stage where GoldenGate real-time replication has been set up between the source and the target databases. The Extract and Replicat processes are configured by ZDM as well as the GoldenGate Heartbeat tables to monitor lag.
Maybe we can continue in this ZDM phase for a period of time where we can connect to the target database and run some data validation checks – or even test application queries while connected to the target database (which in this case is an upgraded version of the source) and do some kind of performance testing as well.
[zdmuser@zdm-hub bin]$ ./zdmcli migrate database -sourcedb ora12c_syd126 -sourcenode ora12c.sub12020731300.soormavcn.oraclevcn.com -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/.ssh/id_rsa -srcarg3 sudo_location:/usr/bin/sudo -targetnode ora21c.sub12020731300.soormavcn.oraclevcn.com -rsp /home/zdmuser/logical_migration.rsp -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:/home/zdmuser/.ssh/id_rsa -tgtarg3 sudo_location:/usr/bin/sudo -pauseafter ZDM_MONITOR_GG_LAG
[zdmuser@zdm-hub bin]$ ./zdmcli migrate database -sourcedb ora12c_syd126 -sourcenode ora12c.sub12020731300.soormavcn.oraclevcn.com -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/.ssh/id_rsa -srcarg3 sudo_location:/usr/bin/sudo -targetnode ora21c.sub12020731300.soormavcn.oraclevcn.com -rsp /home/zdmuser/logical_migration.rsp -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:/home/zdmuser/.ssh/id_rsa -tgtarg3 sudo_location:/usr/bin/sudo -pauseafter ZDM_MONITOR_GG_LAG zdm-hub.sub12020731300.soormavcn.oraclevcn.com: Audit ID: 50 Enter source database administrative user "SYSTEM" password: Enter source database administrative user "ggadmin" password: Enter source container database administrative user "SYSTEM" password: Enter source container database administrative user "C##GGADMIN" password: Enter target database administrative user "SYSTEM" password: Enter target database administrative user "ggadmin" password: Enter Oracle GoldenGate hub administrative user "oggadmin" password: Enter Authentication Token for OCI user "ocid1.user.oc1..aaaaaaaaptxleaw7w6ylmhb5ojggt2coxi6vzt2gfrgrcathxpadf5nxq5iq": Operation "zdmcli migrate database" scheduled with the job ID "12".
Query the ZDM job and note the phases which have status of COMPLETED and which have a status of PENDING.
[zdmuser@zdm-hub bin]$ ./zdmcli query job -jobid 12 zdm-hub.sub12020731300.soormavcn.oraclevcn.com: Audit ID: 52 Job ID: 12 User: zdmuser Client: zdm-hub Job Type: "MIGRATE" Scheduled job command: "zdmcli migrate database -sourcedb ora12c_syd126 -sourcenode ora12c.sub12020731300.soormavcn.oraclevcn.com -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/.ssh/id_rsa -srcarg3 sudo_location:/usr/bin/sudo -targetnode ora21c.sub12020731300.soormavcn.oraclevcn.com -rsp /home/zdmuser/logical_migration.rsp -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:/home/zdmuser/.ssh/id_rsa -tgtarg3 sudo_location:/usr/bin/sudo -pauseafter ZDM_MONITOR_GG_LAG" Scheduled job execution start time: 2023-02-12T03:10:18Z. Equivalent local time: 2023-02-12 03:10:18 Current status: PAUSED Current Phase: "ZDM_MONITOR_GG_LAG" Result file path: "/u02/zdmuser/zdmbase/chkbase/scheduled/job-12-2023-02-12-03:10:34.log" Excluded objects file path: "/u02/zdmuser/zdmbase/chkbase/scheduled/job-12-filtered-objects-2023-02-12T03:11:09.407.json" Job execution start time: 2023-02-12 03:10:34 Job execution end time: 2023-02-12 03:24:35 Job execution elapsed time: 14 minutes 0 seconds ZDM_VALIDATE_TGT ...................... COMPLETED ZDM_VALIDATE_SRC ...................... COMPLETED ZDM_SETUP_SRC ......................... COMPLETED ZDM_PRE_MIGRATION_ADVISOR ............. COMPLETED ZDM_VALIDATE_GG_HUB ................... COMPLETED ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC .... COMPLETED ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT .... COMPLETED ZDM_PREPARE_DATAPUMP_SRC .............. COMPLETED ZDM_DATAPUMP_ESTIMATE_SRC ............. COMPLETED ZDM_PREPARE_GG_HUB .................... COMPLETED ZDM_ADD_HEARTBEAT_SRC ................. COMPLETED ZDM_ADD_SCHEMA_TRANDATA_SRC ........... COMPLETED ZDM_CREATE_GG_EXTRACT_SRC ............. COMPLETED ZDM_PREPARE_DATAPUMP_TGT .............. COMPLETED ZDM_PARALLEL_EXPORT_IMPORT ............ COMPLETED ZDM_POST_DATAPUMP_SRC ................. COMPLETED ZDM_POST_DATAPUMP_TGT ................. COMPLETED ZDM_ADD_HEARTBEAT_TGT ................. COMPLETED ZDM_ADD_CHECKPOINT_TGT ................ COMPLETED ZDM_CREATE_GG_REPLICAT_TGT ............ COMPLETED ZDM_MONITOR_GG_LAG .................... COMPLETED ZDM_SWITCHOVER_APP .................... PENDING ZDM_RM_GG_EXTRACT_SRC ................. PENDING ZDM_RM_GG_REPLICAT_TGT ................ PENDING ZDM_DELETE_SCHEMA_TRANDATA_SRC ........ PENDING ZDM_RM_HEARTBEAT_SRC .................. PENDING ZDM_RM_CHECKPOINT_TGT ................. PENDING ZDM_RM_HEARTBEAT_TGT .................. PENDING ZDM_CLEAN_GG_HUB ...................... PENDING ZDM_POST_ACTIONS ...................... PENDING ZDM_CLEANUP_SRC ....................... PENDING Pause After Phase: "ZDM_MONITOR_GG_LAG"
In the phase ZDM_PREPARE_GG_HUB, the GoldenGate environment on the OGG hub is configured – like the credential store and Heartbeat tables for the source database connection and the GoldenGate Extract process is started in the phase ZDM_CREATE_GG_EXTRACT_SRC.
zdm-hub: 2023-02-12T03:16:25.343Z : Executing phase ZDM_PREPARE_GG_HUB zdm-hub: 2023-02-12T03:16:26.091Z : created a new alias in credential store in Oracle GoldenGate deployment "ZDM" for target database zdm-hub: 2023-02-12T03:16:26.585Z : verified connection to target database from Oracle GoldenGate deployment "ZDM" zdm-hub: 2023-02-12T03:16:27.104Z : created a new alias in credential store in Oracle GoldenGate deployment "ZDM" for source database zdm-hub: 2023-02-12T03:16:27.867Z : verified connection to source database from Oracle GoldenGate deployment "ZDM" zdm-hub: 2023-02-12T03:16:28.634Z : created a new alias in credential store in Oracle GoldenGate deployment "ZDM" for source database zdm-hub: 2023-02-12T03:16:29.346Z : verified connection to source database from Oracle GoldenGate deployment "ZDM" zdm-hub: 2023-02-12T03:16:30.069Z : Execution of phase ZDM_PREPARE_GG_HUB completed zdm-hub: 2023-02-12T03:16:30.738Z : Executing phase ZDM_ADD_HEARTBEAT_SRC zdm-hub: 2023-02-12T03:16:32.523Z : created the heartbeat table for database connection "domain1676171785352.srcalias1676171785353" zdm-hub: 2023-02-12T03:16:34.301Z : retrieved details about the heartbeat table for database connection "domain1676171785352.srcalias1676171785353" zdm-hub: 2023-02-12T03:16:34.304Z : frequency of heartbeat table for database connection "domain1676171785352.srcalias1676171785353" : 60 zdm-hub: 2023-02-12T03:16:34.305Z : Execution of phase ZDM_ADD_HEARTBEAT_SRC completed zdm-hub: 2023-02-12T03:16:34.444Z : Executing phase ZDM_ADD_SCHEMA_TRANDATA_SRC zdm-hub: 2023-02-12T03:16:36.070Z : enabled schema-level supplemental logging for source schema "DEMO" zdm-hub: 2023-02-12T03:16:36.858Z : number of prepared tables for source schema "DEMO" : 3 zdm-hub: 2023-02-12T03:16:36.859Z : Execution of phase ZDM_ADD_SCHEMA_TRANDATA_SRC completed zdm-hub: 2023-02-12T03:16:37.060Z : Executing phase ZDM_CREATE_GG_EXTRACT_SRC zdm-hub: 2023-02-12T03:16:44.400Z : created Oracle GoldenGate integrated extract process "EXTIAMXP" zdm-hub: 2023-02-12T03:16:44.698Z : Status of extract process "EXTIAMXP" : STOPPED zdm-hub: 2023-02-12T03:16:44.699Z : Extract process "EXTIAMXP" lag : 0 seconds zdm-hub: 2023-02-12T03:16:44.701Z : Extract process "EXTIAMXP" position : 0.0 zdm-hub: 2023-02-12T03:16:45.201Z : starting Oracle GoldenGate extract process "EXTIAMXP" zdm-hub: 2023-02-12T03:16:45.202Z : waiting for Oracle GoldenGate Extract process "EXTIAMXP" to start zdm-hub: 2023-02-12T03:18:45.540Z : Status of extract process "EXTIAMXP" : RUNNING zdm-hub: 2023-02-12T03:18:45.542Z : Extract process "EXTIAMXP" lag : 2 seconds zdm-hub: 2023-02-12T03:18:45.544Z : Extract process "EXTIAMXP" position : 0.3933345 zdm-hub: 2023-02-12T03:18:47.701Z : Execution of phase ZDM_CREATE_GG_EXTRACT_SRC completed
If we open the ZDM job log file, we can see the phases where the Data Pump export has been performed and then the dump files copied to the designated OCI object storage bucket followed by the Data Pump import on the target database.
zdm-hub: 2023-02-12T03:18:47.955Z : Executing phase ZDM_PREPARE_DATAPUMP_TGT zdm-hub: 2023-02-12T03:18:47.998Z : creating tablespaces in the target database... zdm-hub: 2023-02-12T03:18:48.248Z : Execution of phase ZDM_PREPARE_DATAPUMP_TGT completed zdm-hub: 2023-02-12T03:18:48.453Z : Executing phase ZDM_PARALLEL_EXPORT_IMPORT zdm-hub: 2023-02-12T03:18:48.544Z : Executing phase ZDM_DATAPUMP_EXPORT_SRC_BATCH1 zdm-hub: 2023-02-12T03:18:48.547Z : starting Data Pump Export for database "ORA12C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" zdm-hub: 2023-02-12T03:18:49.242Z : running Oracle Data Pump job "ZDM_12_DP_EXPORT_7638_BATCH1" for database "ORA12C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" zdm-hub: 2023-02-12T03:18:49.269Z : Oracle Data Pump Export dump file size set to 5000M ... zdm-hub: 2023-02-12T03:18:49.281Z : applying Data Pump dump compression ALL algorithm MEDIUM zdm-hub: 2023-02-12T03:18:49.965Z : applying Data Pump dump encryption ALL algorithm AES128 zdm-hub: 2023-02-12T03:18:49.967Z : Oracle Data Pump Export parallelism set to 2 ... zdm-hub: 2023-02-12T03:18:49.977Z : Oracle Data Pump errors to be ignored are ORA-31684,ORA-39111,ORA-39082... zdm-hub: 2023-02-12T03:19:28.754Z : Oracle Data Pump log ZDM_12_DP_EXPORT_7638_BATCH1.log uploaded to Oracle cloud storage bucket MIG21C zdm-hub: 2023-02-12T03:19:59.015Z : Oracle Data Pump job "ZDM_12_DP_EXPORT_7638_BATCH1" for database "ORA12C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" completed. zdm-hub: 2023-02-12T03:19:59.412Z : Execution of phase ZDM_DATAPUMP_EXPORT_SRC_BATCH1 completed zdm-hub: 2023-02-12T03:19:59.436Z : listing directory path /u01/app/oracle/zdm_export on node ora12c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-12T03:20:00.043Z : Executing phase ZDM_UPLOAD_DUMPS_SRC_BATCH1 zdm-hub: 2023-02-12T03:20:00.090Z : uploading Data Pump dump to object storage from directory path /u01/app/oracle/zdm_export on node ora12c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub.sub12020731300.soormavcn.oraclevcn.com: number of dumps transferred in parallel : 3 zdm-hub.sub12020731300.soormavcn.oraclevcn.com: starting transfer of dump ZDM_12_DP_EXPORT_7638_BATCH1_dmp_4_01.dmp,ZDM_12_DP_EXPORT_7638_BATCH1_dmp_3_01.dmp,ZDM_12_DP_EXPORT_7638_BATCH1_dmp_2_01.dmp zdm-hub.sub12020731300.soormavcn.oraclevcn.com: completed transfer of dump ZDM_12_DP_EXPORT_7638_BATCH1_dmp_4_01.dmp,ZDM_12_DP_EXPORT_7638_BATCH1_dmp_3_01.dmp,ZDM_12_DP_EXPORT_7638_BATCH1_dmp_2_01.dmp zdm-hub.sub12020731300.soormavcn.oraclevcn.com: starting transfer of dump ZDM_12_DP_EXPORT_7638_BATCH1_dmp_5_01.dmp,ZDM_12_DP_EXPORT_7638_BATCH1_dmp_1_01.dmp zdm-hub.sub12020731300.soormavcn.oraclevcn.com: completed transfer of dump ZDM_12_DP_EXPORT_7638_BATCH1_dmp_5_01.dmp,ZDM_12_DP_EXPORT_7638_BATCH1_dmp_1_01.dmp zdm-hub: 2023-02-12T03:20:04.825Z : Execution of phase ZDM_UPLOAD_DUMPS_SRC_BATCH1 completed zdm-hub: 2023-02-12T03:20:04.842Z : Executing phase ZDM_DATAPUMP_IMPORT_TGT_BATCH1 zdm-hub: 2023-02-12T03:21:03.043Z : listing directory path /u01/app/oracle/zdm_import on node ora21c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-12T03:21:04.462Z : Oracle Data Pump Import parallelism set to 4 ... zdm-hub: 2023-02-12T03:21:04.510Z : Oracle Data Pump errors to be ignored are ORA-31684,ORA-39111,ORA-39082... zdm-hub: 2023-02-12T03:21:04.532Z : starting Data Pump Import for database "ORA21C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" zdm-hub: 2023-02-12T03:21:04.533Z : running Oracle Data Pump job "ZDM_12_DP_IMPORT_4834_BATCH1" for database "ORA21C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" zdm-hub: 2023-02-12T03:21:23.118Z : Oracle Data Pump job "ZDM_12_DP_IMPORT_4834_BATCH1" for database "ORA21C_PDB1.SUB12020731300.SOORMAVCN.ORACLEVCN.COM" completed. zdm-hub: 2023-02-12T03:21:45.638Z : Oracle Data Pump log ZDM_12_DP_IMPORT_4834_BATCH1.log uploaded to Oracle cloud storage bucket MIG21C zdm-hub: 2023-02-12T03:22:15.999Z : Execution of phase ZDM_DATAPUMP_IMPORT_TGT_BATCH1 completed zdm-hub: 2023-02-12T03:22:16.092Z : Execution of phase ZDM_PARALLEL_EXPORT_IMPORT completed zdm-hub: 2023-02-12T03:22:16.787Z : Executing phase ZDM_POST_DATAPUMP_SRC zdm-hub: 2023-02-12T03:22:17.027Z : Execution of phase ZDM_POST_DATAPUMP_SRC completed zdm-hub: 2023-02-12T03:22:17.348Z : Executing phase ZDM_POST_DATAPUMP_TGT zdm-hub: 2023-02-12T03:22:17.439Z : deleting Data Pump dump in directory path /u01/app/oracle/zdm_import on node ora21c.sub12020731300.soormavcn.oraclevcn.com ... zdm-hub: 2023-02-12T03:22:19.635Z : Execution of phase ZDM_POST_DATAPUMP_TGT completed
After the Data Pump import has been completed on the target database, the GoldenGate Replicat process is configured and started.
The Replicat will process the trail file(s) and apply the changes to the target database. Note that GoldenGate and Data Pump are integrated and the Replicat process is aware of the SCN at which the source database export was performed – using that SCN, it is able to ignore or process the transactions as the case may be.
zdm-hub: 2023-02-12T03:22:19.839Z : Executing phase ZDM_ADD_HEARTBEAT_TGT zdm-hub: 2023-02-12T03:22:21.876Z : created the heartbeat table for database connection "domain1676171785352.tgtalias1676171785352" zdm-hub: 2023-02-12T03:22:23.971Z : retrieved details about the heartbeat table for database connection "domain1676171785352.tgtalias1676171785352" zdm-hub: 2023-02-12T03:22:23.973Z : frequency of heartbeat table for database connection "domain1676171785352.tgtalias1676171785352" : 0 zdm-hub: 2023-02-12T03:22:23.976Z : Execution of phase ZDM_ADD_HEARTBEAT_TGT completed zdm-hub: 2023-02-12T03:22:24.156Z : Executing phase ZDM_ADD_CHECKPOINT_TGT zdm-hub: 2023-02-12T03:22:25.047Z : created the Oracle GoldenGate checkpoint table for database connection "domain1676171785352.tgtalias1676171785352" zdm-hub: 2023-02-12T03:22:25.678Z : retrieved details about the Oracle GoldenGate checkpoint table for database connection "domain1676171785352.tgtalias1676171785352" zdm-hub: 2023-02-12T03:22:25.680Z : Execution of phase ZDM_ADD_CHECKPOINT_TGT completed zdm-hub: 2023-02-12T03:22:26.144Z : Executing phase ZDM_CREATE_GG_REPLICAT_TGT zdm-hub: 2023-02-12T03:22:27.524Z : created Oracle GoldenGate parallel replicat process "RRF1Y" zdm-hub: 2023-02-12T03:22:27.919Z : Status of Oracle GoldenGate replicat process "RRF1Y" : STOPPED zdm-hub: 2023-02-12T03:22:27.921Z : Replicat process "RRF1Y" lag : 0 seconds zdm-hub: 2023-02-12T03:22:28.154Z : starting Oracle GoldenGate replicat process "RRF1Y" zdm-hub: 2023-02-12T03:22:28.154Z : waiting for Oracle GoldenGate replicat process "RRF1Y" to start zdm-hub: 2023-02-12T03:24:28.483Z : Status of Oracle GoldenGate replicat process "RRF1Y" : RUNNING zdm-hub: 2023-02-12T03:24:28.486Z : Replicat process "RRF1Y" lag : 0 seconds zdm-hub: 2023-02-12T03:24:28.490Z : Execution of phase ZDM_CREATE_GG_REPLICAT_TGT completed zdm-hub: 2023-02-12T03:24:28.671Z : Executing phase ZDM_MONITOR_GG_LAG zdm-hub: 2023-02-12T03:24:29.718Z : Status of extract process "EXTIAMXP" : RUNNING zdm-hub: 2023-02-12T03:24:29.719Z : "EXTIAMXP" is processing trail file "SV" with sequence number "0" at offset "12490" zdm-hub: 2023-02-12T03:24:29.733Z : Extract process "EXTIAMXP" lag : 2 seconds (age : 7 seconds) zdm-hub: 2023-02-12T03:24:30.493Z : Status of Oracle GoldenGate replicat process "RRF1Y" : RUNNING zdm-hub: 2023-02-12T03:24:30.495Z : "RRF1Y" is processing trail file "SV" with sequence number "0" at offset "12490" zdm-hub: 2023-02-12T03:24:31.168Z : "RRF1Y" is reading from same trail file that "EXTIAMXP" is writing to zdm-hub: 2023-02-12T03:24:31.950Z : Status of extract process "EXTIAMXP" : RUNNING zdm-hub: 2023-02-12T03:24:31.952Z : "EXTIAMXP" is processing trail file "SV" with sequence number "0" at offset "12490" zdm-hub: 2023-02-12T03:24:31.953Z : Extract process "EXTIAMXP" lag : 2 seconds (age : 9 seconds) zdm-hub: 2023-02-12T03:24:32.792Z : Status of Oracle GoldenGate replicat process "RRF1Y" : RUNNING zdm-hub: 2023-02-12T03:24:32.794Z : "RRF1Y" is processing trail file "SV" with sequence number "0" at offset "12490" zdm-hub: 2023-02-12T03:24:33.507Z : Replication throughput: 0.0 GBPH zdm-hub: 2023-02-12T03:24:34.655Z : End-to-end lag: 0.89 seconds (age: 2.54 seconds) zdm-hub: 2023-02-12T03:24:34.655Z : Execution of phase ZDM_MONITOR_GG_LAG completed zdm-hub: 2023-02-12T03:24:35.155Z : Job execution paused after phase "ZDM_MONITOR_GG_LAG".
We can connect to the GoldenGate deployment which is configured internally by ZDM and can do that from both the Deployment Console or the command line adminclient utility as shown below.
OGG (https://192.9.161.239 ZDM as tgtalias1676016538590@ORA21C/CDB$ROOT) 170> connect https://192.9.161.239 deployment ZDM as oggadmin password QIJACUH4hLqCq_.o ! OGG (https://192.9.161.239 ZDM) 171> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT RUNNING EXTIAMXP INTEGRATED 00:00:00 00:00:03 REPLICAT RUNNING RRF1Y PARALLEL NONINT 00:00:00 00:00:05
