Introduction Oracle Autonomous Database is based on Oracle RAC and Exadata and hence, highly available by design. But how about your application? What happens to sessions getting interrupted by a maintenance event (e.g., patching), a local failure (e.g., instance crash), or (accidentally) terminated by a KILL SESSION command? Let’s give it a try! You can…
How to connect to a VM DB System via Oracle Database Service for Azure (ODSA)
Introduction After creating a VM DB System via Oracle Database Service for Azure (ODSA) in the previous blog post, we are going to see how to connect to the database host via SSH and to the CDB and PDB via SQL*Net from an Azure virtual machine, where usually your application will be running. The Environment…
How to create a VM DB System via Oracle Database Service for Azure (ODSA)
Introduction Oracle Database Service for Azure (ODSA) automates and simplifies the Interconnect between Azure and Oracle Cloud. Additionally, it provides a Multicloud portal to create Oracle Databases with the same Azure portal experience. As of today, you can use ODSA for the following Oracle Database Cloud Services: This blog post provides a step-by-step guide to…
A Step-by-Step Guide to Create and Enable Oracle Data Guard Far Sync
Introduction After introducing Far Sync instances and discussing their benefits in previous blog posts, this blog post provides a step-by-step guide to building a Far Sync instance and adding it to an existing Data Guard configuration. Parameters and directory paths used here are examples to make the setup easy to understand. Choose appropriate parameters and…
Ensure Zero Data Loss at any Distance by using Oracle Data Guard Far Sync
Introduction Oracle Data Guard enables you to transport the redo to the standby database synchronously to ensure zero data loss. However, when the standby database is geographically too far, the latency becomes higher, impacting the commit response time and the transaction throughput at the primary database. Oracle Active Data Guard Far Sync can ensure zero…
Learn Something New in Oracle Cloud Every Day
Starting with four commercial regions, Oracle Cloud has grown to 36 commercial regions in the last few years. And more to come. Additional services and features are being continuously released. In 2022, there were 462 new release notes. This is more than one release note per day. Oracle Databases in OCI got 42 release notes.…
Your Options for Multicloud Network Connectivity
Introduction In previous blog posts, we talked about the benefits and considerations of multicloud. As cross-cloud network connectivity is a crucial part of multicloud deployments, this blog post discusses the options to connect Oracle Cloud to other Public Clouds. It highlights their latency, bandwidth, availability, reliability, costs, and more characteristics. Site-to-Site IPsec VPN Site-to-site Virtual…
FastSync or Far Sync? FastSync AND Far Sync!
Introduction FastSync and Far Sync seem to be very similar terms, especially in the spoken language. In my conversations, I have seen these terms being mixed up and even questions about using one OR the other. Indeed, FastSync and Far Sync are two different things that can be used independently or make perfect sense to…
How Oracle Active Data Guard provides better Disaster Recovery than AWS RDS Read Replicas
Introduction Recently I have been asked whether AWS RDS for Oracle provides a solid disaster recovery solution using Read Replicas based on Oracle Active Data Guard. Oracle (Active) Data Guard is undoubtedly Oracle’s most comprehensive data protection and disaster recovery solution for Oracle Database. However, whenever I read or hear “RDS”, the next word that…
Ensure Disaster Recovery by replicating Automatic Backups across Regions in Oracle Cloud
Introduction Before we start, I want to mention that Oracle (Active) Data Guard provides the best disaster recovery solution for Oracle Databases with zero data loss and minimal recovery time. Restoring from backup usually comes with a much higher RPO and RTO than what Data Guard provides. However, if restoring from backup satisfies your application’s…