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.…
Category: Database Migration
How to move your Exadata Cloud Service Databases to X9M with Zero Downtime
Introduction Oracle constantly introduces new Exadata Platforms providing higher performance, lower latency, extended storage, and optimized software and networking. The latest 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…
Zero Downtime Migration (ZDM) – Logical Online Migration to VM DB Systems
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…
Zero Downtime Migration (ZDM) – Logical Offline Migration to Co-Managed Database Services
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…
SYSDATE vs. CURRENT_DATE in Oracle Database
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…
Import your Data directly from Object Storage in Oracle Database 21.3 and 19.12
Introduction To directly export and import data to and from Object Storage, you need the DBMS_CLOUD PL/SQL package, which was initially introduced in Oracle Autonomous Database. DBMS_CLOUD was made available for non-Autonomous Oracle Databases with version 21c and later backported to 19.9. However, direct import and export from and to Object Storage using the Data…
Use an Existing RMAN Backup with Zero Downtime Migration
Introduction From the very first version, Oracle Zero Downtime Migration (ZDM) supports physical online, and offline migrations using RMAN and Data Guard. However, every migration job was creating a new RMAN backup from the source database to be used to create the target database. Starting with ZDM version 21.2, you can skip the full backup…
AWS RDS for Oracle to Autonomous Database using Zero Downtime Migration
Introduction Zero Downtime Migration (ZDM) provides great automation capabilities to migrate your Oracle Database to Oracle Cloud. After supporting Linux-based platforms, the new version 21.2 also supports cross-platform and even cross-cloud migrations. With this enhancement, now it’s possible to migrate an AWS RDS for Oracle to Oracle Autonomous Database using the offline logical migration method…
Part 5/5: Zero Downtime Migration (ZDM) – Physical Offline Migration using RMAN
Introduction ZDM uses RMAN to perform an offline physical migration. It backs up the source database and instantiates a new database from this backup to the target environment. This is similar to cloning a database. The target database has no relationship to the source, so there is no data synchronization or fallback capability. No SQL*Net…
Part 4/5: Zero Downtime Migration (ZDM) – Physical Online Migration using Data Guard
Introduction ZDM uses Oracle Data Guard to perform an online physical migration. This means: it backs up the source database, instantiates a standby database from this backup to the target environment, configures Data Guard to synchronize the source and target databases, and finally switches over to the target database. ZDM allows you to pause the…