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.…
Tag: Migration
How to mount an Oracle Object Storage Bucket as File System on Oracle Linux 7
Update October 2023: For Oracle Linux 8, have a look at OCIFS and install the OCIFS Utility documentation. Introduction Mounting an Object Storage bucket as a local file system simplifies file management and provides you with additional cost-efficient storage space that can be used as if it were on the local server. Once the bucket…
Loading Data from Azure Blob Storage to Oracle Database
Introduction In multicloud environments, while using resources from multiple cloud vendors, you usually deal with migrating data across the environments or keeping it in one cloud environment while accessing it from another. The Oracle Database DBMS_CLOUD PL/SQL package allows you to access data on OCI Object Storage, Azure Blob Storage, and Amazon S3 buckets or…
Loading Data from AWS S3 to Oracle Database
Introduction In multicloud environments, while using resources from multiple cloud vendors, you usually deal with migrating data across the environments or keeping it on one cloud environment while accessing it from another. The Oracle Database DBMS_CLOUD PL/SQL package allows you to access data on OCI Object Storage, Azure Blob Storage, and Amazon S3 buckets or…
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…