HPE Reference Architecture For Oracle Database 12c On HPE .

2y ago
123 Views
9 Downloads
1.65 MB
34 Pages
Last View : Today
Last Download : 2m ago
Upload by : Gideon Hoey
Transcription

Reference ArchitectureHPE REFERENCE ARCHITECTURE FORORACLE DATABASE 12C ON HPESIMPLIVITY 380 GEN10

Reference ArchitectureCONTENTSExecutive summary. 3Solution overview . 3Solution components. 4HPE SimpliVity 380 Gen10 Node. 5Oracle Real Application Clusters . 5HPE Serviceguard for Linux . 6Oracle Data Guard . 6Hardware. 7Software . 7Application software . 8Best practices and configuration guidance for the solution . 8Network configuration . 8Cluster configuration .11Use Case 1: Deploying pre-production VM running Oracle Database in seconds for test and development environments. 12Use Case 2: Oracle Database 12c - Disaster recovery solution using Oracle Data Guard and HPE Serviceguard for Linux. 13Oracle database and ODG installation and configuration .13Failover test .14Use Case 3: Oracle Database 12c High Availability Solution using Oracle Real Application Cluster (RAC).16Failure scenarios .16Oracle Database 12c High Availability Solution – Two Node Oracle RAC Cluster using shared disks from one of the RACcluster nodes .17Oracle Database 12c High Availability Solution – Two Node Oracle RAC Cluster using ASM mirroring between RAC nodes . 21Capacity and sizing .23Workload description for Oracle RAC scalability tests .24Analysis and recommendations for Oracle RAC scalability .24Use Case 4: Application-consistent Oracle Database VM backup and restore using HPE SimpliVity built-in data protection . 24Oracle RAC backup .27Use Case 5: Crash-consistent Oracle Database VM backup using HPE OmniStack REST API .27Summary .27Implementing a proof of concept .28Appendix A: Crash-consistent Oracle Database VM backup using HPE OmniStack REST API based script.28Appendix B: Bill of materials.31Resources and additional links .34

Reference ArchitecturePage 3EXECUTIVE SUMMARYOracle Database 12c is critical to the operation of many businesses. Unexpected downtime, poor performance, or data loss can lead to lostrevenue, diminished user productivity and customer dissatisfaction. HPE SimpliVity hyperconverged infrastructure provides a highly resilient andscalable operating environment for Oracle Database 12c across a wide variety of use cases.HPE SimpliVity 380 Gen10 is an enterprise-grade hyperconverged platform that is designed and optimized for the virtual machine (VM)environment, speeds up application performance, improves efficiency and resiliency, and restores VMs in seconds.The HPE SimpliVity System is a 2U rack-mounted building block that delivers server, storage, and networking services all-in-one. All of thiscomes at a fraction of the cost, and an extreme reduction in complexity, compared to a traditional infrastructure stack. It is the firsthyperconverged platform to include native data protection, data efficiency, performance acceleration, and global unified management, all ofwhich are delivered with HPE SimpliVity core enabling technology, the Data Virtualization Platform (DVP).This paper documents the following solutions in an HPE SimpliVity Federation configuration. A federation is a collection of one or more HPESimpliVity Clusters and the main construct within which data is managed.HPE SimpliVity Cluster is a collection of one or more HPE SimpliVity hyperconverged nodes, typically located at the same physical site connectedover a standard Ethernet network collectively providing a single storage pool to the hypervisor on each node. Oracle Database 12c - Disaster recovery solution using Oracle Data Guard and HPE Serviceguard for Linux across production and recoverydata centers Oracle Database 12c - High availability solution using Oracle Real Application Clusters (RAC) Oracle Database 12c - Application-consistent Oracle Database VM backup and restore using HPE SimpliVity built-in data protection Oracle Database 12c - Automation of Oracle Database VM backup using HPE SimpliVity REST APIThe testing validated the core benefits of the SimpliVity OmniStack solution, namely: Accelerated Data Efficiency: OmniStack performs inline data deduplication, compression and optimization on all data at inception across allphases of the data lifecycle, all handled with fine data granularity of just 4KB-8KB. On average, SimpliVity customers achieve 40:1 dataefficiency while simultaneously increasing application performance. Built-In Data Protection: OmniStack includes native data protection functionality, enabling business continuity and disaster recovery for criticalapplications and data, while eliminating the need for special-purpose backup and recovery hardware or software. OmniStack inherent dataefficiencies, minimize I/O and WAN traffic, reducing backup and restore times from hours to minutes. Global Unified Management: OmniStack VM-centric approach to management eliminates manually intensive, error-prone administrative tasks.System administrators are no longer required to manage LUNs and volumes; instead, they can manage all resources and workloads centrally,using familiar interfaces such as VMware vCenter .Target audience: The document is aimed for Database Administrators (DBAs), who are responsible for managing database availability andperformance, and their infrastructure counterparts who are responsible for the successful ongoing operation of the infrastructure. This includesindividuals who work with VMware , data center operations, and data protection.Document purpose: The purpose of this document is to describe a Reference Architecture, highlighting recognizable benefits to technicalaudiences.This Reference Architecture describes solution testing performed in March 2019.SOLUTION OVERVIEWThis solution leverages HPE SimpliVity 380 Gen10 Nodes, VMware vSphere version 6.5, Red Hat Enterprise Linux (RHEL) version 7.5, andOracle Database 12c Enterprise edition. The HPE SimpliVity hyperconverged servers provide tremendous value with resiliency and availabilitybuilt into the core architecture. If a host’s hardware were to experience a problem, the VMs residing on the host would be restarted on aremaining host in the federation by VMware HA.

Reference ArchitecturePage 4Four HPE SimpliVity 380 Gen10 Nodes were configured with both 10GbE and 1GbE interfaces. Redundant cablings (Figure 1) were used toprotect against interface failures. In a production environment, the best practice is to deploy multiple network switches in a redundantconfiguration to protect against the loss of a single network switch.LAN / MAN / WANLinkProductiondata centerRecoverydata 26216171818223171718151216161e1e S S11442e2e S52 S52TOP63TOP63iLOiLO4ACT LINKP2P1LINK ACT1UID414ACT LINKP2P1LINK ACT1UID411e1e S S11442e2e S5234P2P1LINK ACT1UID1TOP63iLOiLOACT LINK S52TOP644HPE SimpliVity 380 Node –with Front BazelHPE SimpliVity 380 Node –Rear ViewACT LINKP2P1LINK ACT1UID14HPE SimpliVity 380 Node –without Front BazelFIGURE 1. HPE SimpliVity Federation – 2 plus 2 node network connectivity diagramA common deployment for HPE SimpliVity 380 Gen10 is a two-site environment, in which HPE SimpliVity 380 Gen10 systems are deployed ineach of two data centers, and connected within the same federation. This configuration provides high availability and local backup recoverabilityat each site. It also delivers elegant disaster recovery and simplified management as the SimpliVity systems and all associated VMs are managedfrom a single user interface pane within the VMware vCenter Server management Web Client.SOLUTION COMPONENTSThe section briefly describes the key components of the solution. HPE SimpliVity 380 Gen10 Node Oracle Database 12c HPE Serviceguard for Linux Oracle Real Application Cluster Oracle Data Guard

Reference ArchitecturePage 5HPE SimpliVity 380 Gen10 NodeHPE SimpliVity 380 Gen10, based on the HPE ProLiant DL380 Gen10 Servers is a compact, scalable 2U rack-mounted building block thatdelivers server, storage, and networking services. Adaptable for diverse virtualized workloads, the secure 2U HPE ProLiant DL380 Gen10delivers world-class performance with the right balance of expandability and scalability. It also provides a complete set of advanced functionalitythat enables dramatic improvements to the efficiency, management, protection, and performance - at a fraction of the cost and complexity oftoday’s traditional infrastructure stack.FIGURE 2. HPE SimpliVity 380 Gen 10 NodeThe HPE SimpliVity 380 Gen10 supports Intel Xeon scalable processors with 8 to 22 cores selectable with 1 or 2 CPU options, memoryranging from 144GB up to 1.5TB per node, 1Gb 4 Port Lights-out management (LOM) embedded, 10Gb or 25Gb 2 Port FlexibleLOM and thefollowing storage options. Every HPE SimpliVity 380 Gen10 Node comes with the HPE OmniStack Accelerator Card (OAC) for datadeduplication and compression.HPE SimpliVity comes with two all-flash storage options, 4000 and 6000 Series with different capacity points. Refer to the HPE SimpliVity 380Gen10 QuickSpecs document for more details and the latest information.NOTEDual socket configurations may be required to achieve some capacity points.The 4000 series all-flash is ideal for customers who have read-intensive or typical read/write mixed workloads. The 6000 series all-flash is idealfor customers who have high performance mixed workloads with read and/or write intensive requirements. The 6000 series is recommended forOracle Database solution.The XS and S solutions are very suitable for small and medium-sized business (SMB) and remote office/branch office (ROBO) customers whohave lower compute needs and are looking for an affordable hyperconverged solution. The XL configuration is ideal for customers with highstorage capacity workloads or who need a backup hub for distributed environments. Additional PCI Adapters can be added using a secondaryriser and it can support up to 3 PCI adapters such as 1Gb, 10Gb, 25Gb Ethernet adapters and 16Gb, 32Gb Fibre Channel host bus adapter(HBA) cards for external storage connectivity.Oracle Real Application ClustersOracle Database with the Oracle Real Application Clusters (RAC) option allows multiple database instances running on different servers to accessthe same physical database stored on shared storage. The database spans multiple systems, but appears as a single unified database to theapplication. This provides a scalable computing environment, where capacity can be increased by adding more nodes to the cluster. While allservers in the cluster must run the same OS and the same version of Oracle, they need not have the same capacity, which allows adding serverswith more processing power and memory when more performance is required. This architecture also provides high availability, as RAC instancesrunning on multiple nodes provide protection from a node failure.

Reference ArchitecturePage 6HPE Serviceguard for LinuxHPE Serviceguard for Linux (SGLX) is a software based high availability and disaster recovery solution that increases the availability and uptimeof your business critical applications and minimizes the impact of unplanned outages. SGLX packages applications and other services with theirassociated resources and monitors the entire package for any failure. Each package is monitored for faults related to hardware, software, OS,virtualization layer, virtual machine guests, network, and storage. When any failure is detected, SGLX shuts down the application quickly andsmartly, relocate the application or service to another system with the necessary resources, to bring it into production again.SGLX uses Quorum Server arbitration mechanism to prevent data corruption and loss in case of a split-brain situation among cluster nodes.Quorum server also supports a feature called Smart Quorum, which helps in increasing the availability of critical workloads in case of split-brainsituation. The solutions in this Reference Architecture use virtual machines (VMs) as cluster nodes and a Quorum server running outside theSGLX cluster and Smart Quorum is by default enabled. SGLX also minimizes planned downtime using its Live Application Detach (LAD) androlling upgrade feature to perform maintenance on clusters and install upgrades for any OS and application without downtime. Take advantageof the Cluster Verification technology to find and fix cluster configuration issues before they advance and cause unplanned downtime.This Reference Architecture has captured the test results of HPE Serviceguard integration with Oracle Data Guard on Linux using a 2-nodecluster configuration spread across two sites. The Serviceguard manages and completely automates the role switchover process of Oracle DataGuard databases between primary and physical standby node. SGLX is utilized to start, stop, and monitor the databases and administer thereplication between primary and standby databases. SGLX also performs automatic role management to recover from failures. In case of failuresthe solution automatically recovers the Oracle database by promotion of the standby database instance to primary. This mode of recovery ismuch faster compared to a restart DB based solution. The databases can be located on the same premises or in geographically dispersed datacenters. SGLX performs recovery point objective (RPO) sensitive automatic role management to recover from failures.Oracle Data GuardOracle- Data Guard is part of Oracle Database Enterprise Edition software that provides a comprehensive set of services that create, maintainand monitor one or more standby databases on different server hardware located either at local or remote locations (for the purpose of disasterrecovery) connected via LAN (Local Area Network) or WAN (Wide Area Network). It enables a production-level Oracle database (primarydatabase) to survive disaster and data corruptions. Oracle Data Guard supports three types of standby databases, namely physical standbydatabase, logical standby database and snapshot standby database. For more details, refer to Oracle Data Guard Concepts and Administrationdocumentation. Physical standby database: Provides a physically identical copy of the primary database, with on-disk database structures that are identical tothe primary database on a block-for-block basis. The database schema, including indexes, are the same. A physical standby database is keptsynchronized with the primary database, through Redo Apply, which recovers the redo data received from the primary database and appliesthe redo to the physical standby database. This Reference Architecture document has validated a physical standby solution using SGLX. Logical standby database: Contains the same logical information as the production database, although the physical organization and structureof the data can be different. The logical standby database is kept synchronized with the primary database through SQL Apply, whichtransforms the data in the redo received from the primary database into SQL statements and then executes the SQL statements on thestandby database. Snapshot standby database: Like a physical or logical standby database, a snapshot standby database receives and archives redo data from aprimary database. Unlike a physical or logical standby database, a snapshot standby database does not apply the redo data that it receivesuntil the snapshot standby is converted back into a physical standby database, after first discarding any local updates made to the snapshotstandby database. A snapshot standby database is best used in scenarios that require a temporary, updatable snapshot of a physical standbydatabase.Oracle Active Data Guard is an additional licensed feature that enables read-only access to a physical standby database for queries, sorting,reporting, and web-based access and so on while continuously applying changes received from the production database.Oracle Data Guard provides three modes of data protection known as Maximum Availability, Maximum Performance and Maximum Protection. Maximum Availability: In this mode, transactions do not commit until all redo data needed to recover those transactions has either beenreceived in memory or written to the standby redo log on at least one synchronized standby database. If the primary database cannot write itsredo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primarydatabase availability until it is again able to write its redo stream to a synchronized standby database.

Reference ArchitecturePage 7 Maximum Performance: This is the default protection mode and provides the highest level of data protection that is possible without affectingthe performance of a primary database. This is accomplished by allowing transactions to commit as soon as all redo data generated by thosetransactions has been written to the online log. Redo data is also written to one or more standby databases, but this is done asynchronouslywith respect to transaction commitment, so primary database performance is unaffected by delays in writing redo data to the standbydatabase(s). Maximum Protection: This protection mode ensures that no data loss occurs if the primary database fails. To provide this level of protection,the redo data needed to recover a transaction must be written to both the online redo log and to the standby redo log on at least onesynchronized standby database before the transaction commits. To ensure that data loss cannot occur, the primary database shuts down,rather than continuing to process transactions, if it cannot write its redo stream to at least one synchronized standby database.The databases used in this Reference Architecture used a physical standby database and the protection mode was set to maximum availability.In this environment, integrating Oracle Data Guard with HPE Serviceguard for Linux using HPE Serviceguard Toolkit for Oracle Data Guard onLinux provides the following advantages: Provides high availability and disaster recovery with fully automatic and fast recovery for Oracle databases Monitoring for primary and secondary DB instances and the Oracle Data Guard processes Smart Quorum feature decides which site will survive in an event of a split between the sites based on the workload criticality Recovery Point Objective sensitive recovery Built-in monitoring capabilities to check system resources, such as network, volume groups, files systems, etc. and failover in the case of failureof any of these components Protect and recover the application stacks in addition to databases Failure and status notifications Advanced features to minimize downtime for planned maintenanceHardwareTABLE 1. Solution components - HardwareHWSizingHPE SimpliVity 380 Gen10 Node4 NodesMemory768 GB per nodeCPUIntel Xeon Gold 6142 CPU @ 2.60 GHz2 CPU sockets with 16 cores per socket64 logical processors with Hyper Threading enabledNetworkingStorage and federation: 10GbE switchesManagement: 1GbE switchesHPE OmniStack3.7.6.157SoftwareTABLE 2. Solution components - SoftwareSWReleaseServiceguard for Linux12.30VMware vSphere6.5 U2Red Hat Enterprise Linux7.5HPE SimpliVity Plug-in for vSphere Web Client15.39.20

Reference ArchitecturePage 8Application softwareTABLE 3. Solution components – applicationSWReleaseOracle Database Software and Grid InfrastructureOracle Database 12c Enterprise Edition 12.2.0.1Oracle Data Guard12.2.0.1, included in Oracle Database SoftwareOracle Real Application Cluster12.2.0.1, included in Oracle Database SoftwareBEST PRACTICES AND CONFIGURATION GUIDANCE FOR THE SOLUTIONThis section describes various best practices and configuration guidance for Oracle database on HPE SimpliVity solutions.Network configurationThis section describes the network configuration that was deployed in this Reference Architecture.HPE SimpliVity deployment networksThe HPE SimpliVity deployment network usually contains 4 networks known as, Management network, VM network, federation network andStorage network. Federation and Storage networks always use 10Gbe interface and Management & VM networks may either use 10Gbe networkor 1Gbe network based on application workload needs.NOTEHPE SimpliVity 380 Gen10 node supports 10/25GbE – 2 Port FlexLOM as well. If a production workload needs higher bandwidth, 10/25GbEcould be ordered instead of 10GbE – 2 Port FlexLOM.Figure 3 depicts the configuration used in this Reference Architecture, where the Oracle database client side network is connected to 10Gbenetwork port group called VM Network – 2 and the SGLX heartbeat and Oracle RAC private network is configured on a separate port group with1Gbe NIC teaming interface, called as PvtNet. Oracle recommends a dedicated private network for Oracle RAC setup and preferably a 10Gbnetwork, if heavy workloads are going to run on the Oracle RAC database.FIGURE 3. HPE SimpliVity 380 Gen10 Node – VMware ESXi network configuration

Reference ArchitecturePage 9The Storage network handles below traffic: VMware datastore access to VMs.The federation network handles below traffic: Communication between HPE SimpliVity nodes within an HPE SimpliVity Cluster. VM replication between HPE SimpliVity nodes within an HPE SimpliVity Cluster. If network route is available, VM level backup traffic goes between HPE SimpliVity Clusters via the federation network within an HPESimpliVity Federation.NOTEBackup traffic by default is transported over the federation network if a network route is available between the federation networks of HPESimpliVity hyperconverged nodes. If there is no route available, which is generally the case with remote data centers, the backups are transportedover the management network. Therefore, based on the backup schedules and rate of change of data on the VMs being protected, sufficientbandwidth should be available on the management network.HPE SimpliVity node - NIC TeamingNIC teaming helps to increase network capacity for the virtual switch hosting the team and provides passive failover if the hardware fails or itloses power. To use NIC teaming, you must uplink two or more adapters to a virtual switch and the following settings need to be set for every NICteam in the setup at vCenter Simplivity Federation Click Hosts to open Objects tab Right click on host and click Settings Click onNetworking subtab Click the name of the switch Click the pencil icon to open the Edit Settings dialog box: Load balancing: Route based on the original virtual port Network failover detection: Link status only Notify switches: Yes Failback: YesIn this configuration, a VM will have its network running on a designated physical NIC only and can failover to another NIC within the NICte

Oracle Database 12c - Disaster recovery solution using Oracle Data Guard and HPE Serviceguard for Linux across production and recovery data centers Oracle Database 12c - High availability solution using Oracle Real Application Clusters (RAC) Oracle Database 12c - Application-consistent Oracle

Related Documents:

HPE ProLiant DL180 Gen9 HPE ProLiant DL360 Gen9 HPE ProLiant DL380 Gen9 HPE ProLiant DL560 Gen9 HPE ProLiant ML30 Gen9 HPE ProLiant ML110 Gen9 HPE ProLiant ML150 Gen9 HPE ProLiant ML350 Gen9 Apollo 4200 Apollo 4500 Apollo 6000 . HP Smart Array P440/2GB Controller . HPE ProLiant DL20 Gen9 HPE ProLiant DL80 Gen9 HPE ProLiant DL120 Gen9

QuickSpecs HPE USB Keyboard/Mouse Kit Overview HPE ProLiant DL180 G6 Page 3 HPE ProLiant DL180 Gen9 HPE ProLiant DL20 Gen9 HPE ProLiant DL320 G6 HPE ProLiant DL320e Gen8 HPE ProLiant DL320e Gen8 v2 HPE ProLiant DL360 G7 HPE ProLiant DL360e Gen8 HPE ProLiant DL360p Gen8

medical conditions that could occur during a variety of physical activities n State Standards HPE 4 HPE 4 HPE 4 HPE 4 HPE 4 HPE 4 HPE 4 HPE 4 HPE 4 HPE 4 National Standards NPE 2, NPE 5 NPE 2, NPE 5 NPE 2, NPE 5 NPE 2 NPE 2 NPE 2 NPE 2 NPE 2 NPE 2 NPE 2

QuickSpecs HPE Ethernet 1Gb 4-port 331T Adapter Compatibility Page 2 Compatibility Servers ProLiant DL (rack-optimized): HPE ProLiant DL160 Gen8 HPE ProLiant DL165 G7 HPE ProLiant DL320e Gen8 HPE ProLiant DL360e Gen8 HPE ProLiant DL360p Gen8 HPE ProLiant DL380e Gen8 HPE ProLiant DL380p Gen8 HPE ProLiant DL385p

QuickSpecs HPE Ethernet 10Gb 2-port 560FLR-SFP Adapter . Compatibility . Page 3 . Servers . ProLiant DL (rack-optimized): HPE ProLiant DL120 Gen9 HPE ProLiant DL160 Gen9 HPE ProLiant DL180 Gen9 HPE ProLiant DL360 Gen9 HPE ProLiant DL380 Gen9 HPE ProLiant DL560 Gen9 HPE ProLiant

HPE MSA 2040 SAN Storage . HPE MSA 2050 SAN Storage . HPE D3610 Disk Enclosure . HPE D3710 Disk Enclosure . . User Guide, HPE Smart Array SR Gen10 Configuration Guide, and HPE Smart Array SR Secure Encryption Installation and User . which are sold at the H

HPE ProLiant BL460c Gen9 HPE ProLiant BL660c Gen9 HPE ProLiant WS460c Gen9 HPE ProLiant BL460c Gen8 HPE ProLiant BL465c Gen8 HPE ProLiant BL660c Gen8 NOTE: This is a list of supported servers. Some may be discontinued. Compatibility - Supported Interconnect Modules HPE Virtual Connect FlexFabric-20/40 F8 Module for c-Class BladeSystem

analyses of published criminal justice statistics, including data about crime, the courts and prison systems in a number of countries. Secondly, there are reviews of a small selection of recent academic literature on criminal justice subjects, which we looked at in order to provide Committee Members with some insights into the directions being taken in current research. 3 In neither case was .