Oracle Migration and Integration

·       Describe Oracle Data Management and Integration

·       Describe Oracle Data Management Services

·       Explain Migration Use Cases and Solutions

·       Describe Oracle Data Integration

 

Migrating to Cloud Database Services using RMAN, Data Pump and Cloning

·       Describe when to use Data Pump to migrate to Oracle Database to Oracle Cloud Infrastructrure (OCI)

·       Describe when to use Unplug/Plug, Remote Cloning and Relocation of PDBs to migrate to OCI

·       Use Recovery Manager (RMAN) to migrate to OCI

·       Migragting to Cloud Database Services using SQL Devoper, Cloud Backup,  and GoldenGate

·       Analyze and choose a Migration Strategy (Source Database and Environments, Linux/non-linux, CDB, non-CDB)

·       Migrate using SQL Developer

·       Migrate an Oracle Database to OCI by using Oracle Database Cloud Backup Service

·       Migrate Oracle Databases on 3rd party clouds (moving from 3rd party clouds)

·       Migrate an Oracle Database to OCI using GoldenGate

 

Source and Target Database Options

·       Explain Sounce database and Target Options in OCI

·       Analyze migration evaluation considerations (Downtime, Network, Data Constraints: Database Size, Character Set, Encryption) and Database constraints (Version, Edition, Options, Release Updates Level, Block Size, Time Zone, Target DB Configuration)

·       Migrating to Cloud Database Services using Oracle Zero Downtime Migration (ZDM)

·       Describe Zero Downtime Migration (ZDM)

·       Prepare to use ZDM Service Node, Source Database, Target Database, Backup, Network Considerations, and Encryption Consideration

·       Manage the Database Migration Workflow (ZDM Commands and Options, Migration with Oracle ZDM, Troubleshooting, Common Issues)

 

Data Integration

·       Explain ETL vs ELT architecture of data integration

·       Analyze architecture components for transferring data from On-premises Database to Oracle Cloud DB

·       Implement change data capture (CDC) and leverage GoldenGate for real-time feed

·       Implement extraction method for Fusion SaaS applications for loading into Autonomous Database Warehouse (ADW)

·       Implement data integration mapping for data quality checks as part of data flow

·       Implement data integration mapping where data is joined from hybrid data source (ex: Database and files) before loading into the target

 

Migrating to Autonomous Database

·       Describe when to use Data Pump to migrate to Autonomous Database (ADB)

·       Use ZDM to migrate on-premises databases to ADB