Customers deploying production Oracle workloads have stringent requirements to support and maintain critical database operational tasks such as Backup and Recovery, Cloning, Data Refresh for Development/Test environment and Patching. These operational tasks are also known as Database Day 2 Management Operations.
With the rapid adoption of VMware vSAN™ for business-critical workloads due to highly scalable, available, reliable, and high performance HCI solution. It is essential to provide features and tools for seamless Day 1 and Day 2 Operations.
vSAN offers a range of tools and features for Day 1 and Day 2 Operations. VMware vSphere® web client provides administrator with the capability to manage their infrastructure in a unified way for deploying, provisioning, health check, and performance monitoring. vSAN 6.0 and above has improved snapshot capability, which provides users with enterprise-class snapshots and clones that can be used for Oracle database cloning use cases.
The Oracle Real Application Clusters on VMware vSAN reference architecture addresses common business challenges that CIOs face today in an online transaction processing (OLTP) environment that requires availability, reliability, scalability, predictability and cost-effective storage, which helps customers design and implement optimal configurations specifically for Oracle RAC Database on vSAN.
The Oracle Database 12c on VMware vSAN 6.2 All-Flash reference architecture addresses common business challenges that CIOs face today in an OLTP and decision-support-system (DSS) environment that requires predictable performance and cost-effective storage.
Having addressed the Day 1 operations including deployment and provisioning of critical Oracle workloads on VMware vSAN, this operation guide focuses on the Day 2 Operations of Oracle on vSAN including backup and recovery, database cloning, database refresh for test and development environment and database patching.
VMware vSAN snapshot and clone technologies are primarily used for providing support to Oracle Day 2 Operations. VMware vSAN snapshot and clone technologies used with inherent Oracle tools provide efficient Day 2 Operations for business-critical Oracle database.
Check out the recently published Oracle database 12c on VMware vSAN Day 2 Operations and Management operation guide that provides solutions and operation procedures for Oracle Database Day 2 Operations including below key oracle database tasks using vSAN snapshots and clones:
- Backup and recovery
- Data refresh for development and test environment from production
While the operation guide provides above solutions natively for the Oracle database on vSAN environment. There are backup vendors who provide Oracle application-level integration along with VADP (VMware vSphere Storage APIs – for Data Protection) API integration, which can help in ease of backup/cloning, greater levels of manageability and control in vSphere environment including vSAN. These third-party backup solutions can also be used for these use cases.
Further, with the announcement of VMware Ready for vSAN program that offers partners a set of tools, resources, and processes needed to certify Data Protection products with VMware vSAN. This certification program will provide confidence with the partner data protection solutions deployed in VMware vSAN environments for seamless operation.