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 →
Getting started with Kubernetes Persistent File Storage
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 →
Accelerating Oracle DataPump with Oracle dNFS (Direct NFS)
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 →
Reducing Downtime with Switch Database to Copy
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 →
Oracle dNFS Monitoring with MONDNFS
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 →
More database cloning magic with Oracle multi-tenancy and dNFS
Background One of the most exciting announcements at last years Oracle Open World #OOW19 was around multi-tenancy and Oracle change of licensing allowing non multi-tenant users to have up to 3 user-created PDB's in a container database at any time. https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-AB354617-6614-487E-A022-7FC9A5A08472 With the above, and the announcement of de-support of non-CDB architecture from 20c there... Continue Reading →
Oracle database cloning magic with dNFS and CloneDB.
In this Blog Post I will show Oracle's CloneDB, dNFS and Pure Storage FlashBlade snapshots can be used to create space efficient Oracle database clone(s) on a sparse file system. Oracle RMAN backup Source database dNFS mount I will start be taking an RMAN image backup of my Oracle ASM 'labs' database to my dNFS... Continue Reading →
Getting started with Oracle BigData and s3 – Part1
Before we take the Oracle BigData solution out for a test run I will create an s3 bucket and put some test data into the bucket. In this Blog series I will be using the Oracle BigData SQL and Pure Storage FlashBlade which includes support for s3. Make a Bucket I have previously installed and... 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 →
NFS Storage IO Performance Testing with ORION
If you have been following my Blog for a while you will by now know I am a long term fan of Oracle on NFS and more accurately Oracle Direct NFS (dNFS). If you need to re-familirise yourself with Oracle dNFS you could do a lot worse than check-out some of my previous Blogs on... Continue Reading →