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 →
Online Oracle database storage migration with Oracle ASM
Background So, the time has come to migrate your Oracle database to another storage array. There are a number of different options available to us, including the Oracle online datafile move, Oracle Recover Manager (RMAN) backup/restore, Oracle DataGuard failover, Data Pump, GoldenGate, host base mirroring, storage replication to name just a few. The method selected... Continue Reading →
Oracle database recovery using Storage Snapshot Optimization
Oracle Storage Snapshot Optimization enables you to use third-party storage snapshots to recover a databases to the current time or a specific point-in-time without having the database placed in backup mode. To use Storage Snapshot Optimization, the snapshot technology must conform to the following requirements. The database is crash consistent during the snapshot.The snapshot preserves... 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 →
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 →