{"id":34352,"date":"2024-07-30T08:53:40","date_gmt":"2024-07-30T06:53:40","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=34352"},"modified":"2024-07-30T08:53:43","modified_gmt":"2024-07-30T06:53:43","slug":"dry-run-with-zdm-physical-online-with-no-downtime-for-the-source","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/","title":{"rendered":"Dry Run with ZDM Physical Online with no Downtime for the source"},"content":{"rendered":"\n<p>I have been sharing my experience migrating On-Premises database to ExaCC using ZDM Physical Online, see my previous blog : <a href=\"https:\/\/www.dbi-services.com\/blog\/zdm-physical-online-migration-a-success-story\/\">https:\/\/www.dbi-services.com\/blog\/zdm-physical-online-migration-a-success-story\/<\/a><\/p>\n\n\n\n<p>In this blog I will share how you can make a Dry Run migration on your own without impacting the source On-Premises database, so without having any downtime during the migration steps. In this blog, I will just mention the steps that you need to adapt from a normal migration. All others steps will remain the same, and if not already done, a previous short downtime on the source database is to plan to configure TDE encryption, knowing a database restart is needed after changing the instance parameters. We will keep the same naming convention from previous blog, that&#8217;s to say:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ONPR: On-Premises database to migrate<\/li>\n\n\n\n<li>ONPRZ_APP_001T: Final PDB Name<\/li>\n\n\n\n<li>ExaCC-cl01n1: ExaCC cluster node 1<\/li>\n\n\n\n<li>vmonpr: Host On-Premises server<\/li>\n\n\n\n<li>zdmhost: VM running ZDM software<\/li>\n<\/ul>\n\n\n<a class=\"wp-block-read-more\" href=\"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/\" target=\"_self\">Read more<span class=\"screen-reader-text\">: Dry Run with ZDM Physical Online with no Downtime for the source<\/span><\/a>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-checking-data-guard-status\">Checking Data Guard status<\/h2>\n\n\n\n<p>Once the migration with pause after ZDM_CONFIGURE_DG_SRC phase has been completed successfully, we have our ONPR On-Premises database as primary, and the ZDM temporary database on the ExaCC with db_unique_name the final PDB Name, onprz_app_001t, as standby. Both in sync.<\/p>\n\n\n\n<p>ZDM job status is in paused status after Data Guard has been configured:<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,9]\">\n[zdmuser@zdmhost ~]$ \/u01\/app\/oracle\/product\/zdm\/bin\/zdmcli query job -jobid 280\nzdmhost.domain.com: Audit ID: 3494\nJob ID: 280\nUser: zdmuser\nClient: zdmhost\nJob Type: \"MIGRATE\"\nScheduled job command: \"zdmcli migrate database -sourcesid ONPR -rsp \/home\/zdmuser\/migration\/zdm_ONPR_physical_online.rsp -sourcenode vmonpr -srcauth zdmauth -srcarg1 user:oracle -srcarg2 identity_file:\/home\/zdmuser\/.ssh\/id_rsa -srcarg3 sudo_location:\/usr\/bin\/sudo -targetnode ExaCC-cl01n1 -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:\/home\/zdmuser\/.ssh\/id_rsa -tgtarg3 sudo_location:\/usr\/bin\/sudo -tdekeystorepasswd -tgttdekeystorepasswd -pauseafter ZDM_CONFIGURE_DG_SRC\"\nScheduled job execution start time: 2024-07-29T16:01:23+02. Equivalent local time: 2024-07-29 16:01:23\nCurrent status: PAUSED\nCurrent Phase: \"ZDM_CONFIGURE_DG_SRC\"\nResult file path: \"\/u01\/app\/oracle\/chkbase\/scheduled\/job-280-2024-07-29-16:01:46.log\"\nMetrics file path: \"\/u01\/app\/oracle\/chkbase\/scheduled\/job-280-2024-07-29-16:01:46.json\"\nJob execution start time: 2024-07-29 16:01:46\nJob execution end time: 2024-07-29 16:19:54\nJob execution elapsed time: 14 minutes 56 seconds\nZDM_GET_SRC_INFO ................ COMPLETED\nZDM_GET_TGT_INFO ................ COMPLETED\nZDM_PRECHECKS_SRC ............... COMPLETED\nZDM_PRECHECKS_TGT ............... COMPLETED\nZDM_SETUP_SRC ................... COMPLETED\nZDM_SETUP_TGT ................... COMPLETED\nZDM_PREUSERACTIONS .............. COMPLETED\nZDM_PREUSERACTIONS_TGT .......... COMPLETED\nZDM_VALIDATE_SRC ................ COMPLETED\nZDM_VALIDATE_TGT ................ COMPLETED\nZDM_DISCOVER_SRC ................ COMPLETED\nZDM_COPYFILES ................... COMPLETED\nZDM_PREPARE_TGT ................. COMPLETED\nZDM_SETUP_TDE_TGT ............... COMPLETED\nZDM_RESTORE_TGT ................. COMPLETED\nZDM_RECOVER_TGT ................. COMPLETED\nZDM_FINALIZE_TGT ................ COMPLETED\nZDM_CONFIGURE_DG_SRC ............ COMPLETED\nZDM_SWITCHOVER_SRC .............. PENDING\nZDM_SWITCHOVER_TGT .............. PENDING\nZDM_POST_DATABASE_OPEN_TGT ...... PENDING\nZDM_NONCDBTOPDB_PRECHECK ........ PENDING\nZDM_NONCDBTOPDB_CONVERSION ...... PENDING\nZDM_POST_MIGRATE_TGT ............ PENDING\nTIMEZONE_UPGRADE_PREPARE_TGT .... PENDING\nTIMEZONE_UPGRADE_TGT ............ PENDING\nZDM_POSTUSERACTIONS ............. PENDING\nZDM_POSTUSERACTIONS_TGT ......... PENDING\nZDM_CLEANUP_SRC ................. PENDING\nZDM_CLEANUP_TGT ................. PENDING\n\nPause After Phase: \"ZDM_CONFIGURE_DG_SRC\"\n<\/pre>\n<\/br>\n\n\n\n<p>And we can check Data Guard is in sync:<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,11,19,20]\">\noracle@vmonpr:\/ONPR\/u00\/admin\/etc\/ [ONPR] dgmgrl \/\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jul 29 16:21:32 2024\nVersion 19.22.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nWelcome to DGMGRL, type \"help\" for information.\nConnected to \"ONPR\"\nConnected as SYSDG.\n\nDGMGRL&gt; show configuration lag\n\nConfiguration - ZDM_onpr\n\n  Protection Mode: MaxPerformance\n  Members:\n  onpr           - Primary database\n    onprz_app_001t - Physical standby database\n                     Transport Lag:      0 seconds (computed 0 seconds ago)\n                     Apply Lag:          0 seconds (computed 0 seconds ago)\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS   (status updated 52 seconds ago)\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-manual-failover-to-exacc\">Manual Failover to ExaCC<\/h2>\n\n\n\n<p>Now for the migration step with pause after ZDM_SWITCHOVER_TGT phase (switchover), we will not use ZDM to do the switchover but run manually a failover. We will end in a split-brain situation having 2 primary databases, which we usually do not like, but it will not be a problem here, knowing the business application does not know anything about the ExaCC database, thus will not connect to it.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,4,6,14,19,35,39]\">\noracle@ExaCC-cl01n1:~\/ [ONPR1 (CDB$ROOT)] ps -ef | grep [p]mon | grep -i onprz\noracle    34780      1  0 16:18 ?        00:00:00 ora_pmon_ONPRZ_APP_001T1\n\noracle@ExaCC-cl01n1:~\/ [ONPR1 (CDB$ROOT)] export ORACLE_SID=ONPRZ_APP_001T1\n\noracle@ExaCC-cl01n1:~\/ [ONPRZ_APP_001T1 (CDB$ROOT)] dgh\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jul 29 16:22:59 2024\nVersion 19.22.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nWelcome to DGMGRL, type \"help\" for information.\n\nDGMGRL&gt; connect sys@'ExaCC-cl01-scan:1521\/ONPRZ_APP_001T.domain.com'\nPassword:\nConnected to \"ONPRZ_APP_001T\"\nConnected as SYSDBA.\n\nDGMGRL&gt; show configuration lag\n\nConfiguration - ZDM_onpr\n\n  Protection Mode: MaxPerformance\n  Members:\n  onpr           - Primary database\n    onprz_app_001t - Physical standby database\n                     Transport Lag:      0 seconds (computed 1 second ago)\n                     Apply Lag:          0 seconds (computed 1 second ago)\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS   (status updated 36 seconds ago)\n\nDGMGRL&gt; failover to onprz_app_001t;\nPerforming failover NOW, please wait...\nFailover succeeded, new primary is \"onprz_app_001t\"\n\nDGMGRL&gt; show configuration lag\n\nConfiguration - ZDM_onpr\n\n  Protection Mode: MaxPerformance\n  Members:\n  onprz_app_001t - Primary database\n    onpr           - Physical standby database (disabled)\n      ORA-16661: the standby database needs to be reinstated\n                     Transport Lag:      (unknown)\n                     Apply Lag:          (unknown)\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS   (status updated 1 second ago)\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-check-exacc-database-status\">Check ExaCC database status<\/h2>\n\n\n\n<p>If we check our ExaCC ZDM temporary database, we can see that it is opened READ\/WRITE with primary role.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,13,19]\">\noracle@ExaCC-cl01n1:~\/ [ONPRZ_APP_001T1 (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 29 16:24:55 2024\nVersion 19.22.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.22.0.0.0\n\nSQL&gt; select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nONPRZ_APP_001T1\n\nSQL&gt; select name, db_unique_name, open_mode, database_role from v$database;\n\nNAME      DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE\n--------- ------------------------------ -------------------- ----------------\nONPR      ONPRZ_APP_001T                 READ WRITE           PRIMARY\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-perform-last-steps-migration\">Perform last steps migration<\/h2>\n\n\n\n<p>Now we can resume the job with no other pause to perform all last migration steps. The only difference here is that we will have to use the option <code>-skip SWITCHOVER<\/code>, as we performed it manually.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1]\">\n[zdmuser@zdmhost ~]$ \/u01\/app\/oracle\/product\/zdm\/bin\/zdmcli resume job -jobid 280 -skip SWITCHOVER\nzdmhost.domain.com: Audit ID: 3496\n<\/pre>\n<\/br>\n\n\n\n<p>We can check the jobs to be successfull.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,9]\">\n[zdmuser@zdmhost ~]$ \/u01\/app\/oracle\/product\/zdm\/bin\/zdmcli query job -jobid 280\nzdmhost.domain.com: Audit ID: 3508\nJob ID: 280\nUser: zdmuser\nClient: zdmhost\nJob Type: \"MIGRATE\"\nScheduled job command: \"zdmcli migrate database -sourcesid ONPR -rsp \/home\/zdmuser\/migration\/zdm_ONPR_physical_online.rsp -sourcenode vmonpr -srcauth zdmauth -srcarg1 user:oracle -srcarg2 identity_file:\/home\/zdmuser\/.ssh\/id_rsa -srcarg3 sudo_location:\/usr\/bin\/sudo -targetnode ExaCC-cl01n1 -tgtauth zdmauth -tgtarg1 user:opc -tgtarg2 identity_file:\/home\/zdmuser\/.ssh\/id_rsa -tgtarg3 sudo_location:\/usr\/bin\/sudo -tdekeystorepasswd -tgttdekeystorepasswd -pauseafter ZDM_CONFIGURE_DG_SRC\"\nScheduled job execution start time: 2024-07-29T16:01:23+02. Equivalent local time: 2024-07-29 16:01:23\nCurrent status: SUCCEEDED\nResult file path: \"\/u01\/app\/oracle\/chkbase\/scheduled\/job-280-2024-07-29-16:01:46.log\"\nMetrics file path: \"\/u01\/app\/oracle\/chkbase\/scheduled\/job-280-2024-07-29-16:01:46.json\"\nJob execution start time: 2024-07-29 16:01:46\nJob execution end time: 2024-07-29 16:41:06\nJob execution elapsed time: 23 minutes 47 seconds\nZDM_GET_SRC_INFO ................ COMPLETED\nZDM_GET_TGT_INFO ................ COMPLETED\nZDM_PRECHECKS_SRC ............... COMPLETED\nZDM_PRECHECKS_TGT ............... COMPLETED\nZDM_SETUP_SRC ................... COMPLETED\nZDM_SETUP_TGT ................... COMPLETED\nZDM_PREUSERACTIONS .............. COMPLETED\nZDM_PREUSERACTIONS_TGT .......... COMPLETED\nZDM_VALIDATE_SRC ................ COMPLETED\nZDM_VALIDATE_TGT ................ COMPLETED\nZDM_DISCOVER_SRC ................ COMPLETED\nZDM_COPYFILES ................... COMPLETED\nZDM_PREPARE_TGT ................. COMPLETED\nZDM_SETUP_TDE_TGT ............... COMPLETED\nZDM_RESTORE_TGT ................. COMPLETED\nZDM_RECOVER_TGT ................. COMPLETED\nZDM_FINALIZE_TGT ................ COMPLETED\nZDM_CONFIGURE_DG_SRC ............ COMPLETED\nZDM_SWITCHOVER_SRC .............. COMPLETED\nZDM_SWITCHOVER_TGT .............. COMPLETED\nZDM_POST_DATABASE_OPEN_TGT ...... COMPLETED\nZDM_NONCDBTOPDB_PRECHECK ........ COMPLETED\nZDM_NONCDBTOPDB_CONVERSION ...... COMPLETED\nZDM_POST_MIGRATE_TGT ............ COMPLETED\nTIMEZONE_UPGRADE_PREPARE_TGT .... COMPLETED\nTIMEZONE_UPGRADE_TGT ............ COMPLETED\nZDM_POSTUSERACTIONS ............. COMPLETED\nZDM_POSTUSERACTIONS_TGT ......... COMPLETED\nZDM_CLEANUP_SRC ................. COMPLETED\nZDM_CLEANUP_TGT ................. COMPLETED\n<\/pre>\n<\/br>\n\n\n\n<p>And our On-Premises database has been converted and migrated into the PDB in the target database on the ExaCC.<\/p>\n\n\n\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,13,18,20,24,30]\">\noracle@ExaCC-cl01n1:~\/ [ONPR1 (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 29 16:45:17 2024\nVersion 19.22.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.22.0.0.0\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 ONPRZ_APP_001T                 READ WRITE NO\n\nSQL&gt; alter session set container=ONPRZ_APP_001T;\n\nSession altered.\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         3 ONPRZ_APP_001T                 READ WRITE NO\n\nSQL&gt; select status, message from pdb_plug_in_violations;\n\nSTATUS     MESSAGE\n---------- ------------------------------------------------------------------------------------------------------------------------\nRESOLVED   PDB needs to import keys from source.\nRESOLVED   Database option RAC mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nRESOLVED   PDB plugged in is a non-CDB, requires noncdb_to_pdb.sql be run.\nPENDING    Database option APS mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option CATJAVA mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option CONTEXT mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option DV mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option OLS mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option ORDIM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option SDO mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option XML mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Database option XOQ mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.\nPENDING    Tablespace SYSTEM is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.\nPENDING    Tablespace SYSAUX is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.\n\n15 rows selected.\n<\/pre>\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-remove-data-guard-on-source-database\">Remove Data Guard on source database<\/h2>\n\n\n\n<p>We will now just have to remove the Data Guard configuration on the source On-Premises Database.<\/p>\n\n\n\n<p>Connecting to it with the broker, we will just have to run : <code>DGMGRL&gt; remove configuration;<\/code><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-to-wrap-up\">To wrap up<\/h2>\n\n\n\n<p>With ZDM we even have the possibility to fully perform the migration as a Dry Run test without impacting the source database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have been sharing my experience migrating On-Premises database to ExaCC using ZDM Physical Online, see my previous blog : https:\/\/www.dbi-services.com\/blog\/zdm-physical-online-migration-a-success-story\/ In this blog I will share how you can make a Dry Run migration on your own without impacting the source On-Premises database, so without having any downtime during the migration steps. In this [&hellip;]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2598,2562,96,3411,1574,1575],"type_dbi":[],"class_list":["post-34352","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-exacc-3","tag-migration-2","tag-oracle","tag-physical-online","tag-zdm","tag-zero-downtime-migration"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Dry Run with ZDM Physical Online with no Downtime for the source - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dry Run with ZDM Physical Online with no Downtime for the source\" \/>\n<meta property=\"og:description\" content=\"I have been sharing my experience migrating On-Premises database to ExaCC using ZDM Physical Online, see my previous blog : https:\/\/www.dbi-services.com\/blog\/zdm-physical-online-migration-a-success-story\/ In this blog I will share how you can make a Dry Run migration on your own without impacting the source On-Premises database, so without having any downtime during the migration steps. In this [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-30T06:53:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-30T06:53:43+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Dry Run with ZDM Physical Online with no Downtime for the source\",\"datePublished\":\"2024-07-30T06:53:40+00:00\",\"dateModified\":\"2024-07-30T06:53:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/\"},\"wordCount\":458,\"commentCount\":0,\"keywords\":[\"exacc\",\"migration\",\"Oracle\",\"Physical Online\",\"zdm\",\"zero downtime migration\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/\",\"name\":\"Dry Run with ZDM Physical Online with no Downtime for the source - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2024-07-30T06:53:40+00:00\",\"dateModified\":\"2024-07-30T06:53:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dry Run with ZDM Physical Online with no Downtime for the source\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/marc-wagner\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dry Run with ZDM Physical Online with no Downtime for the source - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/","og_locale":"en_US","og_type":"article","og_title":"Dry Run with ZDM Physical Online with no Downtime for the source","og_description":"I have been sharing my experience migrating On-Premises database to ExaCC using ZDM Physical Online, see my previous blog : https:\/\/www.dbi-services.com\/blog\/zdm-physical-online-migration-a-success-story\/ In this blog I will share how you can make a Dry Run migration on your own without impacting the source On-Premises database, so without having any downtime during the migration steps. In this [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/","og_site_name":"dbi Blog","article_published_time":"2024-07-30T06:53:40+00:00","article_modified_time":"2024-07-30T06:53:43+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Dry Run with ZDM Physical Online with no Downtime for the source","datePublished":"2024-07-30T06:53:40+00:00","dateModified":"2024-07-30T06:53:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/"},"wordCount":458,"commentCount":0,"keywords":["exacc","migration","Oracle","Physical Online","zdm","zero downtime migration"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/","url":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/","name":"Dry Run with ZDM Physical Online with no Downtime for the source - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2024-07-30T06:53:40+00:00","dateModified":"2024-07-30T06:53:43+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dry-run-with-zdm-physical-online-with-no-downtime-for-the-source\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dry Run with ZDM Physical Online with no Downtime for the source"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=34352"}],"version-history":[{"count":11,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34352\/revisions"}],"predecessor-version":[{"id":34363,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34352\/revisions\/34363"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=34352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=34352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=34352"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=34352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}