This is mostly just to document if you hit similar issues and how to get past them. I had to perform some remote cloning in ExaCS (from one CDB to another CDB) within same VM cluster, but hit few issues which I had to resolve first before getting it to work. [DBT-05514] Failed to connect…
OCI Tips and Tricks – Managed MySQL Database in OCI (and trying out Heatwave)
Here I’m looking on how to provision MySQL DB on OCI, see how read replicas work and how to add Heatwave Cluster to your DB. After that, I’m running some test queries to try out Heatwave, interesting results!
OCI Tips and Tricks: Create 19c Oracle Database (and manage it)
This time I go over on how to create 19c Oracle Database on OCI (hint: It’s super easy!). But what I feel is more important, where to find relevant log files after you’ve provisioned the database and how to use dbcli to manage your database and debug issues. Hope you enjoy the video!
OCI Tips and Tricks: Three ways to login to your Compute VM
New video! This time I’m showing how to login to your OCI Compute VM in three different ways: Public Compute Bastion Service Cloud Shell Hope you like the video – leave a feedback in the comments of the video if you think I should have covered something else as well. I forgot to mention that…
I’m back! Something new.. and more blog posts!
I attended Oracle Cloud World last week, and was positively surprised how much fun I had there! I really appreciate the folks who came and said they like reading my blog, I’ve been telling folks I haven’t had much motivation to create new content lately, but that actually made my motivation to go higher! Due…
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…