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 →

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 →

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 →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: