Linux LVM for Oracle Database on OCI

Oracle Database as a service (DBCS) on Oracle Cloud Infrastructure (OCI) had been traditionally built based on Oracle Grid Infrastructure with ASM as the main storage layer for the database, however Oracle recently has started to offer a Linux LVM as the storage alternative. Which option is the better alternative? Let’s review some of the… read more

Oracle OCI Database service storage allocation

Today I would like to discuss the block storage allocation in a VM based Oracle DBCS system. Several times in different conversations it was mentioned that the block storage will be allocated with triple redundancy on the ASM level. Let’s check it out. If we try to allocate the minimum size volume 256GB for an… read more

GoldenGate : setup Bi-Directional Replication in Multitenant environment (PDBs)

Intro GoldenGate replication solution allows you to capture, replicate, filter, transform, and deliver real time transactional data across Oracle or heterogeneous environments. Goldengate 12c features along with Oracle multitenant architecture introduced some changes to the way replication works (see Fig-1). Another interesting fact is that few of Oracle Streams features have now found their way… read more

Known issues with upgrading ODA to 18.3 and how to avoid them

Recently, when I worked on upgrading ODA X7-2 S/M/L from version 12.2.1.4.0 to version 18.3.0.0.0. I hit two known issues after patching server components. Issue# 1: Onboard public network interfaces do not come up after patching or imaging. Issue# 2: Upgrading to 18.3 can automatically result in ADVM processes consuming Excessive CPU and IO during… read more

On-Premise Oracle Database Backup Using Oracle OCI Backup Cloud Service

Oracle Backup Cloud Service provides a secondary, off-site backup location in the cloud with practically  unlimited capacity. The service also ensures that backups are encrypted and available when are needed. Off-site backup is traditionally accomplished by sending backups to tape and shipping them to a secure location. This is a complex task that requires hardware,… read more