Ron Ekins' – Oracle Technology, DevOps and Kubernetes Blog
A technical resource for Data Professionals
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 →
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 →
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 →
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 →