Introduction If you are working with Oracle Data Guard, you have probably wondered what actually gets transmitted between your primary and standby databases. Is it the redo data, the redo log files, or the entire data blocks themselves? It is an important distinction, and understanding it can help you troubleshoot performance issues, optimize your network…
Introduction When building applications, it is essential to ensure business continuity by establishing high availability and disaster recovery mechanisms. This requires implementing a resilient disaster recovery framework capable of swiftly restoring operations in the event of an outage. For years, organizations have relied on Oracle Exadata Database Service, Oracle’s premier disaster recovery technologies, to support mission-critical…
Introduction Ensuring uninterrupted business continuity is critical to success when designing applications. Achieving this requires a robust disaster recovery strategy designed to quickly restore functionality in case of disruptions. For years, businesses have trusted Oracle Exadata Database Service with Oracle’s premier disaster recovery technologies to power critical applications, both on-premises and within Oracle Cloud Infrastructure (OCI).…
Before we begin, huge kudos to my colleague Sebastian Solbach for working on this blog post. Introduction Mission-critical applications rely on 24/7 availability to maintain business operations. The database is the most critical component in every software architecture; therefore, it is compelling to implement a strategy that maximizes data availability, reliability, and protection. Oracle Data…
The Oracle Maximum Availability Architecture (MAA) product management team invites you to attend its next MAA Summit for informative and interactive sessions on Oracle Database high availability and disaster recovery, Oracle Vector Search, and Exadata MAA. Learn about what’s new and provide your feedback directly to Oracle product management. When and Where Tuesday, May 14,…
Introduction Refreshable PDB Clones enable you to copy a PDB and keep the copy (the clone) up-to-date with the source PDB (refresh the clone). The clone can be on the same CDB (local) or on another CDB (remote). If the target database is a primary database in a Data Guard configuration, then the refreshable PDB…
Introduction After creating a PDB on the primary in a Data Guard environment, the PDB gets also created on standby. However, the standby will still be missing a TEMP file. To create a TEMP file, I got a comment from a customer that they were switching over to standby to create the TEMP file, which…
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
Introduction Enabling Oracle Data Guard in Oracle Cloud is a matter of a few clicks in the Cloud Console. However, many customers prefer to manage their resource provisioning in an automated way using Terraform, OCI CLI, SDKs, or REST API for more consistency and efficiency. Providing the correct values in the OCI CLI command to…
Introduction To use High Availability features like Fast Application Notification (FAN), Draining, and Application Continuity, you need to create a custom database service and set the high availability attributes accordingly. This is not possible when using the default database service, which is the service with the same name as the PDB. Additionally, custom database services…
Database Heartbeat 