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 →
Oracle 19c on Kubernetes Data Protection with Portworx PX-Backup
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 →
Oracle 19c on Kubernetes with NFS Storage and Portworx Proxy Volumes
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 →
How to access a FlashBlade Object Store from within your Oracle 19c database
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 →
Automating Oracle Database Cloning on Windows with Ansible
Introduction In a previous post I introduced ORCA for Windows and shared a Video of it in use, in this post we will spend a bit of time looking at some of the techniques I used to implement it.. Working with Ansible Templates One of the Ansible features I find myself using time and time... Continue Reading →
How to use Ansible to map a Linux device to a vVOL FlashArray Volume
Background In my previous post I walked through how you can determine a vVOL FlashArray volume from a Linux device. In this post I will show how we can automate that process with Ansible using the same /dev/sdd Linux device and some code examples. Ansible Linux Facts Let's start by using the ansible_facts.devices to identify... Continue Reading →
How to map a Linux device to a vVOL FlashArray Volume
Background I have recently seen an increase in the adoption of VMware Virtual Volumes (vVOLS), and a question which is frequently asked is: How I can identify the FlashArray volume from my Linux server ? Identify Linux Device In this example my Oracle database is using a Pure Storage FlashArray and has been migrated to... Continue Reading →
How to deliver Persistent Storage to your OLCNE Kubernetes Cluster
In this Blog I am going to show how we can use the Pure Service Orchestrator (PSO) Container Storage Interface (CSI) driver to deliver Persistent Storage to a 3 node Oracle Linux Cloud Native Environment (OLCNE) Kubernetes Cluster. For this Blog I will be using Vagrant and VirtualBox, if you have not already got Vagrant... Continue Reading →
Oracle Database Volume Tagging with Purity 6.0
One of the Purity 6.0 features I have most eagerly been awaiting is the ability to tag Pure volumes and snapshots. Volume tagging provides a great way of providing additional database and application metadata to FlashArray Volumes to provide application and database aware reporting. In this Blog post I am going to demonstrate how we... Continue Reading →
Automating FlashBlade File System Snapshots with Python
Getting ready for Python3 In this Blog, I will share how you can use the python to manage and automate Pure Storage FlashBlade File System snapshots. Before we can start we need to install the Pure Storage FlashBlade Python SDK, also as Python2 is now deprecated so let's start using Python3. Below are the steps... Continue Reading →