High throughput and mission-critical Oracle VLDB put a heavy demand on backend database storage. To meet the service level agreement (SLA), the database storage must deliver the required capacity and high input/output operations per second (IOPS) while maintaining sub-millisecond latency performance. This is particularly challenging when deploying such a database workload in the public cloud with a shared storage resource environment. Not all storage platforms are created equal. GCNV is a premium storage service offered by Google that can support mission-critical Oracle Database deployments in Google Cloud, requiring sustained IOPS and low-latency performance characteristics. The architecture accommodates OLTP and OLAP workloads, with configurable service tiers supporting various performance profiles. GCNV delivers blazing-fast performance with sub-millisecond latency, achieving up to 4.5 GiBps per volume throughput with mixed read/write workloads.
Leveraging the fast snapshot backup (seconds) and clone (minutes) feature of GCNV, full-size copies of the production database can be cloned from Physical Standby on the fly to serve many other use cases such as DEV, UAT, etc. You can do away with an Active Data Guard license and inefficient and complex Snapshot Standby. The cost savings can be substantial. For a nominal Oracle Data Guard setup with 64 cores CPUs on both primary and standby Oracle servers, just the Active Data Guard licensing cost saving amounts to $1,472,000 based on the latest Oracle price list.
For the solution details, refer to following documentation:
TR-5006: High Throughput Oracle VLDB Implementation on Google Cloud NetApp Volumes with Data Guard
Automated Oracle Clone Lifecycle on GCNV with ASM
Video demo:
https://netapp.hosted.panopto.com/Panopto/Pages/Viewer.aspx?id=74062c18-b120-45b7-9bf9-b2db00f73675
