Moving a 20TB Database from ASM to NFS

One of the recent challenges I had was to migrate a 20TB database from ASM to NFS and then decommission ASM. This post will give an overview of how I achieved it in relation to the requirements. Currently our storage of choice for infrastructure is NFS on Netapp and most of our existing databases are […]

Database Startup and Strange Semaphore Problem

One of our Netapp SnapManager database backup jobs was failing due to the instance being down on the first node of a 10G 4 node Solaris RAC. The backups are only configured to run off the first node so when I went to start up the instance I got the following error message:

After […]

NetApp SnapManager – Get Latest Successful Snap from Repo Database

Just started working with NetApp SnapManager and one of the questions I had was how can I find the latest successful snap per host for each database. Well looking around the smo repository we see a table called SMO_33_OPERATIONHISTORY. Now we can write a query to get the data we need.

Looks like exactly […]