6.1 Overview

Hybrid migration follows ZDM's proven methodology of pre-check, data transfer, synchronization, and post-check. While there are manually several phases that ZDM goes through for a hybrid Migration, the overall workflow is summarized as follows:

  1. ZDM connects to the source database and target database and performs the following validations:
    1. ZDM_VALIDATE_TGT phase: ZDM connects to the target database and performs validations.
    2. ZDM_VALIDATE_SRC phase: ZDM connects to the source database and performs validations.
    3. ZDM_SETUP_XTTS_SRC phase: ZDM configures required helper modules at the source level.
    4. ZDM_SETUP_XTTS_TGT phase: ZDM configures required helper modules at the target level.
  2. ZDM orchestrates the tablespace-level backups:
    1. Performs a full backup of the tablespaces.
    2. Performs an incremental backup of the tablespaces.
    3. Copies the wallet files as required.
  3. ZDM performs a full restore of tablespaces as foreign tablespaces.
  4. ZDM sets the source tablespaces as read-only and performs the following steps:
    1. Performs an incremental backup of the tablespaces and metadata export of the tablespaces using RMAN.
    2. Copies the wallet files as required.
  5. ZDM exports the metadata via Data Pump. The export includes:
    • Metadata
    • PL/SQL objects
    • Non-tablespaces data
  6. ZDM imports the metadata and performs an incremental restore as follows:
    1. Import of the user metadata from Data Pump.
    2. Incremental restore with RMAN + import of tablespace metadata generated by RMAN.
    3. Import of all the other metadata (objects and non-tablespace data).
  7. ZDM performs post actions, cleans up, and finalizes.