EMC S YMMETRIX VMAX USING EMC …

1 White Paper Abstract This white paper introduces EMC symmetrix vmax software and hardware capabilities, and provides a comprehensive set of best practices and procedures for high availability and business continuity when deploying Oracle Database 11g and 12c with symmetrix vmax , vmax 10K, 20K and 40K. This includes EMC timefinder and symmetrix Remote Data Facility ( srdf ), which have been widely deployed with Oracle databases. July 2014 EMC S YMMETRIX vmax USING EMC srdf / timefinder AND ORACLE 2 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Copyright 2014 EMC Corporation. All rights reserved. EMC believes the information in this publication is accurate as of its publication date.

2 The information is subject to change without notice. THE INFORMATION IN THIS PUBLICATION IS PROVIDED AS IS. EMC CORPORATION MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Use, copying, and distribution of any EMC software described in this publication requires an applicable software license. For the most up-to-date listing of EMC product names, see EMC Corporation Trademarks on All other trademarks used herein are the property of their respective owners. Part Number 3 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Table of Contents Executive 6 Audience.

3 7 Introduction .. 8 symmetrix vmax ease of use, scalability and virtualization features .. 8 Oracle mission-critical applications require protection strategy .. 8 Enterprise protection and compliance USING srdf .. 8 Oracle database clones and snapshots with timefinder .. 9 Oracle database recovery USING storage consistent replications .. 9 Best practices for local and remote Oracle database replications .. 9 timefinder and srdf Use Cases for Oracle databases .. 9 Products and features overview .. 10 symmetrix vmax .. 10 symmetrix vmax Auto-Provisioning Groups .. 11 Fully Automated Storage Tiering (FAST DP).. 12 Fully Automated Storage Tiering Virtual Pools (FAST VP) .. 12 FAST VP srdf coordination .. 13 symmetrix vmax timefinder product family .. 14 timefinder /Clone and cascaded clones .. 15 timefinder /Snap and timefinder /Snap Recreate.

4 16 timefinder VP Snap Enginuity 5876 .. 16 VP Snap Restore to Target (RTT) .. 18 timefinder Consistent Split .. 19 timefinder and srdf .. 19 symmetrix vmax srdf Overview .. 20 srdf modes of operation .. 20 srdf topologies .. 24 Leveraging timefinder and srdf for data consistency .. 27 ASM rebalancing and consistency technology .. 27 Oracle Database 12c Storage Snapshot Optimization .. 28 Leveraging timefinder and srdf for business continuity solutions .. 30 Database storage layout and best practices .. 30 Use Case 1: Offloading database backups from production .. 33 High-level steps .. 33 Device groups used .. 33 Detailed steps .. 34 4 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Use Case 1a USING timefinder to create local space efficient clones, VP Snap .. 36 Use Case 2: Parallel database recovery.

5 37 High-level steps .. 37 Device group used .. 37 Detailed steps .. 37 Use Case 3: Local restartable replicas of production .. 39 High-level steps .. 39 Device group used .. 39 Detailed steps .. 39 Use Case 4: Remote mirroring for disaster protection (synchronous and asynchronous) .. 40 High-level steps .. 40 Device group used .. 40 Detailed steps .. 40 Use Case 5: Remote restartable database replicas for repurposing .. 42 High-level steps .. 42 Device group used .. 42 Detailed steps .. 42 High-level steps .. 43 Device groups used .. 43 Detailed steps .. 43 Use Case 7: Parallel database recovery from remote backup replicas .. 44 High-level steps .. 44 Device groups used .. 44 Detailed steps .. 44 Use Case 8: Fast database recovery from a restartable replicas .. 46 High-level steps .. 46 Device group used.

6 46 Detailed steps .. 46 Use Case 8a Demonstrating fast database recovery USING a restartable timefinder VP Snap Restore to Target .. 49 Use Case 9: Storage Snapshot Optimization USING timefinder and Oracle database 12c .. 50 High-level steps .. 50 Device group used .. 51 Detailed steps during recovery .. 51 Conclusion .. 53 Appendix: Test storage and database configuration .. 54 General test environment .. 54 Test setup .. 54 5 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Storage and device specific configuration: .. 54 6 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Executive summary The EMC symmetrix vmax array is built on the strategy of simple, intelligent, modular storage, USING the Virtual Matrix architecture that connects and shares resources across multiple vmax engines, allowing the storage array to seamlessly grow from an entry-level configuration into the world s largest storage system.

7 symmetrix vmax provides improved performance and scalability for demanding enterprise database environments while maintaining support for EMC s broad portfolio of software offerings. With the release of Enginuity 5876, symmetrix vmax systems now deliver new software capabilities that improve ease of use, business continuity, Information Lifecycle Management (ILM), virtualization of small to large environments, and security. symmetrix vmax arrays are well integrated with Oracle databases and applications to support their performance needs, scalability, availability, ease of management, and future growth. This white paper describes symmetrix vmax software and hardware capabilities, and provides a comprehensive set of best practices and procedures for high availability and business continuity when deploying Oracle Database 11g with EMC symmetrix vmax .

8 This includes EMC timefinder and symmetrix Remote Data Facility ( srdf ), which have been widely deployed with Oracle databases. 7 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Audience The primary audience of this white paper is database and system administrators, storage administrators, and system architects who are responsible for implementing, maintaining, and protecting robust databases and storage systems. It is assumed that the readers have some familiarity with Oracle database backup aspects and EMC software, and are interested in achieving higher database availability and protection. 8 EMC symmetrix vmax USING EMC srdf / timefinder and Oracle 11g Introduction symmetrix vmax ease of use, scalability and virtualization features The latest symmetrix vmax products provide enhanced performance, scalability, and availability, and Enginuity 5876 supports many ease of use, virtualization, and ILM functionalities.

9 With symmetrix vmax Auto-Provisioning Groups, mapping devices to small or large Oracle database environments becomes fast and easy. Devices, HBA WWNs, or storage ports can be easily added or removed, and automatically these changes are propagated through the Auto-Provisioning Groups, simplifying complex storage provisioning for both physical and virtual environments. Fully Automated Storage Tiering for Virtual Pools (FAST VP) provides real-time, sub-LUN storage management, by storage group, to migrate data to the appropriate storage tier. Enhancements to both timefinder and srdf allow system managers choose the best data replication and recovery options at the lowest cost. Oracle mission-critical applications require protection strategy The demand for database protection and availability increases as data grows in size and, as databases become more interconnected, it is essential to have continuous access to the all databases and applications.

10 Data centers face disasters caused by human errors, hardware/software failures, and natural disasters. When disaster strikes, the organization is measured by its ability to resume operations quickly, seamlessly, and with the minimum amount of data loss. Having a valid backup and restartable image of the entire information infrastructure greatly helps achieve the desired level of recovery point objective (RPO), recovery time objective (RTO), and service level agreement (SLA). Enterprise protection and compliance USING srdf Data consistency refers to the accuracy and integrity of the data and between copies of the data. symmetrix vmax offers several solutions for local and remote replication of Oracle databases. With srdf software, single or multiple database mirrors can be created, together with their external data, application files and message queues all sharing a consistency group.