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 →
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database using Oracle external files on a local file system or and NFS share from an NFS server e.g. FlashBlade Unfortunately, at that time I... Continue Reading →
Introduction In my post How to access Object Storage from your on-premises database I showed how we configure an Oracle 19c (19.9+) database to use the DBMS_CLOUD package to access objects stored within Object Stores. In this post I will share how I created the Oracle Cloud Infrastructure (OCI) Object Store bucket and objects I... Continue Reading →
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database. In these posts I demonstrated how we can access different file types using SQL external tables on a file system, unfortunately I quickly run... Continue Reading →
Introduction In this short post I will share how we can automate the refresh of an Oracle database on Windows in few seconds with a simple PowerShell script and the Pure Storage PowerShell SDK. Database Volumes In my lab I have an 2 Oracle database each using 2 volumes for the database, which are presented... Continue Reading →
Introduction In a previous post I introduced ORCA for Windows and shared a Video of it in use, in this post we will spend a bit of time looking at some of the techniques I used to implement it.. Working with Ansible Templates One of the Ansible features I find myself using time and time... Continue Reading →
Introduction I have previously blogged on how a simple Ansible playbook can be used to automate the cloning of Oracle database(s) on Linux, utilising the Pure Storage Ansible modules and storage snapshots. If you're interested my Ansible code for Oracle Rapid Clone Automation (ORCA) can be found up on GitHub or if you prefer to... Continue Reading →
Introduction By default, Portworx thin provisions volumes and balances them according to current usage and load within the cluster, requiring only minimal configuration. This approach enables applications to provision volumes simply as long as you have enough backing storage for the volume usage. However if the volume usage exceeds your available backing storage, and allocating... Continue Reading →
Introduction If you follow my blog or have read my post Oracle Database 19c on Kubernetes with Portworx storage you may have an Oracle database running on Kubernetes and are wondering how do I protect it. In this post I will show you how we can use Portworx Volume Group Snapshots to complement other backup strategies.... Continue Reading →
Background In this post I am going to walkthrough how you can get, and install the Oracle ZFS Storage Appliance simulator on VirtualBox. I will then share how we can create an NFS filesystem and configure SNMP to support HCC (Hybrid Columnar Compression). Download OVA Start by downloading the 3.4GB Oracle Storage Appliance Simulator software... Continue Reading →
