This weeks challenge has become to set up ACFS on two new to be implemented Real Application Clusters. As with any tooling first question will be , what is your goal if you want to start using it. My purpose is to start using ACFS as a shared mountpoint between the servers, nodes in the cluster in order to have each instance do its logging (ADR), audit and listener log on that mount.
This blog will tell you about my setting it up, the issues i came across and the way it is implemented in a working way.
To share the plot of the story: After implementing I had the issue that right after cluster reboot all services where launched automatiocally BUT the instances would NOT start automatically. In the end i ended up with ACFS being defined as a shared home for an Oracle RDBMS installation. And it worked/works after cluster reboot cause all resources are happy and online now.
I have been asked to explore a scenario in which a database that is currently on a file systems is recovered with RMAN into ASM. In this web log the steps i have performed are shared.
A single instance/Db 11gr2 under control of 11gr2 grid infrastructure with ASM as storage solution. In ASM the disks are defined as external redundancy due to business rules ( no shooting the messenger please). I was Informed that a database had crashed . Grid Infra structure ( nor manual actions ) were able to start the database again. So I was asked please go take look and fix asap . The good thing was that I was aware of maintenance in the ASM Disk group on that Tuesday September 4th. So when alarms started to go off I had first clues (even Sherlock Holmes needs a first clue right ?). As always the alert log was first place to check for me. This document follows a number of steps during the analyses and the end status which was a proper database open (without reset logs). Bottom-line is give not up too fast. BUT also in this specific scenario it had been better if we had kicked the disk and started from scratch instead of trying to repair. But that being said I know that sounds wise when looking back ….