Here’s the summary of database-related documents followed by a list of videos:
Oracle on ONTAP Best Practices
TR-3633 is an evolving document that details the critical information anyone using Oracle on ONTAP needs to know. It can’t cover everything, but it’s got the must-know information. In particular, it has some information on Oracle virtualization that you won’t find anywhere else.
Customers and account teams were constantly asking questions about migration options. The right approach was a massive “it depends”, so I created TR-4534 to explain the available options, and there are a lot of them, and information about how to pick the best option. DBA’s will get useful information on non-Oracle based applications, and non-DBA’s will get a better understanding of database-level options.
TR-4591 is a sort of companion document to general best practices TR-3633. There used to be a smaller appendix in TR-3633 that covered the basic principles, but I decided it was time to make something more detailed.
This document current covers the Oracle and Microsoft SQL Server, but I intend to add material on MySQL/MariaDB, PostgreSQL, and DB2. I’ve partially written a lot of it already.
TR-4592 shares a lot of content with TR-4591, but it’s aimed specifically at MetroCluster deployments and the principles of using Oracle with a synchronous mirroring storage solution.
Oracle on Cloud Volumes ONTAP
TR-4676 and TR-4691 cover, predictably, the use of Oracle databases on Cloud Volumes ONTAP, the product formerly known as ONTAP Cloud. There are now two ways to use ONTAP in the Public Cloud. Cloud Volumes Service, which is a physical ONTAP system operated as a service by NetApp, and Cloud Volumes ONTAP which is the ONTAP operating system running in a hyperscaler virtual machine.
Oracle on ONTAP Select
Don’t underestimate the power of ONTAP Select running on your own virtualization infrastructure. It’s still ONTAP like any other ONTAP with all the features, and the performance capabilities are sufficient to meet the majority of production workloads I’ve seen at even our largest customers. More details in TR-4690.
Databases with FabricPool
TR-4695 covers databases (not just Oracle) with FabricPool. In a nutshell, FabricPool is cloud tiering for ONTAP. The hot blocks stay on local storage, the cool blocks get shipped off to cheaper object storage, like NetApp StorageGrid WebScale, Amazon AWS, or Azure BLOBs. If object store isn’t part of your NVMe strategy, it should be. Read the TR for details why.