Oracle Cloud Infrastructure Documentation

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 offline 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;
  • Additional configurations
    Before you can migrate data with Oracle Cloud Infrastructure Database Migration, perform additional configurations for your source database for online migration as described here.
  • 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.

Parent topic: Preparing Oracle Database migration users for migration