Recently I was testing OCI database upgrade from 12c to 19c and ran into an issue I wanted to fix. I was doing this via dbaascli (on Exadata) and the upgrade hit Bug 34455245 – db12c upgrade to 19c fails with ORA-600 [kxhfmgetextent.1] (Doc ID 34455245.8). I tried few things as with dbaascli you can…
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…
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!
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!
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…
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…
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…
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…
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…
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…