Introduction In a previous post I have shared how to install and configure the Oracle ZFS Storage Appliance simulator on VirtualBox, and also on VMware Fusion. In this post I am going to show how we can use an Oracle ZFS Storage Appliance simulator to provide an environment to learn about NFSv4.1 and Oracle Direct... Continue Reading →
How to configure Oracle 19c database and DirectNFS with NFSv4.1
How to configure Oracle 19c database and DirectNFS with NFSv4.1 using a Pure Storage FlashBlade
Using autofs with Oracle Recovery Manager (RMAN) and dNFS
Background This week I was asked an interesting question can Oracle dNFS and Oracle Recovery Manager (RMAN) use auto mounts, not knowing the answer I thought I better find out. What is Autofs ? Autofs, also known as automounter mounts filesystems on-demand when they are accessed rather than maintaining the mounts all the time. The... Continue Reading →
Accelerating Oracle DataPump with Oracle dNFS (Direct NFS)
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 Oracle Database 19c 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 (PDBs) 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 →