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…
OCI list instances requiring maintenance from Cloud Shell
We had question to come up how to list OCI Compute instances which are requiring maintenance quickly and I found an excellent script from Radu Dobrinescu written in Python. But if I would like to run it quickly in cloud shell without any API keys or another instance which is using instance principles how would…
Rewriting Terraform security list configuration in OCI with Terraform 0.12
I’ve been a big fan of Terraform for quite some time but one of the things I have been complaining about has been some things which have not been possible when you use Terraform modules. Why do we use modules? It gives us a way to reuse our code so that each resource creation is…
Taking a ride with OCI autoscaling and instance pools
Some time ago Oracle Cloud Infrastructure introduced features around autoscaling and instance pools. This in short means you have an instance pool which uses image from the instance configuration you have defined. Instance pool has minimum number of instances you want to keep running and with autoscaling you can add scaling out or in depending…
Series – Get your database running with Terraform part 10: Summary
My idea on writing this guide was to provide overview what components you need when you create a database in Oracle Cloud Infrastructure. Even thought there are several components once you do it few times you get an understanding what you need and it comes a breeze to create these. Most issues I have seen…
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 7: Subnets
Now we have everything else setup on the network side apart from subnets. Subnets are continuous IP address blocks which don’t overlap with any other subnet IP address block in your VCN. Things to remember: As time of writing this Oracle has released new functionality regarding subnets, regional subnets. Earlier each subnet was tied in…
Series – Get your database running with Terraform part 6: Security Lists
Before we can create the subnets we still need to create security lists. They will control what ingress and egress traffic will be allowed within subnets. I will create two security lists for this project, one for private subnet and another one for public subnet. Security lists can have have multiple rules in them and…