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 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 →
Oracle Grid Infrastructure 19c – Oracle ASM Filter Driver (ASMFD)
Following a discussion on the options on how to reclaim space (TRIM/Unmap) on Oracle database using flash storage I though this would make a good topic for a new Blog post. If your Oracle database is using a modern file system it's pretty straight forward, use the 'discard' option. However for the majority of us... Continue Reading →
Getting started with Oracle 19c ASM Filter Driver (ASMFD)
Before I start any new software install I find it's good practice to check the Oracle Certification Matrix on My Oracle Support (MOS). The ASM Filter Driver MOS document is -> ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix). ( Doc ID 2034681.1 ) ... Oracle Linux – RedHat Compatible Kernel 7 3.10.0-123 and later... Continue Reading →