Various thoughts on Oracle, Enterprise Architecture, Cloud Computing, Kubernetes and everything Storage
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 →
In this Blog I can going to show how you can run an Oracle 19c Database on a Kubernetes cluster using a Network File System (NFS) server for Persistent Storage. In this example I will be using the Pure Storage Container Storage Interface (CSI) Driver Pure Service Orchestrator (PSO) to present a persistent storage to... Continue Reading →
I have recently created a number of blogs posts on running containerised Oracle databases on Kubernetes using the Pure Storage Container Storage Interface (CSI) Driver Pure Service Orchestrator (PSO) to provide persistent block storage to my Oracle database containers using the Pure Service Orchestrator. In this Blog I am going to show how it's equally... Continue Reading →
Before we can use DataPump with Oracle dNFS we need to create and export an NFS filesystem, prepare our Linux environment and configure our database. Ok let's begin. Create File System For this walkthrough I need an NFS server, fortunately I have access to a Pure Storage FlashBlade in my lab, so I will be... Continue Reading →
In this Blog I am going to show how the Oracle database 'switch database to copy' can be used to avoid lengthy restore times and therefore minimise downtime in the event of a database disaster. RMAN backup status $ rman target=/ Recovery Manager: Release 19.0.0.0.0 - Production on Wed Apr 8 10:27:26 2020 Version 19.3.0.0.0... Continue Reading →
If you are using Oracle dNFS (Direct NFS) to deliver or backup your database with Oracle RMAN (Recovery Manager) you may want to consider using Oracle MONDNFS rather than writing you own SQL monitoring scripts. dNFS Views Oracle provide a number of database views to help with the initial configuration and monitoring of dNFS these... Continue Reading →
