Various thoughts on Oracle, Enterprise Architecture, Cloud Computing, Kubernetes and everything Storage
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 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 →
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 →
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 →
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 →
As database professionals we are the custodians of our organisations data and in the event of any data related issue are usually one of the first on the scene. Over the last few years we have seen an increasing number of ransomware attacks, this has been headline news across the globe impacting all industries, with... Continue Reading →
Introduction If you thinking about, or already running an Oracle database within a container, you may have thought 'how I am I going to backup and secure my database and environment ?' In this post I will share how we can use Portworx PX-Backup to easily backup an Oracle database to a Pure Storage FlashBlade... Continue Reading →
I have previously shared how we can deliver a containerised Oracle 19c database using a Kubernetes Statefulset with Block devices, in this post I will show how we do the same with Kubernetes Deployments and NFS. For this post I will be using Kubernetes v1.17 [root@master-1 ~]# kubectl version --short | awk -Fv '/Server Version:... Continue Reading →
Background This week I was asked an interesting question can Oracle dNFS and Oracle Recovery Manager (RMAN) use auto mounts, not knowing the answer I thought I better find out. What is Autofs ? Autofs, also known as automounter mounts filesystems on-demand when they are accessed rather than maintaining the mounts all the time. The... Continue Reading →
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database using Oracle external files on a local file system or and NFS share from an NFS server e.g. FlashBlade Unfortunately, at that time I... Continue Reading →
