Preparing the source database for migration

Before you can migrate data with Oracle Cloud Infrastructure Database Migration, manually configure your source database as described here.

• To configure a single-tenant (Non CDB) as a source for offline migration or to configure a specific pluggable database (PDB) within a multi-tenant (CDB) as the source for the migration, run the following SQL commands:

  -- Archive Log Mode
  SHUTDOWN IMMEDIATE;
  STARTUP MOUNT;
  ALTER DATABASE ARCHIVELOG;
  ALTER DATABASE OPEN;
  
  -- Global Names
  ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
  
  -- Stream Pool Size
  ALTER SYSTEM SET STREAMS_POOL_SIZE=256M;
  
  -- Force Logging
  ALTER DATABASE FORCE LOGGING;
  
  -- Supplemental Logging
  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

• To configure a single-tenant (Non CDB) as a source for online migration or to configure a specific pluggable database (PDB) within a multi-tenant (CDB) as the source for online migration, run the following SQL commands:

  -- Archive Log Mode
  SHUTDOWN IMMEDIATE;
  STARTUP MOUNT;
  ALTER DATABASE ARCHIVELOG;
  ALTER DATABASE OPEN;
  
  -- Global Names
  ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
  
  -- Stream Pool Size
  ALTER SYSTEM SET STREAMS_POOL_SIZE=2G;
  
  -- Force Logging
  ALTER DATABASE FORCE LOGGING;
  
  -- Enable GoldenGate
  ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE;
  
  -- Supplemental Logging
  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

• To configure a multi-tenant (CDB) as a source for migration, run the following SQL commands:

  -- Connect to CDB and run:
  
  -- Archive Log Mode
  SHUTDOWN IMMEDIATE;
  STARTUP MOUNT;
  ALTER DATABASE ARCHIVELOG;
  ALTER DATABASE OPEN;
  
  -- Global Names
  ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
  
  -- Stream Pool Size
  ALTER SYSTEM SET STREAMS_POOL_SIZE=256M SCOPE=BOTH;
  
  -- Force Logging
  ALTER DATABASE FORCE LOGGING;
  
  -- Supplemental Logging
  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

• To configure a multi-tenant (CDB) as a source for online migration, run the following SQL commands:

  -- Connect to CDB and run:
  
  -- Archive Log Mode
  SHUTDOWN IMMEDIATE;
  STARTUP MOUNT;
  ALTER DATABASE ARCHIVELOG;
  ALTER DATABASE OPEN;
  
  -- Global Names
  ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
  
  -- Stream Pool Size
  ALTER SYSTEM SET STREAMS_POOL_SIZE=2G SCOPE=BOTH;
  
  -- Force Logging
  ALTER DATABASE FORCE LOGGING;
  
  -- Enable GoldenGate
  ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE SCOPE=BOTH;
  
  -- Supplemental Logging
  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

• To configure Amazon RDS (non-CDB) as a source for migration, run the following SQL commands:

  -- Set the following parameters through the Parameter groups
  functionality:
  
  -- STREAMS_POOL_SIZE=2147483648
  
  -- GLOBAL_NAMES=FALSE
  
  -- To see how Parameter groups work refer to
  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/parameter-groupsoverview.
  html
  
  -- Archive Log Mode
  EXEC RDSADMIN.RDSADMIN_UTIL.SET_CONFIGURATION('ARCHIVELOG RETENTION
  HOURS',72);
  
  -- Force Logging
  EXEC RDSADMIN.RDSADMIN_UTIL.FORCE_LOGGING(P_ENABLE => TRUE);
  
  -- Supplemental Logging
  EXEC RDSADMIN.RDSADMIN_UTIL.ALTER_SUPPLEMENTAL_LOGGING('ADD');

• To configure Amazon RDS (non-CDB) as a source for online migration, run the following SQL commands:

  -- Set the following parameters through the Parameter groups
  functionality:
  
  -- STREAMS_POOL_SIZE=2147483648
  
  -- GLOBAL_NAMES=FALSE
  
  -- ENABLE_GOLDENGATE_REPLICATION=TRUE
  
  -- To see how Parameter groups work refer to
  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/parameter-groupsoverview.
  html
  
  -- Archive Log Mode
  EXEC RDSADMIN.RDSADMIN_UTIL.SET_CONFIGURATION('ARCHIVELOG RETENTION
  HOURS',72);
  
  -- Force Logging
  EXEC RDSADMIN.RDSADMIN_UTIL.FORCE_LOGGING(P_ENABLE => TRUE);
  
  -- Supplemental Logging
  EXEC RDSADMIN.RDSADMIN_UTIL.ALTER_SUPPLEMENTAL_LOGGING('ADD');

• To configure Autonomous AI Database as a source:

  -- When performing an online migration, you must set the following
  advanced parameter in the migration configuration:
  
  -- GOLDENGATESETTINGS_SKIPRELOADQUERYADVISOR: Set the value to "true".
  
  -- Supplemental Logging: Validate using SELECT MINIMAL FROM
  DBA_SUPPLEMENTAL_LOGGING;
  ALTER PLUGGABLE DATABASE ADD SUPPLEMENTAL LOG DATA;

• Use case
  Following is a sample use case to prepare your source database for migration. To configure a PDB as a source for your migration, the steps are similar to setting up a classic database as a source, but there are requirements for using the CDBROOT as ggaliassrc.