Acceldevtestwebcast Dk
-
Upload
dinesh-kumar -
Category
Documents
-
view
223 -
download
0
Transcript of Acceldevtestwebcast Dk
-
7/30/2019 Acceldevtestwebcast Dk
1/22
1 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Accelerating Database Test and DevelopmentStorage Strategies for
Dave Krenik, Storage Solution SpecialistJeff Wright, Principle Software Engineer
-
7/30/2019 Acceldevtestwebcast Dk
2/22
2 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Program Agenda
Business Drivers and Challenges Test and Development in Data Guard
Environments Test and Development in non-Data Guard
Environments Support Services Next Steps
-
7/30/2019 Acceldevtestwebcast Dk
3/22
3 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Business Drivers and ChallengesWhy Organizations are Focused on Database Development and Test
Increasing requirement to speed database application development
Fast moving application/data base requirements require systematic approach to Dev/Test System/Application Patch/Upgrades can introduce risk to Dev/Test Custom Application/Development require deployment in less time.
Need to efficiently deploy copies of large mission critical databases tosupport continuous demands for application development and test
Multiple clones of production databases/systems often required to support Dev/Test activities
Non-Disruptive Cloning Dev/Test requirement for Production Databases Dev/Test and Cloning of Application and Databases must be non-disruptive to Production Dba
Often, organizations have multiple Dev/Test databases for each producenvironment
-
7/30/2019 Acceldevtestwebcast Dk
4/22
4 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Accelerate Dev and Test with ZFS Storage ApplianceBenefits
Automated and implemented with minimal procedural cha
Rich Suite of Data ServicesReduces Risk and Accelerates Dev/Test Processes
Accelerate database development and test;Offload Reporting from Primary OLTP site
Simplicity
Speed
Savings
-
7/30/2019 Acceldevtestwebcast Dk
5/22
5 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Speed Accelerate DeploymentsTested and validated offering speeds deployment
ZFS Storage Appliance Snap/Clones and clonedb instantly providedevelopment and test environments without disrupting production
processing. Accelerates deployment of applications, patches, upgrades, and
development by easily and efficiently providing appropriate quantitiesTest, Dev, and QA databases
In Data Guard environment, greater performance may be achieved bytaking ZFS Storage Appliance snaps & clones from a dedicatedDatabase server (additional EE license required)
DTrace AnalyticsAccelerate development by quickly identifying changes in code that affect thstorage system performance
-
7/30/2019 Acceldevtestwebcast Dk
6/22
6 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
SimplicitySimplicity is the keynote to good design Create the first copy
RMAN DUPLICATE to ZFS Storage Appliance
Data Guard replication to ZFS Storage Appliance ZFS Storage Appliance Snapshot and Clone to deploy
additional copies Oracle CloneDB optimizes startup on ZFSSA clone
When implemented with Data Guard, scripts automate theprocess, further simplifying management of the DRenvironment
Nearly no procedural changes
-
7/30/2019 Acceldevtestwebcast Dk
7/22
7 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Simplicity ProvenEdison Group Usability Study
34% less time required to provision andconfigure storage, and its connectivity Accelerates Deployment
31% less time for maintenance and typical
configuration changes Minimizes downtime and can improve availability
44% less time spent troubleshooting Improves response and can mitigate downtime
Findings show that a ZFS Storage Appliance can be managed moreefficiently than a comparable NetApp system
http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=10178896&src=7011671&Act=169 -
7/30/2019 Acceldevtestwebcast Dk
8/22
8 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Savings A powerful suite of Data Services* including snaps,
compression, thin provisioning and more areincluded with ZFS Storage Appliance
Competitors charge extraOnly Replication and Clones are chargeable dataservices features
Add value to Data Guard DR copies of databaseswith the snapshot, clone features of the ZFSStorage Appliance
Provides every Developer with a dedicateddatabase and uses less storage
-
7/30/2019 Acceldevtestwebcast Dk
9/22
9 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Adding Value to Data Guard DR CopiesAccelerate Application Deployment
Oracle Data Guard provides high availability and disaster protection for missiocritical Oracle databases
Multiple database clones are often required to support development and testassociated with large production systems
Adding a Sun ZFS Storage Appliance to an Oracle Data Guard configuration
provides a low-cost solution for snapshots and clones Tested, validated, and supported by Oracle
-
7/30/2019 Acceldevtestwebcast Dk
10/22
10 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Using ZFS Storage Appliance Snapshot and Clone toCopy Databases
Standby Database onZFS Storage Appliance
Snapshot capability provides a reliablerestore point
ZFS Clones quickly creates multiplelow-overhead Database clones for testand development
-
7/30/2019 Acceldevtestwebcast Dk
11/22
11 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Accelerate Dev & Test with the ZFS Storage Applianceand Data Guard Standby si
Database Server
ZFS Storage Appl
Primary site
Oracle Data Guard
Database Server
Existing ArrayExisting Arr
NFS Share of Stan
Development Database/export/dev_db/*
Test Database/export/test_db/*
The ZFS Storage Appliance is simply added to the customersexisting Data Guard environment
Coordinate ZFS Storage and Data Guard failover and failback
ZFS Storage Appliance Clones Standby Database for Development, Test and Training
Database Clones
Training Database/export/training_db/*
-
7/30/2019 Acceldevtestwebcast Dk
12/22
12 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
The Cloned Database can also be used for ReportingPrimary site Standby si
Oracle Data Guard
Database Server
ZFS Storage Appl
Database Server
Existing Array Existing Arr
NFS Share of Stan
Development Database/export/dev_db/*
Test Database/export/test_db/*
Offloads Primary OLTP site, allowing it to focus on transactionprocessing
Database Clones
Training Database/export/training_db/*
-
7/30/2019 Acceldevtestwebcast Dk
13/22
13 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
The Cloned Database can also be usedfor Backups Standby site
Oracle Data Guard
Database Server
ZFS Storage Appliance
Primary Array
NFS Share of Standby Database
Development Database/export/dev_db/*
Test Database/export/test_db/*
Database Clones
Training Database/export/training_db/*
MSer
Or
Sun
Backup
-
7/30/2019 Acceldevtestwebcast Dk
14/22
14 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Accelerating Test and Development in non-Data Guard Environments
RMAN incrementally updated backup feature is used to backup aSAN-based ASM database into a Network File System (NFS)protocol-based file system on the Sun ZFS Storage Appliance
The snapshot and cloning features of the Sun ZFS Storage Applianceare then used to duplicate or clone the RMAN backup to be accessedas a database
-
7/30/2019 Acceldevtestwebcast Dk
15/22
15 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
RMAN DUPLICATE
Accelerating Test and Development in non-Data GuardEnvironments Database Server
ZFS Storage Appliance
ASM Database Primary Array
Clone Database Server
RMAN backup is done from the production database server Storage based snapshot and cloning is performed The clone database server accesses cloned databases for test and development Backup data files refreshed with incremental merges
-
7/30/2019 Acceldevtestwebcast Dk
16/22
Enhance Exadata and SuperClusterThin Provisioned Database Cloning (using clonedb)
RMAN DUPLICATE
Exadata or SuperCluster
Clone
CloneUnlimited thinprovisioned clones
with Direct NFS,clonedb, and ZFSsnapshots and clones
for databases withHCC compression
ZFS Storage Appliance
Direct NFS
Clone
Copyright 2011, Oracle Corporation and/or its affiliates
-
7/30/2019 Acceldevtestwebcast Dk
17/22
17 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Oracle Hardware and SoftwareEngineered to Work together
Engineered to work togeth
Tested together
Certified together
Deployed together
Managed together
Supported together
-
7/30/2019 Acceldevtestwebcast Dk
18/22
18 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Maximize Availability with Oracle's Service Expertise
Oracle Customer Services storage experts utilize Oracles innovative storagetechnologies to drive efficiencies and maximize business value of storage
infrastructures
ReadinessServices
Oracle storage
experts configure,integrate and teststorage products
and bring them intoproduction
Data MigrationServices
Storage experts
safely test andmigrate data and
applications to thenew environment
and provideknowledge transfer
to staff
OperationsManagement
Proven Backup
Monitoring andManagement asdwell as Restore
services thatdeliver SLA based
Data Protection
tr
Support
Complete System
coverage for embedded systemsoftware delivered
together withsystem support as
a single servicesolution
-
7/30/2019 Acceldevtestwebcast Dk
19/22
19 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Summary
The ZFS Storage Appliance adds value to the disaster recovery capabilities of Oracle Data Guard
Accelerate application deployment with a cost-effectiveplatform for development, test, and quality assuranceOracle MAA tested and certified solution
Lower total cost of ownershipReduce riskSold and serviced by Oracle
-
7/30/2019 Acceldevtestwebcast Dk
20/22
20 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
Next Steps For additional information about the Dev/Test solution
http://www.oracle.com/goto/zfs-data-guard
For more information about Oracle Data Guardhttp://www.oracle.com/technetwork/database/features/availability/data-guard-
documentation-152848.html
For more Information on RMANhttp://www.oracle.com/technetwork/database/features/availability/rman-overview-
096633.html
For additional information about the ZFS Storage Appliancehttp://www.oracle.com/us/products/servers-storage/
-
7/30/2019 Acceldevtestwebcast Dk
21/22
21 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8
-
7/30/2019 Acceldevtestwebcast Dk
22/22
22 Copyright 2011, Oracle and/or its affiliates. All rightsreserved.
Insert Information Protection Policy Classification from Slide 8