I have previously shared how to install the Oracle ADM Filter Driver (ADMFD) using the CLI and also using the Oracle Installer graphical UI. In the post I will share how to migrate existing Oracle ASM UDEV managed disks to use the newer ASM Filter Driver (ASMFD). To confirm ASM Filter Driver has already been... Continue Reading →
How to change an Oracle ASM Diskgroups section size
Traditional disk based storage systems use a sector size of 512 bytes, some all-flash-arrays use 4K sectors sizes, but it's not something we generally consider, do you know what you are using ? If you're not sure you may want to check-out now of my recent posts on how to check disk sector sizes from... Continue Reading →
How to check your disk sector size
I was recently asked 'How can I check to see if my storage supports 4K sector sizes, and if my Oracle 19c database is using it' ? In this post I will share how to check disk sector sizes from Linux, from Oracle Automatic Storage Management (ASM) and via the Oracle kfed utility. Traditional disk... 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 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 →