10+ Reasons why AWS RDS is not an option for Oracle Database High Availability
Introduction AWS Relational Database Service (RDS) provides a managed service for several database engines, including Oracle. It offers automation for administration tasks like provisioning, patching, and backup. Hence, it is often compared to Oracle Autonomous Database on Shared Exadata Infrastructure. However, the differences are tremendous, especially (and not only) regarding database high availability. This is…
Creating PDBs in Data Guard Environments while using OCI Vault for TDE Key Management
Introduction Oracle Databases on Oracle Cloud use the Multitenant Architecture and are encrypted with TDE by default. Creating new PDBs in Data Guard environments while using a local wallet for TDE master encryption keys requires some additional steps to copy the wallet file and recover the PDB on standby. We discussed these approaches in previous…
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…
What’s new in OCI and Oracle Database Cloud Services
Introduction Oracle Cloud Infrastructure (OCI) is evolving every day! New features are being released, existing ones are being extended, and new data centers are being launched. More automation, more flexibility, and more capabilities to provide a better user experience, higher availability, and increased security to Oracle’s customers and partners. One frequently asked question is where…
How to use Customer-Managed TDE Encryption Keys on VM DB Systems in Oracle Cloud
Introduction Oracle Databases in Oracle Cloud use Transparent Data Encryption (TDE) by default to protect data at rest. The default configuration “Oracle-Managed Keys” stores the master encryption keys in a wallet file locally on the database servers. Now, Oracle also supports the integration with the OCI Vault Service for VM DB Systems, where you are able…
How to measure Network Latency for Oracle Data Guard Replication
Introduction Oracle Data Guard replicates data from the primary to one or multiple standby databases for high availability and disaster recovery. The decision to transfer the redo synchronously or asynchronously depends on your RTO and RPO. Synchronous redo transport provides zero data loss and lower recovery time, but your application needs to wait until the…
Oracle Autonomous Database always runs on Oracle RAC, ALWAYS
Introduction Since day one, I have been involved in discussions about whether Oracle Autonomous Database runs on Oracle RAC and whether the CPUs are distributed on multiple RAC nodes only for 17 OCPUs or more. Does that actually matter? No! But many, including me, always want to know more about what’s happening behind the scene.…
How to patch Data Guard Environments on Oracle Cloud with Minimal Downtime
Introduction Oracle Data Guard provides synchronous data replication to standby databases to ensure zero data loss in case of a disaster. In addition, the standby database can be used to offload RMAN backups, serve read-only and read-mostly workloads, and ensure high availability for planned maintenance. This blog post provides the steps needed to patch Data…
How to create a Single Service Name in Data Guard Environments on Oracle Cloud
Introduction Oracle Data Guard provides high availability and disaster recovery by replicating data from the primary to standby databases. In case of an outage on the primary site or for maintenance operation, a standby database becomes a primary and continues serving application requests. This role switch should be transparent for applications, not requiring any changes…
How to forward a Program Display from a Remote Linux Server using X11
Introduction Software is usually installed via command-line tools. It can be automated, scheduled, and repeated with minimal effort. However, for quick testing and demo purposing, or when you are new to some products, you might prefer discovering the new options using a graphical interface. For example, when installing Oracle Grid Infrastructure, Oracle Database, or Oracle…
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Database Heartbeat 