DEV Community

Series Week 12/52 - TAB fo OCI - Real life automation solutions

{ Abhilash Kumar Bhattaram : Follow on LinkedIn }

Lets take a look at our core Nabhaas offerring TAB ( Total Automation Box ) and some real life use cases

TAB for OCI Patching

I have blogged several articles about TAB ( whitepaper here ), here are some use cases that makes it one of the best tools for OCI automation

1. OCI Patching

Lets first understand the different types of OCI Patching for DB Systems and ExaCS class of OCI databases

1. Dom-0 Patching - ExaCS Infra patching 
2. Dom-U Patching - ExaCS VM patching 
3. GI - Patching - Grid Infra Patching  
4. DB - Patching - DB Realease Patching [Quarterly Patching]
5. DB - Upgrade - Database Upgrades

Enter fullscreen mode Exit fullscreen mode

In all the above cases Dom-0 patching is OCI automated meaning scheduling is done at OCI console level and patching kicks off on its owm , there is really not much we can do here to monitor other than raising proactoive SR's and wait fo rpatch completions.

For the remaning 4 are Customer driven , meaning a customer has to decide when and how to do this and handle the risks assosciated with it.

Imagine a scenario like this in your non prods

devdb Current RU 19.21    Required RU 19.22
sitdb Current RU 19.21    Required RU 19.25
uatdb Current RU 19.21    Required RU 19.27
Enter fullscreen mode Exit fullscreen mode

You have 3 different databases from 3 different compartments needed to be patched in 3 different versions due to application dependencies and all need to be done at the same time and you have only one weekend to do so.

TAB ( Total Automation Box ) solves exactly this problem by preparing simple run books to patching.

2. OCI Backup / Restores

Typical DBA activities are usually driven by manually prepared scripts with restores in On Prem databases , in OCI one can take a cloud backup and restore it as needed.

TAB helps prepare run books for backup restores so that weekend backups and restores are pre automated.

3. Database Deployments

Database deployments are semi automated taks whether they are on prod or on OCI as each application have thier dependencies , however TAB would help provide database deployments across databases if customized to each environment.

TAB gives you dozens of smart, automated ways to take care of your database needs—fast, accurate, and consistent.

How Nabhaas helps you

At Nabhaas, we work closely with teams to uncover dependencies, knowledge gaps, and process inefficiencies to ensure the patching cycle is smooth and predictable.

TAB ( Total Automation Box ) is how we automate patching lifecycles. https://www.nabhaas.com/tab

  • There is no staright answer to the points mentioned above but all of them needs to be addressed as best fits the organization.

  • At Nabhaas we ensure we identify all the above before beginning a patch cycle. Feel free to download our whitepaper here

Top comments (0)