I85PREP
⌘ K
OCI Migration Architect Pro study materials
OCI Migration Architect Pro study resources

OCI Migration Architect Pro: Database Migration to OCI (Autonomous Database, Base Database, Exadata)

OCI Migration Architect Pro · Work through your exam, one topic at a time.

All guide sections

Database Migration to OCI (Autonomous Database, Base Database, Exadata)

What this domain tests

Choosing and executing the right Oracle Database migration method across targets: Base Database Service, Exadata Database Service, and Autonomous Database. Expect questions on Zero Downtime Migration (ZDM), Data Pump, GoldenGate, RMAN, transportable tablespaces, and character-set conversion.

Core rules and concepts

  • ZDM orchestrates four modes: physical (Data Guard), logical (Data Pump), logical online (GoldenGate), and physical offline. Target must be Base Database, Exadata Database Service, or - for logical modes - Autonomous Database.
  • Data Pump suits small databases and schema-level moves; use TRANSPORTABLE=ALWAYS with full transportable export/import to move datafiles and cut the window.
  • GoldenGate gives minimal downtime for large databases and heterogeneous versions by keeping source and target synchronized until switchover.
  • Autonomous Database has no OS access and no user-managed Data Guard; it offers Autonomous Data Guard and requires wallets. Migrate in with Data Pump, GoldenGate, or ZDM logical.
  • Run Database Migration Assistant for Unicode (DMU) when the source character set is not AL32UTF8.

Worked example

A 12 TB 19c on-prem RAC database must reach Exadata Database Service with a 30-minute outage allowance. Offline Data Pump is rejected: export plus transfer plus import far exceeds 30 minutes. Physical ZDM via Data Guard is viable, but the team wants the source to stay writable during rehearsal. Choose logical online with ZDM plus GoldenGate: replicate, run a full rehearsal, measure apply lag at cutover (about 2 minutes), switch over, then reconcile row counts and SCNs before releasing the application.

Traps that cost marks

  • Picking offline Data Pump for a multi-terabyte database on a modest link.
  • Forgetting directory objects, grants, scheduler jobs, and synonyms in logical migrations.
  • Importing a non-UTF8 database without DMU and discovering truncation later.
  • Expecting user-managed Data Guard on Autonomous Database.
  • Leaving the GoldenGate Extract running after switchover and duplicating changes.