Before we can use DataPump with Oracle dNFS we need to create and export an NFS filesystem, prepare our Linux environment and configure our database. Ok let's begin. Create File System For this walkthrough I need an NFS server, fortunately I have access to a Pure Storage FlashBlade in my lab, so I will be... 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 dNFS Monitoring with MONDNFS
If you are using Oracle dNFS (Direct NFS) to deliver or backup your database with Oracle RMAN (Recovery Manager) you may want to consider using Oracle MONDNFS rather than writing you own SQL monitoring scripts. dNFS Views Oracle provide a number of database views to help with the initial configuration and monitoring of dNFS these... Continue Reading →
More database cloning magic with Oracle multi-tenancy and dNFS
Background One of the most exciting announcements at last years Oracle Open World #OOW19 was around multi-tenancy and Oracle change of licensing allowing non multi-tenant users to have up to 3 user-created PDB's in a container database at any time. https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-AB354617-6614-487E-A022-7FC9A5A08472 With the above, and the announcement of de-support of non-CDB architecture from 20c there... Continue Reading →
Oracle database cloning magic with dNFS and CloneDB.
In this Blog Post I will show Oracle's CloneDB, dNFS and Pure Storage FlashBlade snapshots can be used to create space efficient Oracle database clone(s) on a sparse file system. Oracle RMAN backup Source database dNFS mount I will start be taking an RMAN image backup of my Oracle ASM 'labs' database to my dNFS... Continue Reading →
NFS Storage IO Performance Testing with ORION
If you have been following my Blog for a while you will by now know I am a long term fan of Oracle on NFS and more accurately Oracle Direct NFS (dNFS). If you need to re-familirise yourself with Oracle dNFS you could do a lot worse than check-out some of my previous Blogs on... Continue Reading →
NFS storage IO performance testing with ORION (ORacle IO Numbers)
Background In my previous ORION Blog post I described how to prepare a Pure Storage FlashArray block volumes for use with Oracle ORIONĀ (ORacle IO Numbers), in this is Blog I am going to show how this can also be done with NFS. Getting Started - Storage Preparation For the purposes of this Blog I have... Continue Reading →
Getting started with the Oracle ZFS Storage VMware Simulator (Part II)
In this Blog post I will share how your newly created Oracle ZFS Storage VMware Simulator can be used to deliver storage for an Oracle 12c database via dNFS and also support HCC (Hybrid Columnar Compression). Hopefully you have followed Part I of my Blog post on Getting Started with the Oracle ZFS Storage VMware... Continue Reading →
Getting started with the Oracle ZFS Storage VMware Simulator (Part I)
If your like me, you may sometimes need to do some research work with Oracle HCC (Hybrid Columnar Compression), but don't always have access to an Oracle Exadata machine or ZFS Appliance, then the ZFSA simulator may be your saviour. On my Mac I use both VirtualBox and VMware Fusion, but for this Blog post... Continue Reading →
Oracle dNFS Throughput testing
Oracle Direct NFS In my previous Oracle dNFS Blog post I detailed how to configure Oracle 12cR2 to use Oracle dNFS multi-path, in this Blog I will share some test results that I achieved in my Oracle 12cR2Ā Pure Storage FlashBladeĀ lab. Theoretical Limits A Gigabit Ethernet network can transmit 1,000,000,000 bits per second, as we normally... Continue Reading →