High Availability for Oracle Database with IBM PowerHA SystemMirror and IBM Spectrum Virtualize HyperSwap

An IBM Redpaper publication

Published 07 September 2017

cover image

ISBN-10: 0738456349
ISBN-13: 9780738456348
IBM Form #: REDP-5459-00
(40 pages)

Authors: Ian MacQuarrie

Abstract

This IBM® Redpaper™ publication describes the use of the IBM Spectrum™ Virtualize HyperSwap® function to provide a high availability (HA) storage infrastructure for Oracle databases across metro distances, using the IBM SAN Volume Controller. The HyperSwap function is available on all IBM storage technologies that use IBM Spectrum Virtualize™ software, which include the IBM SAN Volume Controller, IBM Storwize® V5000, IBM Storwize V7000, IBM FlashSystem® V9000, and IBM Spectrum Virtualize as software.

This paper focuses on the functional behavior of HyperSwap when subjected to various failure conditions and provides detailed timings and error recovery sequences that occur in response to these failure conditions.

This paper does not provide the details necessary to implement the reference architectures (although some implementation detail is provided).

Table of contents

Introduction to HyperSwap
Implications of inter-site latency on performance
Criteria for replication reversal
Note regarding performance evaluation
HyperSwap configuration
SAN topology
Active-Passive Oracle on PowerHA with HyperSwap
Test Case 1 - Test Case 5
Active-Active Oracle RAC with HyperSwap
Test Case 6 - Test Case 9

Follow IBM Redbooks

Follow IBM Redbooks