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. In these posts I demonstrated how we can access different file types using SQL external tables on a file system, unfortunately I quickly run... Continue Reading →
How to refresh your Oracle Database on Windows in seconds with PowerShell
Introduction In this short post I will share how we can automate the refresh of an Oracle database on Windows in few seconds with a simple PowerShell script and the Pure Storage PowerShell SDK. Database Volumes In my lab I have an 2 Oracle database each using 2 volumes for the database, which are presented... 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 →
Oracle Rapid Clone Automation (ORCA) for Windows
Introduction I have previously blogged on how a simple Ansible playbook can be used to automate the cloning of Oracle database(s) on Linux, utilising the Pure Storage Ansible modules and storage snapshots. If you're interested my Ansible code for Oracle Rapid Clone Automation (ORCA) can be found up on GitHub or if you prefer to... Continue Reading →
How to control Kubernetes volume provisioning with Portworx commit labels
Introduction By default, Portworx thin provisions volumes and balances them according to current usage and load within the cluster, requiring only minimal configuration. This approach enables applications to provision volumes simply as long as you have enough backing storage for the volume usage. However if the volume usage exceeds your available backing storage, and allocating... Continue Reading →
Protecting your Kubernetes Oracle database with Portworx Volume Group Snapshots
Introduction If you follow my blog or have read my post Oracle Database 19c on Kubernetes with Portworx storage you may have an Oracle database running on Kubernetes and are wondering how do I protect it. In this post I will show you how we can use Portworx Volume Group Snapshots to complement other backup strategies.... Continue Reading →
Performing Oracle RMAN backups to S3 – Part 1: Amazon S3
Background Historically most of the conversations I have regarding Oracle Recovery Manager (RMAN) are around the use of NFS storage such as a Pure Storage FlashBlade, and Oracle Direct NFS (dNFS). However, with more Oracle customers deploying databases in Oracle Cloud Infrastructure (OCI) and / or using Object Storage for backups I thought it was... Continue Reading →
Performing Kubernetes volume and volume group snapshots with Portworx
In this post I am going to show how we can take volume and volume group snapshots with Portworx. I have previous blogged on how you can run an Oracle 19c on Kubernetes with Portworx and will use the PVCs created that blog within this post. Inspect existing Statefulset Before we start let's looks out... Continue Reading →
Resizing Container File Systems with Kubernetes PVCs and Portworx
I have previous blogged on how you can run an Oracle 19c on Kubernetes with Portworx, if you want to check out the code examples you can find them here. In this post I am going to show how we can use a Portworx Storage Class and Persistent Volume Claims (PVCs) to resize a containers... Continue Reading →
Oracle Database 19c on Kubernetes with Portworx storage
Background In this post I am going to share how you can obtain the official Oracle 19.3 Enterprise Edition (EE) Docker image and deliver an Oracle 19c database on Kubernetes 1.17.0 with Portworx 2.6 storage. Kubernetes Cluster Info Before we start let's have a look at our Kubernetes environment $ kubectl cluster-info Kubernetes master is... Continue Reading →