Use PL/SQL to perform Storage Snapshots from within the Oracle Database using UTL_HTTP

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. I have previously shared how to perform File System snapshots on a Pure Storage FlashBlade using the UTL_HTTP package, in 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 →

Oracle 19c RAC database online migration to ActiveCluster for extended / stretched RAC clusters

In this post I will share how to perform an online move of an Oracle 19c RAC database to a Pure Storage ActiveCluster Pod to provide Active-Active synchronous replicated storage for an extended / stretched Oracle RAC cluster. Step 1 - ActiveCluster Pod The first step is to create a Pod, in the example below... 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 →

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 →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: