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 Automatic Storage Management Cluster File System (ACFS) – Resizing File Systems
So if you read my Getting Started post and have already created your first Oracle Automatic Storage Management (ASM) Clustered File System (ACFS) or have been using it for a while. You may have found yourself needing to resize the ACFS File System, this is easily completed with acfsutil utility. As you can see below... Continue Reading →
Oracle Automatic Storage Management Cluster File System (ACFS) – Getting Started
Background There are many times when a shared file system is a hard requirement or is needed to make life easier. If you don't have access to Pure FlashBlade or other NFS server and need a shared filesystem then Oracle Automatic Storage Management Cluster File System (ACFS) maybe worth considering. Starting with Oracle Automatic Storage... Continue Reading →
Oracle Multi-Tenancy PDB database cloning with ASM
Background One of the most exciting announcements at last years Oracle Open World #OOW19 was around multi-tenancy and the changes to Oracle licensing allowing non multi-tenant users to have up to 3 user-created PDB's in a container database at any time for free. With the above, and the announcement of de-support of non-CDB architecture from... Continue Reading →
Analysing Oracle ASM metadata with KFED
Oracle KFED The kfed like kfod, is one of those Oracle utilities that you may never need to use but it's great to know it's there if your ASM metadata becomes corrupt or just interested in the metadata structure. If you have never used it and want to give it a try, you can find... Continue Reading →
Working with Oracle ASM and KFOD
Oracle KFOD The kfod is another one of those great little, hidden Oracle utilities which can be useful in troubleshooting ASM issues without connecting to an ASM instance. If you have never used it and want to give it a try, you can find it in $GRID_HOME/bin/kfod KDOF help Use kfod -help to list all... Continue Reading →
Reducing Oracle Database 19c Downtime with Switch Database to Copy
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 →
Oracle ASM Filter Driver (ASMFD) – Thin Provisioning
Background Before we start if you are new to the Oracle ASM Filter Driver (ASMFD) you may want to visit a couple of my previous Blog posts where I detailed how to set-up the ASM Filter Driver (ASMFD) via Oracle 19c Grid Infrastructure installer or the Linux command line interface (CLI). In this Blog I... Continue Reading →
Oracle ASM Filter Driver (ASMFD) in Action
I have previously Blogged about configuring the Oracle ASM Filter Driver (ASMFD) using the command line and also the Oracle 19c Grid Infrastructure installer, if you enjoy this video you may want to visit the links above to help you get started. If you're still unsure or not had a good reason to use the... Continue Reading →