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