In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. For the purpose of this post I will be using an Oracle 21c database and a Pure Storage FlashBlade... Continue Reading →
Accessing on-premises S3 Object Storage from Oracle 19c or 21c databases with DBMS_CLOUD
In this post I will share to how to create an external table using the DBMS_CLOUD package and then run a query against a csv file uploaded into a Pure Storage FlashBlade S3 Object Storage bucket. I have previously shared how to install and configure the Oracle DBMS_CLOUD package, if you want to follow this... Continue Reading →
Working with Oracle 19c database and on-premises S3 Object Storage with DBMS_CLOUD
The DBMS_CLOUD package has been available for on-premises 19c database for over a year now, and since the initial 19.9 release several fixes have been shipped, so I suggest you consider using the latest patch if possible, to avoid any known issues. I have previously shared how to configure an Oracle 19c database to use DBMS_CLOUD... Continue Reading →
How to get started automating Pure Storage FlashArray and FlashBlade tasks with Ansible
Introduction If you have been following my blog for a few years you may have already read some of my blogs on Ansible, or used seen some demos or even pulled some Ansible code from my GitHub repo I was recently asked How can I learn more about Ansible, and the how can I start... Continue Reading →
How to Replicate FlashBlade S3 Objects to Oracle Cloud Infrastructure (OCI) Object Storage
Introduction The popularity and adoption of Object Storage continues to grow, with more and more applications and databases using or having an option to utilise Object Storage. I have previously shared a number of posts discussing S3 including: Performing Oracle RMAN backups to S3 to Amazon S3 Object StoragePerforming Oracle RMAN backups to SS to on-premises... Continue Reading →
How to configure Oracle 19c database and DirectNFS with NFSv4.1
How to configure Oracle 19c database and DirectNFS with NFSv4.1 using a Pure Storage FlashBlade
Performing Oracle Database Recovery Manager (RMAN) backups to On-Premises FlashBlade S3 Object Storage
Background Historically most of the conversations I have regarding Oracle Recovery Manager (RMAN) have been around the use of NFS storage, and Oracle Direct NFS (dNFS). However, more recently with the explosion in the use of Amazon S3 object storage, the topic of RMAN and S3 gets frequently raised. In Part 1 of this series... Continue Reading →
Protecting Oracle backups from ransomware and malicious intent
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 →