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 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 DBCS Clone from backup fails when Database Vault is enabled
Recently I was creating a DBCS database clone but the creation failed, luckily we could find out the node IPs through support and from the dcs-agent-debug.log we could see following statement failing: When looking this script what it tries to do is set the default password limits for DEFAULT profile. While trying it out on…
Series – Get your database running with Terraform part 9: Database
At this point I have created everything else apart from the database. For the database we have few options starting if we would like to have Baremetal, Virtual Machine or Exadata. In this demo I’m going to create VM single-node database but I could create it as RAC database as well with two nodes. Similar…
Series – Get your database running with Terraform part 1: Setup
One of my old colleague whom I had pleasure to work with many years ago asked recently if there would be guide on getting a database running on Oracle Cloud Infrastructure with Terraform using Infrastructure as Code. That led me to an idea that I could write such guide and describe each step why it’s…