[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間：2025-08-18 (世界標準時間)。"],[[["\u003cp\u003eDatabase Migration Service utilizes two migration types, continuous and one-time, with only continuous migrations available for Oracle to Cloud SQL for PostgreSQL.\u003c/p\u003e\n"],["\u003cp\u003eContinuous migrations are divided into two phases: the full dump phase, which transfers the initial data to the destination, and the Change Data Capture (CDC) phase, which replicates subsequent changes.\u003c/p\u003e\n"],["\u003cp\u003eDuring the full dump phase, Database Migration Service copies data directly from the source database to the destination, with the option to adjust concurrent connection numbers for optimal performance.\u003c/p\u003e\n"],["\u003cp\u003eAlternatively, users can manually perform the full dump and then start the migration job with the CDC phase, providing the System Change Number (SCN) as the starting point.\u003c/p\u003e\n"],["\u003cp\u003eThe CDC phase relies on monitoring log files to replicate changes, using the Oracle LogMiner API to read and parse archived Oracle redo log files for continuous data synchronization.\u003c/p\u003e\n"]]],[],null,["# About data flow for Oracle to Cloud SQL for PostgreSQL\n\nThere are two important concepts you need to understand to know how data flows\nfrom your source to the destination instance: migration types and migration\nphases. Database Migration Service supports two types of migration: continuous and one-time.\nOnly continuous migrations are available for heterogeneous Oracle to\nCloud SQL for PostgreSQL migrations.\n\nWith continuous migrations, your data is migrated in two phases: full dump, and\nChange Data Capture (CDC).\n\nFull dump phase\n---------------\n\nThe **full dump phase** is the first part of the migration process. During\nfull dump, Database Migration Service connects to your source instance, reads the content\nof the databases you selected for migration, and then loads the data to the Cloud SQL for PostgreSQL\ndestination instance. In this phase, Database Migration Service captures actual contents\nof your database.\n\nDuring the full dump phase, Database Migration Service can open multiple connections to\nyour source databases for improved performance. You can configure the number of\nconcurrent connections when you\n[create a migration job](/database-migration/docs/oracle-to-postgresql/create-migration-job).\n\nFor granular control over your data movement, you can also perform the full dump\nand load the data to the destination instance on your own, outside of\nDatabase Migration Service. If you choose to perform this phase manually, your migration\njob will start with the CDC phase instead and Database Migration Service\nwill expect that you provide the System Change Number (SCN) of your redo log\nfiles as the starting point.\n\nChange Data Capture (CDC)\n-------------------------\n\nWhen the **full dump** phase is over (or if you choose to perform the full\ndump yourself and start with the CDC phase), Database Migration Service switches to the\nCDC phase where it keeps monitoring your source databases for changes, and then\ncontinuously replicates them on the destination instance. In this phase,\nDatabase Migration Service doesn't copy actual data from your source databases: instead\nit reads log files to replicate changes in the destination.\n\nDatabase Migration Service uses the Oracle LogMiner API to access and parse archived Oracle\nredo log files in your source database. Before you migrate your Oracle databases\nto Cloud SQL for PostgreSQL with Database Migration Service, we recommend that you adjust your\nOracle redo log files settings for optimal performance and data fidelity. For\nmore information, see\n[Work with Oracle redo log files](/database-migration/docs/oracle-to-postgresql/work-with-oracle-database-redo-log-files)."]]
