Migrate Your Oracle Databases with Mi i l D Minimal Downtime ti For the audio portion of the webcast, dial: T ll f Toll-free: +1 1 (888) 732 732-6202 6202 Toll: +1 (719) 457-1017 Passcode: 811556
Unable to join the live meeting? Enter the below into y your web browser: https://www.livemeeting.com/cc/quest/join Enter the required information: Meeting ID: 6Q6MN2 Entry Code: sRk sRk~9]]*4 9]]*4 Location: https://www.livemeeting.com/cc/quest © 2009 Quest Software, Inc. ALL RIGHTS RESERVED
Before we get started started... • Speaker: Noel Sidebotham – H Has b been with ith Q Questt ffor almost l t 10 years, and dh has b been working ki with SharePlex since v2 in variety of pre and post sales roles. He is now the Presales Oracle domain expert for the UK.
• To maximize the viewing area of the presentation on your screen, press F5 (press ESC to return to normal mode) • All lines are on mute • We will have Q&A at the end or you may enter questions as we go using the Q&A feature in Live Meeting • This webcast will be available for replay. A URL will be provided at the end
2
A Few Quick Polling Questions
3
Agenda • • • • • • • • • •
Oracle Dates for Discontinued Support Migration Reasons Migration Lifecycle Oracle Migration Methods Drawbacks of Traditional Migration Methods Oracle Migrations with Quest’s Quest s SharePlex How SharePlex works Summary Wrap-up Q&A
4
A bit of History...Oracle Database release dates •
Most recently Oracle has been releasing a new version every 2 y years. Oracle 7 Oracle 8 Oracle 8i Oracle 9i Oracle 9.2 Oracle 10g Oracle10gR2 Oracle 11g g Oracle11gR2
1992 1997 1998 2001 2002 2004 2005 2007 2009
2015 2010 2005 2000 1995 1990
Series1
1985 1980
5
Oracle De-support Dates • • • • • • •
Oracle Release Oracle Database 11.2 Oracle Database 11.1 Oracle Database 10.2 10 2 Oracle Database 10.1 Oracle Database 9.2.0 Oracle Database 8.1.7
Premier Support PSE=Jan 2015 PSE=Aug 2012 PSE=Jul PSE Jul 2010 PSE=Jan 2009 PSE=Jul 2007 PSE=Dec 2004
Extended Support ES=Jan 2018 ES=Aug 2015 ES=Jul ES Jul 2013 ES=Jan 2012 ES=Jul 2010 ES=Dec 2006
Sustained Support SS=Indefinite SS=Indefinite SS=Indefinite SS Indefinite SS=Indefinite SS=Indefinite SS=Indefinite
Premier Support Includes: – – – – – –
•
Extended Support same as Premier for additional 3 years for an additional Fee – – – –
•
Standard 5 year support policy Major Product and technology releases Technical Support U d t Updates, Fi Fixes, S Security it Alerts, Al t Data D t Fixes, Fi and d critical iti l patches t h Upgrade Scripts Certification
M j P Major Product d t and d ttechnology h l releases l Technical Support Updates, Fixes, Security Alerts, Data Fixes, and critical patches for only those created during the PS stage Upgrade Scripts for only those created during the PS stage
Sustained Support (free) As Extended Support but does not include fixes etc etc... created after the PS Stage expired. 6
Oracle De-support Dates So what does this mean? •
If you are on 9i then you should now start planning your upgrades to 10g or even 11g
•
If you are on 10g, then you should purchase Extended Support or upgrade to 11g
•
For more info see the Oracle Lifetime Support Policy for Oracle Technology Products – http://www.oracle.com/support/lifetime-support-policy.html http://www oracle com/support/lifetime support policy html
7
Migration Reasons • OS Migrations – Moving to new servers (e.g. IBM Power4 to Power6) – RAC or Virtualized environments
• Change Hardware Vendor – Moving g to lower-cost OS ((Unix to Linux)) – Moving to virtualized environment
• Oracle migrations – Expired support on older versions cost prohibitive – Need new features/functionality in newer versions
• Application Migrations – Upgrading the application to a newer version – May co-inside with a hardware and or database upgrade
8
Take the pains out of upgrading to Oracle11g • Benchmark Factory
• TOAD DBA Suite • Foglight Performance Analysis • Space S Manager M with ith LiveReorg
• Foglight for Oracle • Foglight Performance Analysis • Spotlight on Oracle
Manage /T /Tune
Load Test
Monitor
Migrate • SharePlex for Oracle
9
Migration Lifecycle •
M Manage/Tune /T your existing i i 10 10g D Database b – Toad DBA Suite, for daily database administration, diagnostics and tuning – Space Manger with LiveReorg to identify fragmentation, IO contention and determine if optimization is required during migration. – Foglight Performance Analysis establishes an activity profile for current database performance
•
Load Testing new hardware/database – Benchmark Factory stress tests database, database hardware and SQL on the new environment with virtual users.
•
Migrate to new hardware/database – SharePlex allows you to migrate/upgrade databases with near-zero near zero downtime and provides instant regression capabilities
•
Monitor hardware/database post upgrade – Foglight for Oracle’s database monitoring alerts you to any issue post migration. – Spotlight on Oracle’s provides real-time diagnostics to identify root causes – Foglight Performance Analysis identifies any performance issues and advises on how to improve the database configuration or identifies bad SQL for tuning. It also compares the activity profile pre-upgrade with post-upgrade activity to identify differences in performance and quantify the impact of the migration changes changes.
10
Traditional Oracle Migrations Methods •
Export / Import or Data Pump • Pro – Simple, cross platform regardless of db version • Cons - Requires downtime, slow (Data Pump Considerably faster but requires 10g), regression = restore backup
•
Database upgrade wizard • Pro – no extra hardware/resources required • Cons – In place, downtime required, downgrade scripts unreliable
•
Cold Copy • Pro o–S Simple, p e, Fast ast • Cons – Requires downtime, restricted to same platform, regression = restore backup
•
Manual Scripts, Transportable Tablespaces • Cons - DBA requires expert knowledge of application, Requires downtime, regression = restore backup
•
Online Backup (Mirror/RMAN/Dataguard) • Pro – Online, from 10g cross platform • Cons – restricted to same platform unless migrating from 10g (downtime required to upgrade db), regression = restore backup 11
Traditional Oracle Migrations Ill t t d Illustrated
12
Traditional Migration
13
13
14 Standard Migration
14
15 Standard Migration
15
16 Standard Migration
16
Drawbacks of Traditional Migration • Downtime Components Length of downtime for data movement and upgrade Test & Verify occur during downtime
• Risk Ri k F Factors t Post upgrade database performance issues H d Hardware reliability li bili Time constraints to finish Complex, error-prone process No ability to test Production load Li it d regression Limited i strategy t t
17
Why Oracle Migrations with SharePlex •
Downtime is Eliminated –
– – –
•
Risk is Eliminated – Safer Migration Path – – – – –
•
Migrate platforms (hardware, storage, database, applications) without unnecessary downtime • To date, never saving less than 90% • Averaging g g 94% Database upgrade process is eliminated File transfer time is eliminated For cross platform migration as export/import is offloaded from production
Zero Data Loss (fail-back configuration) Migration Failures are Downtime-Free (users stay online) Migrate during business hours with full support Repeatability on production Test and verify target over weeks, if required
Total Cost is Reduced – – –
Downtime saved Out of hours working Not migrating
18
SharePlex - Business Continuity for Oracle •
Reduce planned downtime for – – –
OS upgrade/migrations Oracle upgrades Application Patching Source
•
Database Support – – –
•
Target
Oracle 8i, 9i,10g & 11g Both RAC and non-RAC Standard Edition Enterprise Edition
Platform Support – – – – – –
Sun Solaris (SPARC & x86) HP-UX (PA-RISC & Itanium) Compaq p q Tru64 IBM AIX Windows 2000/2003/2008. Linux RHEL, SuSE, OEL (x86 & Itanium)
19
Live Oracle Migrations And Data Availability
20
SharePlex Live Migration
21
21
22 Live Migration
22
Hot backup/BCV
23 Live Migration
23
24 Live Migration
24
SharePlex Cross Platform Live Migration
25
25
26 Live Migration
26
Hot backup/BCV
27 Live Migration
27
Hot backup/BCV
Export/Import or DaraPump or XTTS
28 Live Migration
28
Hot backup/BCV
Export/Import or DaraPump or XTTS
29 Live Migration
29
30 Live Migration
30
SharePlex – For Oracle Replication Needs 9 Real-time Decision Support Systems – – – –
Off load to low cost hardware and oracle licensing g Data subsets Protect Sensitive Data Archiving
9 High Availability Systems – Application and Database online during patching, system maintenance and upgrades d
9 Disaster Recovery Sites – Local or Remote disaster recovery sites
9 Packaged ERP Solutions – SAP, Oracle E-Business, Siebel, Peoplesoft 31
Summary of SharePlex Benefits 1. High Performance 9 Low Latency 9 Low Overhead server & network 9 High Hi h V Volumes l 2. Data Accuracy 9 Data Integrity checked when changes are applied 9 Instantiation supports Open Transactions 9 Sync and Compare supports Open Transactions 9 Patented Technology guarantees i t ti ti using instantiation i online li b backups k 3. Oracle Feature Support 9 Longs, LOBS, UDTs, IOT, XML 9 RAC, RAC ASM ASM, O/ACFS 9 Tables, Sequences 9 Schema DDL 9 Supports All Editions of Oracle 9 Oracle 8 to 11g R2 supported
4. Automated and self-configuring based on an object list makes SharePlex easy to implement 5 Proven Fault Tolerant and Recoverability 5. 9 Oracle Instance Failure 9 Server and Network Failure 9 Replication Failure 9 User Error 6. All in one Solution 9 Compare/repair, Sync utilities included g GUI included 9 SharePlex Manager 9 World Class Support 24x7x365 included 7. Flexible configuration for same price 9 HA/DR 9 Migrations (term licenses available) 9 Table, column or row level replication 9 Reporting and Transformations
32
Take the pains out of upgrading to Oracle11g • Benchmark Factory
• TOAD DBA Suite • Foglight Performance Analysis • Space S Manager M with ith LiveReorg
• Foglight for Oracle • Foglight Performance Analysis • Spotlight on Oracle
Manage /T /Tune
Load Test
Monitor
Migrate • SharePlex for Oracle
33
Wrap up & For More Information Wrap-up For More Information, visit our webpage at: http://www.quest.com/shareplex-for-oracle/ Download the white paper: “Using Data Replication to Upgrade to Oracle 11g” Webcast Replay available at: http://www.quest.com/events/ListDetails.aspx?ContentID=11310 T contact To t t the th presenter: t
[email protected] N l Sid b th @ t
Coming this summer…new SharePlex release v7.5!!!
Q&A
34
