Online Oracle database storage migration with Oracle ASM

Background So, the time has come to migrate your Oracle database to another storage array. There are a number of different options available to us, including the Oracle online datafile move, Oracle Recover Manager (RMAN) backup/restore, Oracle DataGuard failover, Data Pump, GoldenGate, host base mirroring, storage replication to name just a few. The method selected... Continue Reading →

Oracle database recovery using Storage Snapshot Optimization

Oracle Storage Snapshot Optimization enables you to use third-party storage snapshots to recover a databases to the current time or a specific point-in-time without having the database placed in backup mode. To use Storage Snapshot Optimization, the snapshot technology must conform to the following requirements. The database is crash consistent during the snapshot.The snapshot preserves... Continue Reading →

How to query OCI Object Storage data from your on-premises Oracle 19c database

I have previous shared how we can access Avro file with Oracle BigData types from our on-premises Oracle database using either a NFS or local filesystem. I have also blogged on how to configure and access Object Storage from your on-premises Oracle 19c database using DBMS_CLOUD to query Avro, ORC, Parquet and other data files... Continue Reading →

Add storage to an OCI Oracle Kubernetes Engine (OKE) Cluster with Terraform

Introduction So you have created your OKE cluster using the Oracle Cloud Infrastructure (OCI) WebUI, Terraform or maybe by following my Provisioning an Oracle Kubernetes Engine (OKE) cluster with Rancher. And now you need to add some additional block storage to each compute instance. In this post I will show how we can use Terraform to... Continue Reading →

Getting started with Oracle 18c Express Edition (XE) on Kubernetes

In this post I will share how you can get started with containerising Oracle databases and how to use a Kubernetes Container Storage Interface (CSI) driver to provision dynamic persistent storage to the container. For this post I will use Oracle 18c Express Edition (XE) the 'Free Database for Everyone' and Portworx Essentials Forever Free... Continue Reading →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: