EMC@Oracle Open World 2015 - Opening Keynotes by Larry Ellison
October 25 - 29, San Francisco
Today is Sunday, October 25. Oracle Open World 2015 opening keynote was held in Moscon Center North at 5:00pm. Larry Ellison presented his keynote on how Oracle cloud accelerates business innovation and announced a number of new products.
Today is the first day of Oracle Open World 2015. We provided the first session with the topic of 'Seeing is Believing: A DBA's View into Storage for Better Performance and Greater Efficiency' in room 310 of Moscon Center South at 8:00 am. Although it was early morning, there were still over 50 active attendees (most are Oracle DBAs) shown up with great interests and asked many good questions (see the bottom of this blog for Q&A)
2 talented presenters from EMC: Sam Lucido (Left), Director of EMC Global Technical Marketing Engineering & Geoger OTooleIii, Senior Manager of EMC Global Solutions Marketing (Right)
Q & A
Question: What storage matrix can we see from EMC storage plug-in?
Answers: Only Oracle database related storage matrix are visible to DBAs.
Question: Are the storage matrix writable by DBAs?
Answer: no, they are read only.
Question: Is the EMC storage plug-in free or chargeable?
Answer: It is free and can be downloaded from EMC websites.
Oracle OpenWorld 2015 will be held in San Francisco, CA, United States on October 25-29. It is a conference and exhibition that covers topics such as Oracle Database, Oracle applications, Oracle development, Middleware, industrial solutions etc..
As a strategic partner, EMC had been attending OOW for years. Unlike previous years, EMC will not hold a shinning booth this time, instead, EMC will rock VIP Event at the Elan Event Center, 839 Howard St, San Fancisco, DA 94103. Right around the corner from Moscon Center West.
What We Expect from OOW 2015
EMC is the world’s leader in data storage and protection infrastructure for Oracle database and application environments. EMC provides the best platform for Oracle databases and applications with the highest performance, availability, scalability, and data integrity etc.
We will be more interested in the new Oracle database 12c features, the best Oracle database 12c tuning features, Oracle database in-memory, Database as a Service etc.
If you are heading to Oracle Open World you will want to check in at the EMC Rocks VIP Event at the Elan Event Center 839 Howard St, San Francisco, CA 94103. Right around the corner from the Moscone Center West.
The EMC Rocks VIP Event will feature EMC technologies and their integration with Oracle technologies. We will feature technical sessions, expert presentations, demos, and hands-on labs. There will also be food, drinks, a networking event, and a customer appreciation party.
Some of the technical sessions to be covered are:
High Performance Oracle Infrastructure with FLASH Optimized Storage
Protecting Your Oracle Environment – Backup, High Availability & Continuous Availability
Next Generation Enterprise Storage for Oracle Databases
Powering Oracle E-Business Suite with Cisco & VNX
Reducing Oracle License Costs with Converged Infrastructure
Building an Oracle Database-as-a-Service Infrastructure
The scheduled hours are from 8 am to 6 pm Monday October 26th through Wednesday October 28th. Also join EMC for a special networking event between 7-9pm on Monday October 26th and a Customer Appreciation party from 6pm to 9pm on Tuesday October 27th.
EMC ProtectPoint addresses the gaps traditional backup can't cover by integrating best-in-class EMC products that make the backup and recovery process more automated, efficient, and integrated. The integration of ProtectPoint, TimeFinder SnapVX and the Data Domain system allows Oracle ASM database backup and restore to take place entirely within the integrated system! This capability not only reduces host I/O and CPU overhead, allowing the host to focus on servicing database transactions, but also provides higher efficiency for the backup and recovery process. Backup efficiencies are introduced by not requiring any read or write I/Os of the data files by the host.
The paper describes in detail how this solution provides the following benefits
eliminate backup impact on the application
minimize backup completion time
enables faster, more frequent backup for enterprise applications
complete application owner control using native application utilities
meet stringent application protection SLAs
eliminates LAN impact and minimizes SAN bandwidth requirements
reduces backup storage requirements by 10 to 30 times
inline write-and-read verification, continuous fault detection, and self-healing
The engineers developed and tested and provided detailed documentation of the following five use cases:
Backup Oracle ASM database using ProtectPoint
Read-only inspection of the backup on Mount host
Logical recovery on Mount host using the backup as a database-clone
RMAN recovery of Production data files without overwriting them with a backup
RMAN recovery after overwriting Production data files with a backup
This white paper is intended for database and system administrators, storage administrators, and system architects who are responsible for implementing, managing, and maintaining Oracle databases backup and recovery strategy with VMAX3 storage systems.
With the introduction of the third generation VMAX disk arrays, Oracle database administrators have a new way to protect their databases effectively and efficiently with unprecedented ease of use. Reduce the complexity and excessive time demands associated with host-based replications and reduce RTOs for your fastest growing databases. VMAX3 local and remote replication technology allows DBAs the ability to gain control of data protection and database re-purposing quickly and easily.
VMAX3 SnapVX Local Replication
TimeFinder SnapVX combines the best aspects of previous TimeFinder offerings and adds new functionality, scalability, and ease-of-use. VMAX3 TimeFinder SnapVX allows up to 256 snapshots per source device with minimal cache and capacity impact. SnapVX minimizes the impact of production host writes by using intelligent Redirect-on-Write and Asynchronous-Copy-on-First-Write. Both methods allow production host I/O writes to complete without delay due to background data copy while maintaining Point-in-Time consistency for the snapshot copy. RMAN backups can be offloaded to an alternate host by using a linked SnapVX target mounted to Oracle database instance accessing the copy.
VMAX3 SRDF Remote Replication
The EMC Symmetrix Remote Data Facility (SRDF) family of software is the gold standard for remote replications in mission critical environments. The SRDF family is trusted for disaster recovery and business continuity. SRDF offers a variety of replication modes that can be combined in different topologies, including two, three, and even four sites. SRDF and TimeFinder are closely integrated to offer a combined solution for local and remote replication. Consistency can be enabled for either Synchronous or Asynchronous replication mode. An SRDF consistency group always maintains write-order fidelity (also called: dependent-write consistency) to make sure that the target devices always provide a restartable replica of the source application.
White Paper Highlights
In this paper the authors provide guidance on the latest features of VMAX3 for local and remote data protection long with various commonly deployed use cases including backup, D/R and re-purposing for Test/Dev environemnts. It also covers self-service database replication that can be leveraged by database administrators to deploy additional copies under their control.
The configuration and execution of the following nine (9) uses cases are documented and discussed:
Creating a local restartable database replica for database clones
Creating a local recoverable database replica for backup and recovery
Performing full or incremental RMAN backups from a SnapVX replica (including Block Change Tracking)
Performing database recovery of Production using a recoverable snapshot
Using SRDF/S and SRDF/A for database Disaster Recovery
Creating remote restartable copies
Creating remote recoverable database replicas
Parallel recovery from remote backup image
Leveraging self-service replications for DBAs
This white paper is intended for database and system administrators, storage administrators, and system architects responsible for implementing, managing, and maintaining Oracle databases backup and replication on VMAX3 storage arrays.
With the introduction of the third generation VMAX disk arrays, Oracle database administrators have a new way to deploy a wide range of applications in a single high-performance, high capacity, self-tuning storage environment. Using the new EMC® VMAX3™ Service Level Objectives (SLO) feature, a service level can be assigned to an Oracle database. This SLO then manages the underlying storage to provide the expected performance. The assigned SLO and any resource management operations are completely transparent to the database.The SLO assigned to a given Oracle workload can even be adjusted dynamically to meet the demands of shifting workload priorities. For example, when a monthly close cycle occurs, that workload’s SLO can be given higher priority. These features allow VMAX3 storage arrays to support many enterprise applications, together with all their replication needs and auxiliary systems such as test, development, reporting and patch-testing with less administration overhead.
The picture below shows how Service Level Objectives fit in the VMAX3 architecture. SLO policies provide a pre-defined set of levels (such as Platinum, Gold or Silver) that are be supported by the underlying system resources. Each SLO has a specific performance goal and may also have a tier-compliance goal that work with FAST to adjust system resources to meet those goals. .For example, the Bronze SLO will attempt to have no data on EFDs and the Platinum SLO will attempt to have no data on 7.2k rpm drives. Each SLO defines an expected average response time target that application owners can rely on.
In this paper the authors discuss the following topics:
Overview of VMAX3 features and their role in supporting Oracle databases
Planning SLO for Oracle databases
Considerations and configuration for data, log, indexes, TEMP and ARCHIVE files
Considerations for noisy neighbor and competing workload management
Oracle Database Provisioning
Step-by-step procedure with screen shots and explanations
Oracle SLO Management Test Use Cases
Test case 1 – Single database run with gradual change of SLO
Test case 2 – All flash configuration with Oracle DATA and REDO
This white paper is intended for database and system administrators, storage administrators, and system architects who are responsible for implementing, managing, and maintaining Oracle databases and VMAX3 storage systems.
The VMAX Engineering team has just released a new white paper describing the advantages of using the EMC® VMAX3™ family of storage arrays for running mission-critical Oracle workloads using all-flash storage (AFS) configurations. EMC offers customers two options for implementing all-flash solutions with the VMAX3 storage system.
Configuring an array with only flash drives, or
choosing an all-flash Service Level Objective profile in a hybrid/multi-tier configuration.
VMAX3 AFS is an excellent choice to run Oracle mission-critical databases too achieve maximum performance while still having access to the vast set of system features for data protection, data services, resiliency, and availability including:
Data At Rest Encryption (D@RE)
T10-DIF (corruption detection) protection
choice of synchronous and asynchronous remote replications, and
robust local replication with inherent data consistency.
The authors use a single-engine VMAX 400K with 32 flash drives to conduct and document three (3) test cases:
OLTP tests with no VMAX3 cache read-hit benefits
OLTP tests with medium VMAX3 cache read-hit benefits
DSS test with focus on sequential read bandwidth
The test system shown on the right was capable of achieving nearly 200,000 IOPS at < 1 ms read latency in the OLTP tests, and about 6 GB/s bandwidth in the DSS tests. The engineers found that:
Even in a "worst-case scenario" with a workload without VMAX3 read cache benefits, writes continued to be served at sub-millisecond latency from VMAX3 cache and the total IOPS remained over 145k.
With just a medium read-hit rate on the VMAX3 cache of 40 percent, the latency for the data file random read I/O was consistent at 0.75 ms even when some reads were satisfied from the cache and some from the flash drives.
The DSS test showed that VMAX3 in an all-flash configuration is capable of achieving extremely high bandwidth suitable for Oracle reports, BI, and data warehousing (DW) workloads.
All of the test scenarios including descriptions of the hardware, software, and test workloads are fully described. The paper also includes a detail discussion of how VMAX3 persistent cache enables all writes, including Oracle log writes or batch, to complete much faster. The VMAX3 HYPERMAX OS FlashBoost technology for reducing the response time associated with read misses by sending data located on flash drives directly from the back-end to the front-end ports is also discussed in the introduction.