Run Evaluation Job

Before submitting the database migration job for the production database, perform a test migration to determine how the process may fare with configuration and settings.

Zero Downtime Migration provides options and tools (Cloud Premigration Advisor Tool, or CPAT) that performs analysis of the source database, looking for uses of database features and constructs that are problematic when migrating to one of Oracle's Autonomous Cloud offerings before running it against the production database.

1. Run the evaluation job as the zdmuser with the credentials for the source and target databases.
   The command resembles:

   [zdmuser@zdmhost ~]$ /home/zdmuser/zdmhome/bin/zdmcli migrate database -rsp /home/zdmuser/template/zdm_logical_offline_pdb19c.rsp -sourcenode host_name.appssubnet.exadatainfrastr.oraclevcn.com -sourcesid PDB_name -srcauth zdmauth -srcarg1 user:opc -srcarg2 identity_file:/home/zdmuser/.ssh/id_rsa -srcarg3 sudo_location:/usr/bin/sudo -eval

   A job ID is returned to check the job status.
2. Monitor the job status using the job ID.
   The command resembles:

   [zdmuser@zdmhost ~]$ $ZDM_HOME/bin/zdmcli query job -jobid 3

3. Review the log file under Result file path. The log file contains any warnings or showstoppers for the migration of schemas. Each check successfully executed by CPAT includes a result of PASS, INFORMATIONAL, WARNING, or BLOCKER.
4. Review the Cloud Premigration Advisor Tool generated report. The directory to the report resembles:

   /u01/app/oracle/product/db/oracle-server/zdm/cdb_name/out/premigration_advisor_report.txt