All articles

Hot Clone of a Remote PDB in a Dataguard Environment 19c

Introduction In Oracle Database 19c, if you have a Dataguard Configuration of a multitenant database, and you want to clone a pluggable database from a remote server to your primary, then you have to mind that the dataguard mechanism is(…)

And what about cloning a PDB in a Data Guard environment on ExaCC?

I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https://www.dbi-services.com/blog/create-new-pdb-in-a-data-guard-environment-on-exacc/. And what about if I clone a PDB on the primary CDB? Let’s see. Clone PDB on(…)

Create new PDB in a Data Guard environment on ExaCC

In this blog, I would like to share how to create a new PDB in one CDB in a Data Guard environment on the ExaCC. Naming Convention Following is the naming convention: CDB Name is MYCDB ExaCC Primary(…)

Issue running Dynamic Scaling on hardened system

During my Dynamic Scaling tests, you might have seen my other blog on same subject, I faced one issue where Dynamic Scaling could not be started properly due to hardened configuration. In this blog I would like to share(…)

Configure Dynamic Scaling as Grid HA resource

I have recently blogged about how to install and configure Dynamic Scaling as an Oracle Linux Service daemon. See my blog, https://www.dbi-services.com/blog/how-to-automatically-manage-ocpu-on-exacc-using-dynamic-scaling/ In this blog I would like to show how to configure it as an Oracle(…)

How to automatically manage OCPU on ExaCC using Dynamic Scaling

To automatically scale down and up the OCPU on ExaCC cluster according to the CPU utilisation, we can use dynamic scaling. Dynamic scaling engine can be installed on each cluster nodes VM, from a remote machine as master or(…)

Why relocating the PDB after ZDM Physical Online migration with noncdb to cdb conversion is a must?

I have been blogging about ZDM Physical Online migration with noncdb to cdb conversion. As you could read in my previous article, the target database name on CDB level should be the same as the source database, knowing physical(…)

SQL Server Tips: How to know how long goes a shrink ?

Few days ago, I perform a shrink on a data file to spend a little bit space on a disk.The SQL Server is a test server and the customer does not want to expand the disk. I run(…)

Dry Run with ZDM Physical Online with no Downtime for the source

I have been sharing my experience migrating On-Premises database to ExaCC using ZDM Physical Online, see my previous blog : https://www.dbi-services.com/blog/zdm-physical-online-migration-a-success-story/ In this blog I will share how you can make a Dry Run migration on your(…)

SQL Server: how do monitor SQL Dumps?

Few weeks ago, we had a big issue by a customer and a lot SQL Dumps was created in the SQL Server log folder. After playing fireman at the customer’s premises, we decided to set up a monitoring(…)