When you move your databases to cloud, many times the (current) standard backup configuration what Oracle offers is not enough. That’s when you configure OCI Cloud Database backup module which allows more flexibility with your RMAN configuration and also allows to write backups to custom Object Storage bucket. Question came up regarding this, can we…
Basics of Autonomous Migration with ZDM and integration with CPAT
This will be my third post on using Zero Downtime Migration (ZDM) for your migration, previously I’ve written about physical offline and online migration. Since Oracle talks a lot about Autonomous Database, let’s look this time what options you have on migrating to Autonomous. For Autonomous we have two options, logical offline and logical online…
Data Guard migration with ZDM
In the previous post I showed how to setup cloning or migration using offline physical option with Zero Downtime Migration (ZDM). This time let’s take a look what happens with ONLINE PHYSICAL option. Common migration requirement is to migrate with lowest amount of downtime and with all the latest data available and Data Guard is…
Oracle Database cloning in OCI – with ZDM!
I’ve been using Oracle’s Zero Downtime Migration (ZDM) tool lately, and given there are still some limitations on cloning your database in OCI, I was thinking could we use ZDM for this? Short answer – for sure! If you want to use native OCI capabilities for cloning your database, you are limited on restoring the…
Remote Cloning OCI DBCS PDB with OCI CLI
In previous post I showed how to perform remote clone with Resource Manager/Terraform/Ansible. What if you just want a quick remote clone to be done manually? Remember OCI Console doesn’t support Remote Cloning at the moment (February 2022) but you can do the remote clone through API’s as well. So let’s do it with OCI…
Remote Cloning OCI Database PDB with OCI Resource Manager, Terraform and Ansible
Code referenced in this post can be found from my Github page. There’s a new feature in OCI, which enables you to remote clone PDB from one database to another if certain conditions match. Right now, the databases need to be in same Availability Domain, need to be in same version and use the same…
Autonomous JSON Database with Database API for MongoDB
Oracle had announced Database API for MongoDB which can be used together with Autonomous JSON Database. This post will be with some learnings what I went through when I tested it out. Official announcement post goes through the setup rather well. When provisioning the database, remember to select Autonomous JSON database as DB type and…
OCI Private DNS Design for multiple Regions
I’ll start by saying that typically I still see private DNS setup in the customer domain rather than in OCI, but recently I had a case where customer wanted OCI to manage specific internal sub-domain which we then used in the OCI Load Balancers. For that, there was conditional forwarders setup on-premises with a rule…
Passing the OCI Certified Architect Professional 2021 – 1Z0-997-21
It’s that time of the year – new OCI Certified Architect Professional exam came out with new questions so I decided to take the test and see what’s changed from last year. Summary – not much. Honestly, the quality of questions has improved so you are not left wondering so many times what were they…
Exadata Cloud Service scaling (adding nodes) hangs
This will be a short post, mainly just to guide where to look if you ever encounter this issue. Recently I was tasked on adding a database node on Exadata Cloud Service X8M. The new X8M has dynamic deployment options so if you need more storage or compute power for your database nodes, you can…