Oracle Migration and Integration |
This topic focuses on describing Oracle Data Management and Integration, Oracle Data Management Services, and Oracle Data Integration. It also explains Migration Use Cases and Solutions. |
Migrating to Cloud Database Services using RMAN, Data Pump, and Cloning |
It covers using Recovery Manager (RMAN) to migrate to OCI. Describes when to use Data Pump to migrate to Oracle Database to Oracle Cloud Infrastructure (OCI). This topic also describes when to use Unplug/Plug, Remote Cloning, and Relocation of PDBs to migrate to OCI. |
Migrating to Cloud Database Services using SQL Developer, Cloud Backup, and GoldenGate |
It covers analyzing and selecting migration strategies based on source database and environments, performing migrations with SQL Developer, leveraging Oracle Database Cloud Backup for migrations, moving databases from third party clouds, and utilizing GoldenGate to facilitate Oracle database migrations to the Oracle Cloud Infrastructure (OCI). |
Source and Target Database Options |
The topic explains the source databases and target options available in the Oracle Cloud Infrastructure. Moreover, it explains analyzing key migration evaluation considerations such as potential downtime, network constraints, data constraints like database size and encryption, and database configuration factors including version, edition, options, release update level, block size, time zone settings, and target database specifications. |
Migrating to Cloud Database Services using Oracle Zero Downtime Migration (ZDM) |
It covers Oracle's Zero Downtime Migration solution. It also discusses preparing to use ZDM including service nodes, source and target databases, backups, network and encryption factors. Additionally, it focuses on managing database migration workflows with ZDM through commands, options, executing migrations, and troubleshooting common issues that arise. |
Data Integration |
The Data Integration topic covers explaining ETL versus ELT data integration architectures. It discusses analyzing components for transferring data from on-premises databases to Oracle cloud databases. Additionally, it focuses on implementing change data capture with GoldenGate for real-time data movement, extracting data from SaaS applications into Oracle warehouses, performing data quality checks during mappings, and handling data joining from hybrid sources like databases and files prior to loading target systems. |
Migrating to Autonomous Database |
This 1Z0-1094-23 exam topic discusses when to leverage Oracle Data Pump for migrations as well as using ZDM solution for transitioning on-premises databases onto Autonomous Databases. |
Official Information |
https://education.oracle.com/oracle-cloud-database-migration-and-integration-2023-professional/pexam_1Z0-1094-23 |