Configure Response File

Oracle Zero Downtime Migration leverages a response file that is fully customizable.

Copy and Update the Response File

Copy the template and make changes based on the environment and credentials.

A response file template has been provided with each install. As a zdmuser, copy the template file to update the parameters.

1. Copy the response file template.

   [zdmuser@zdmhost ~]$ mkdir ~/template
   [zdmuser@zdmhost ~]$ cp zdmhome/rhp/zdm/template/zdm_logical_template.rsp ~/template/

2. Update the response file.
   The template contains parameters to handle all supported methodologies. Update the response file based on the selected migration methodology (Offline Logical Migration) for this solution.

   User, it’s roles and privileges along with the tablespace will be migrated by Zero Downtime Migration. You must update the response file relevant to the use case scenario where a set of parameters needs to define and update. One can simply skip the parameter DATAPUMPSETTINGS_METADATAREMAPS-1 in case you want to migrate all tablespaces, except SYSTEM, SYSAUX, UNDO and TEMP to Oracle Autonomous Database.

   MIGRATION_METHOD=OFFLINE_LOGICAL
   DATA_TRANSFER_MEDIUM=OSS
   TARGETDATABASE_ADMINUSERNAME=ADMIN
   SOURCEDATABASE_ADMINUSERNAME=SYSTEM
   SOURCEDATABASE_CONNECTIONDETAILS_HOST=service_name.appsubnet.exadatainfrastr.oraclevcn.com
   SOURCEDATABASE_CONNECTIONDETAILS_PORT=1521
   SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME=service_name
   TARGETDATABASE_OCID=ocid.autonomousdatabase.oc1.region.unique_key
   TARGETDATABASE_CONNECTIONDETAILS_HOST=hostname.exadatainfrastr.oraclevcn.com
   TARGETDATABASE_CONNECTIONDETAILS_PORT=port_number
   TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME=target_db_name_tp_tls
   DATAPUMPSETTINGS_JOBMODE=SCHEMA
   DATAPUMPSETTINGS_SCHEMABATCH-1=SYSADM
   DATAPUMPSETTINGS_DELETEDUMPSINOSS=FALSE
   DATAPUMPSETTINGS_DATAPUMPPARAMETERS_USERMETADATA=1
   DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME=data_bucket_namespace
   DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME=data_bucket_name
   DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME=DATA_PUMP_DIR
   DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH=/u01/app/oracle/product/db/oracle-server/19.3.0.0/rdbms/log
   OCIAUTHENTICATIONDETAILS_REGIONID=region_id-1
   OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID=ocid1.tenancy.oc1..id
   OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID=ocid1.user.oc1..id
   OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT=35:fingerprint
   OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE=/home/zdmuser/zdmhome/.oci/oci_api_key.pem

See Preparing the Logical Migration Response File and Oracle Data Pump Settings for Zero Downtime Migration in Explore More for more details.