Various thoughts on Oracle, Enterprise Architecture, Cloud Computing, Kubernetes and everything Storage
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
