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 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: Using Transient no-standby PDB. Using STANDBYS=NONE followed…
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…
Introduction In the previous blog post, we talked about the many benefits of multicloud. However, implementing a multicloud strategy is not easy for many organizations. Moving workloads to the cloud require thorough planning, effort, and considerations already. So what comes on top of that when using services from even multiple cloud service providers? This article…
Introduction Today, enterprises from every sector and industry are increasingly deploying and implementing cloud solutions to benefit from agility, simplicity, automation, consistent high performance, and low and predictable pricing, among many more other benefits. So what is driving companies to adopt a multicloud strategy? Is one cloud not sufficient? Or maybe challenging enough? Indeed, according…
Do you want to develop an application and need a database? Create an Oracle Autonomous Database, download the Client Credentials, connect to the database, and create your first table, all in 50 seconds. Without pre-installing any tools. Open the Cloud Shell in your Cloud Console and execute the following few lines after adjusting the values…
Introduction Oracle Cloud provides you the option to enable automatic backups with the click of a button. In case you have different backup requirements, you still have the flexibility to create your manual backup configurations and create your backups via command-line tools or directly using RMAN. This applies to VM DB Systems, Exadata Cloud Service,…
Database Heartbeat 