Introduction This blog post describes the steps to migrate from Oracle RDS to Exadata Database Service using Oracle Zero Downtime Migration (ZDM) logical online method, which leverages Oracle Data Pump for data export and import and uses Amazon S3 Object Storage to store the Data Pump dump files. Additionally, it uses Oracle GoldenGate to keep…
Introduction This blog post describes the steps to migrate from Oracle RDS to Exadata Database Service using Oracle Zero Downtime Migration (ZDM) logical offline method, which leverages Oracle Data Pump for data export and import and uses Amazon S3 Object Storage to store the Data Pump dump files. The same steps apply if migrating to…
Introduction This blog post describes the steps to migrate from Oracle RDS to Autonomous Database using Oracle Zero Downtime Migration (ZDM) logical online method, which leverages Oracle Data Pump for data export and import and uses Amazon S3 Object Storage to store the Data Pump dump files. Additionally, it uses Oracle GoldenGate to keep the…
Introduction This blog post describes the steps to migrate from Oracle RDS to Autonomous Database using Oracle Zero Downtime Migration (ZDM) logical offline method, which leverages Oracle Data Pump for data export and import and uses Amazon S3 Object Storage to store the Data Pump dump files. The Environment Step 1: Download and Install Oracle…
Introduction For ZDM Logical Online migrations to Exadata Cloud@Customer you will be running Oracle GoldenGate on-premises instead of on the Marketplace image on Oracle Cloud. Oracle GoldenGate keeps your source and target databases in sync and enables you to achieve zero to negligible downtime for your Oracle database migrations across database versions and platforms. This…
Introduction OracleDB for Azure (or, Oracle Database Service for Azure) simplifies multicloud deployments by providing an Oracle-managed interconnect between your Azure and OCI accounts. Customers running their workloads on Azure can now keep the application on Azure and move the Database to Oracle Cloud to benefit from Cloud Automation, Exadata Service, Oracle RAC, and more.…
Introduction Oracle constantly introduces new Exadata Platforms providing higher performance, lower latency, extended storage, and optimized software and networking. The Exadata X9M generation is available on-premises, cloud@customer, and public cloud. AND, it comes at the same price as the previous generation!!! It is as simple as this: higher performance + same price = reduced cost…
Introduction Configuring GoldenGate for database migrations might be complex and require deep knowledge and expertise in GoldenGate. Zero Downtime Migration (ZDM) requires only a response file with the needed parameters. It configures and runs everything for you automatically to achieve (near) zero downtime while migrating your Oracle database to Oracle Cloud. This blog post provides…
Introduction Using Data Pump export and import is quite straightforward. Letting ZDM do it all for you (export, copy, import, and clean up) makes it possible to test your migration multiple times for no additional effort, and then when you are ready for the real migration, you are sure that exactly the same steps are…
Introduction SYSDATE is a SQL function that returns the current date and time set for the operating system of the database server. CURRENT_DATE returns the current date in the session time zone. The same story applies to SYSTIMESTAMP and CURRENT_TIMESTAMP. When database and application servers are set to the same time zone, both functions will return the…
Database Heartbeat 