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.…
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…
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…
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…
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…
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…
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…
Introduction The Oracle Cloud Events Service enables you to execute actions automatically based on state changes of your cloud resources. For example, a state change could be when the creation of the database is completed. An action could be sending an email notification or executing a function to implement post-creation tasks like creating users. If…
Introduction We already talked about remote PDB cloning in Data Guard environments in previous blog posts. As the datafiles of the cloned PDB are not present on the standby database, there are several manual steps to be followed to create the PDB on the standby site in 19c: Oracle Database version 21c introduces a new…
Introduction Oracle Multitenant is integrated with Oracle Data Guard. Data Guard is configured at the CDB level and will replicate all transactions from the primary to the standby for all PDBs in a single stream, including creating and deleting PDBs. But! When we create a new PDB, which is a clone from PDB$SEED, or create…
Database Heartbeat 