Ron Ekins' – Oracle Technology, DevOps and Kubernetes Blog
A technical resource for Data Professionals
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →