Introduction Oracle Data Guard provides zero or near zero data loss and a recovery time of just a few minutes. For unrecoverable failure, a restore from backup usually takes hours and restores your data to the last backup. If you have applications that tolerate the RTO and RPO provided by a restore from backup, having…
Introduction Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) is a small-footprint tool that lets you create and manage resources in Oracle Cloud using a command line interface. It enables you to automate tasks and makes things easier. The Quickstart documentation provides quick installation instructions. However, installations via RPM (Red Hat Package Manager) on Base…
Introduction Oracle Data Guard and Active Data Guard ensure high availability and disaster recovery during maintenance operations and in case of outages. Recovery Point Objective (RPO) of zero (zero data loss) can be achieved by setting up SYNC or FASTSYNC replication, even at any distance, using Far Sync without compromising performance. Recovery Time Objective (RTO)…
Introduction Plugging a PDB into a CDB with a different database block size is possible, as in Doc ID 2027614.1. You only need to configure the target’s CDB buffer cache to have buffers of the block size of the PDB to be plugged in, which is done by setting the db_nk_cache_size database parameter in the…
Introduction Since the Oracle Database Service for Azure (ODSA) has been recently announced, it has gained much traction. This comes as little surprise, as the new service offers an Oracle-managed and entirely automated way to enable multicloud solutions on Azure and OCI. But wait for a second! Microsoft and Oracle have already partnered for a…
Introduction I’m pretty sure you have already heard about the newly released Oracle Database Service for Azure (ODSA) service. If not, then you missed something. Either case, here you get a summary of the background, challenges, features, benefits, and much more about ODSA. Multicloud In previous blog posts, we talked more in detail about the…
Introduction Oracle Autonomous Database provides a fully automated, self-securing database service with a wide range of security features, including: Always-on Transparent Data Encryption (TDE) to secure your data at rest. Automated encrypted backups. SQL*Net encryption for client connections. Oracle-managed and customer-managed encryption keys. Access Control Lists to restrict access to trusted sources only. Database Vault…
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…
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…
Introduction Oracle constantly introduces new Exadata Platforms providing higher performance, lower latency, extended storage, and optimized software and networking. The 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 cost…
Database Heartbeat 