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…
Tag: Patching
How to reduce Patching Time for Oracle Databases in the Cloud
Introduction Lately, I got a question from a customer about why patching in the cloud takes too long. First of all, we need to clarify things first and understand the exact situation: what Database Service is being used? What is the database version? Multitenant? How many PDBs are present in the CDB? How many CPUs…
Minimal Downtime Patching using Refreshable PDB Clones
Introduction Oracle Multitenant allows you to clone PDBs from one CDB to another easily, even though the source and target CDBs were of different patch levels, e.g. 19.9 and 19.10, and even different editions like moving from SE to EE. The only thing you’ll need is to run datapatch afterwards. Unplug and Plug the PDB…
Using OCI CLI and Custom Database Software Images to Create, Patch, and Upgrade your Exadata Cloud Databases
Introduction After covering how to use the OCI CLI and Custom Database Software Images to patch and upgrade databases on VM DB Systems in the previous blogs, we are now going to see how to do this on Exadata systems. Exadata systems allow to provision multiple database homes of different software versions and having multiple…
Using Custom Database Software Images to Create, Patch, and Upgrade your Cloud Databases
Introduction When it comes to create, patch, or upgrade your Oracle database in the cloud, Oracle provides Database Software Images that include a specific Release Update (RU), e.g. 18.11, 19.7 or 19.9. However, if you need some additional one-off (interim) patches on top of that RU, you would have to apply them manually afterwards. This…
Automate Patching and Upgrade your Cloud Databases using OCI CLI
Introduction Patching and Upgrade your Oracle Databases in the Oracle Cloud is as easy as pushing the button in the web-based Cloud Console. However, if you want to schedule the task, and especially if you are planning to patch and upgrade tens or maybe hundreds of databases, then the OCI CLI is the tool of…