Oracle Database 10g IBM DB2 UDB v8.2 : 2005 9
Oracle Database 10g IBM DB2 UDB v8.2 :... 3... 3... 4 : Oracle... 4... 5... 6 HA : Oracle DB2... 6 ORACLE DB2... 10... 10 Fast Start Fault Recovery... 10... 12... 15... 16... 19 ASM... 20... 20... 21 Oracle Data Guard... 21 DB2 HADR... 21 DB2... 21 v8.2 HADR v8.1... 22 Data Guard:... 22... 31... 31... 32 Point-in-Time... 32 ORACLE DB2... 35... 35... 35... 36... 36... 37... 37... 37... 38... 40... 41... 43... 44 Oracle Database 10g IBM DB2 UDB v8.2 : 2 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Database 10g IBM DB2 UDB v8.2 : Oracle Oracle Database 10g HA IBM DB2 Universal Database DB2 UDB HA Oracle Oracle Merrill Lynch Citigroup Southwest Airlines British Telecom General Motors Best Buy Lufthansa Priceline ebay Amazon.com 1 2 Oracle Database 10g Release 2 IBM DB2 Universal Database DB2 UDB 8.2 HA 2 IT HA Oracle Database 10g IBM DB2 UDB v8.2 : 3 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
IT 1 2 IT IT IT HA HA HA IBM Oracle HA : Oracle Oracle Database 10g 1 HA [1] [2] Oracle Database 10g IBM DB2 UDB v8.2 : 4 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Database 10g HA 1: Oracle Database 10g Oracle Oracle Real Application Clusters RAC Oracle Oracle Automatic Storage Management ASM ASM Oracle Oracle Recovery Manager RMAN RMAN Oracle Oracle Database 10g Oracle RMAN Oracle Database 10g Oracle Oracle Hardware Assisted Resilient Data HARD Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 5 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Data Guard Data Guard Data Guard 1 Data Guard Oracle Oracle Data Guard SQL Apply Oracle Database 10g Release 1 Oracle SMP RAC HA : Oracle DB2 IBM DB2 8.2 Oracle Oracle Database IBM DB2 UDB 1 DB2 8.2 IBM DB2 Oracle 1 IBM DB2 UDB 3 DB2 UDB Unix/Windows Oracle Database 10g IBM DB2 UDB v8.2 : 6 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Oracle Database 10g Release 2 Enterprise Edition DB2 IBM DB2 Universal Database Enterprise Server Edition DB2 ESE 8.2 Oracle DB2 1: Oracle DB2 Oracle DB2 2 Oracle DB2 LOB Oracle Database 10g IBM DB2 UDB v8.2 : 7 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
/ ILM Oracle DB2 / / / RAW CLOB/BLOB Oracle DB2 SQL (recycle bin) Oracle Database 10g IBM DB2 UDB v8.2 : 8 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
SQL Point-in-Time Point-in-Time Point-in-Time Oracle DB2 Oracle DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 9 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
ORACLE DB2 Oracle DB2 2: Oracle DB2 Oracle DB2 2 Fast mid-tier connection failover Fast Start Fault Recovery Oracle Fast-Start Fault Recovery 2 Fast Start Checkpointing Fast Start Rollback Oracle MTTR Oracle FAST_START_MTTR_TARGET MTTR Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 10 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
[3] DB2 DB2 static SOFTMAX DBA Oracle v$instance_recovery MTTR Oracle Enterprise Manager GUI DB2 SOFTMAX Oracle v$mttr_target_advice I/O DB2 Fast-Start Fault Recovery Oracle DB2 Oracle Oracle Oracle DB2 Oracle 1 DB2 DB2 DB2 [4] Oracle Database 10g IBM DB2 UDB v8.2 : 11 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle DB2 Oracle Real Application Clusters RACDB2 Database Partitioning Feature DPF DPF DB2 Universal Database Enterprise Server Edition DB2 DB2 1 Oracle9i Real Application Clusters Oracle John Kerin RAC DB2/DPF RAC DB2 DB2 Oracle Real Application Clusters DB2/DPF RAC DB2/DPF DB2/DPF IBM DB2 v8.2 High Availability Disaster Recovery HADR DB2 RAC IBM Redbook HADR [5] DB2 DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 12 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
RAC DB2/DPF DB2/DPF 4 3 12 [6] n n n-1 1 HACMP MSCS REDO DB2 Redistribute Database Partition 1 DB2 Redistribute Database Partition 15 [7] DB2/DPF WHERE CustomerNumber CustomerName 12 12 12 CPU 12 I/O DB2/DPF 1 SQL DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 13 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
[8] [9] SQL 2 DB2 CustomerNumber 2: DB2 Oracle Database Real Application Clusters Oracle Southwest Airlines Operations for Interactive Marketing Senior Manager Kerry Schwab IBM DB2/DPF 4 4 IBM ab c [8] [9] DB2/DPF 4 12 DB2/DPF 12 Oracle Database 10g IBM DB2 UDB v8.2 : 14 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
RAC Oracle Oracle Database 10g RAC RAC DB2 Oracle Database 10g RAC RAC DB2 RAC Oracle Database 10g DB2 BM HACMP RAC DB2 RAC Fast Application Notification JDBC OCI ODP.NET TCP/IP 1 Fast Application Notification DB2 Oracle DB2 Oracle Database 10g Release 2 Oracle Clusterware Cluster Verification Utility [10] Oracle Database 10g IBM DB2 UDB v8.2 : 15 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle DB2 3: Oracle DB2 Oracle DB2 LOB / Information Lifecycle Management ILM 90% RMAN $500,000 CSX Technology IT Charles Pack Oracle DB2 Oracle DB2 Oracle Recovery Manager RMAN RMAN DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 16 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
ATA Oracle Database 10g Release 1 RMAN Automatic Storage Management ASM Oracle DB2 Oracle Enterprise Manager 24 Point-in-Time DB2 RMAN SCN DB2 RMAN DB2 IBM [11] DBA RMAN RMAN DB2 RMAN RMAN RMAN RMAN RESTORE RECOVER DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 17 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
RMAN DB2 RMAN I/O Oracle LogMiner DB2 Oracle DB2 Oracle DB2 I/O I/O VLDB Oracle VLDB Oracle RMAN Oracle DB2 1 Oracle 1 DB2 Oracle RMAN Oracle DB2 DB2 [12] LOB Oracle Database 10g IBM DB2 UDB v8.2 : 18 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle LOB DB2 [11] Oracle DB2 Oracle Oracle DB2 IBM DB2 DB2 Oracle Information Lifecycle Management ILM 3 ATA Oracle Information Lifecycle Management ILM [13] DB2 Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 19 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
3 DB2 DB2 DB2 UNION ALL [14] Oracle DB2 ASM Oracle Database 10g Automatic Storage Management ASM Oracle Oracle Database 10g Automatic Storage Management ASM Oracle ASM ASM ASM ASM ASM DB2 Oracle Hardware Assisted Resilient Data (H.A.R.D.) [16] Oracle Oracle HARD Oracle Database 10g IBM DB2 UDB v8.2 : 20 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Hardware Assisted Resilient Data (H.A.R.D.) Oracle Oracle Oracle HARD DB2 Data Guard 1 Oracle Data Guard Oracle Data Guard [17]Oracle Oracle Database Enterprise Edition 1 Data Guard DB2 HADR DB2 8.2 HADR [18]HADR IBM Informix Dynamic Server High Availability Data Replication HDR [19] Oracle Data Guard DB2 8.1 DB2 [20] db2uxt2 userexit Yes [21] DB2 5 / FTP Oracle Database 10g IBM DB2 UDB v8.2 : 21 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
db2 db2 rollforward db <dbname> to end of logs rollforward db DB2 IBM 8.2 HADR v8.2 HADR v8.1 DB2 8.1 8.2 HARD IBM Infomix START HADR STOP HADR rollforward database HARD IBM start hadr on db <dbname> as standby HARD HADR_SYNCMODE SYNC NEARSYNC ASYNC Data Guard HADR TAKEOVER HADR HADR Data Guard Oracle Data Guard: HADR Data Guard Oracle HADR Data Guard Oracle Database 10g IBM DB2 UDB v8.2 : 22 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
4: Oracle DB2 Oracle DB2 / / / RAW CLOB/BLOB Oracle Data Guard First American Real Estate Solutions Technical Director Ann Collins Data Guard HADR SQL Apply Oracle Data Guard Redo Apply SQL Apply 2 2 Data Guard Data Guard REDO 2 2 Oracle Database 10g IBM DB2 UDB v8.2 : 23 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
SQL*Plus DGMGRL Enterprise Manager Grid Control HARD SQL Apply Data Guard SQL Oracle Database 10g Release 1 Real Time Apply HADR / HADR Data Guard DR HADR HADR TAKEOVER BY FORCE Oracle Database 10g Release 2 Data Guard Data Guard DB2 24 HADR Redo Apply Data Guard REDO Redo Apply Redo Apply Oracle Database 10g IBM DB2 UDB v8.2 : 24 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
HARD HADR SQL Apply Redo Apply DR HADR HADR HADR / HADR / Oracle Database 10g Release 2 Flashback Across Resetlogs 1 Data Guard / DB2 HADR HADR Data Guard RMAN REDO HADR DB2 HADR HADR /UNDO 1 Data Guard HADR Data Guard 1 REDO Apply Redo Apply SQL Apply / Oracle Database 10g IBM DB2 UDB v8.2 : 25 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
2 1 4 1 12 HADR DB2 Oracle Database 10g Real-Time Apply Data Guard 1 Flashback Database HADR HADR DB2 RAC Data Guard Oracle HADR HADR DB2 Database Partitioning Feature DPF[18] IBM HA HADR HA Data Guard Oracle RAC RAC REDO RAC Data Guard Oracle HADR HADR HADR_SYNCMODE SYNC NEARSYNC ASYNC ASYNC DB2 [18] [23] HADR HADR HADR_SYNCMODE ASYNC Oracle Database 10g IBM DB2 UDB v8.2 : 26 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Data Guard LAN WAN DB2_HADR_BUF_SIZE Oracle Database 10g Data Guard HADR Data Guard LAN WAN Data Guard LAN WAN DR HADR HADR / HADR HADR Data Guard Oracle Data Guard / Sun Microsystems Sun Services Global Engineering Database Services Staff Engineer Darl Kuhn IBM [24] HADR HADR 1 Data Guard ARCH REDO Oracle Database 10g Release 2 HADR Remote Catchup Pending Remote Catchup logarchmeth1 logarchmeth2 Remote Catchup Oracle Database 10g IBM DB2 UDB v8.2 : 27 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Data Guard LGWRARCH REDO Data Guard HADR HADR HADR Remote Catchup Pending [18] Data Guard Redo Apply SQL Apply HADR HADR Data Guard HADR HADR Data Guard HADR Oracle HADR Data Guard OS Solaris 8 Solaris 9 Data Guard HADR HADR [18] HADR_TIMEOUT HADR_SYNCMODE Oracle Database 10g IBM DB2 UDB v8.2 : 28 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
HADR Data Guard HADR HADR TAKEOVER HADR BY FORCE [18]SYNC SYNC START HADR AS STANDBY HADR DB2 HADR [18] TB HADR HADR WAN Data Guard Oracle Flashback Database Data Guard Oracle Database 10g Release 1 Oracle Database 10g Release 2 DB2 Fast-Start Failover DB2 HADR Data Guard Data Guard HADR db2 update alternate server... Oracle Database 10g IBM DB2 UDB v8.2 : 29 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Data Guard Oracle TAF[25] Oracle HADR HADR HADR Data Guard Redo Apply SQL Apply Oracle PL/SQL HADR / HADR [26] Oracle Database 10g Data Guard Oracle Advanced Security Option ASO REDO HADR RAW HADR RAW / Data Guard HADR HADR REDO 2 CPU Data Guard HADR BLOB CLOB IBM [27] 1GB BLOB CLOB Data Guard Oracle Database 10g IBM DB2 UDB v8.2 : 30 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
BankNorth Group VP of Data Administration Greg Penk Oracle B2 [28] Oracle Oracle DB2 5: Oracle DB2 Oracle DB2 SQL (recycle bin) SQL Point-in-Time Point-in-Time Point-in-Time DB2 Oracle Oracle Oacle Oracle DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 31 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Flashback Drop (recycle bin) BIN$$ (recycle bin)db2 (recycle bin) DB2 [29] Oracle Oracle Flashback Versions Query 2 ID Flashback Transaction Query UNDO UNDO UNDO DB2 LogMiner DBA Flashback Versions Query SQL DDL LogMiner SQL GUI DB2 Point-in-Time Point-in-Time Oracle Oracle Point-in-Time Oracle Database 10g IBM DB2 UDB v8.2 : 32 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
undo DB2 Oracle Point-in-Time DB2 DDL Point-in-Time DB2 Point-in-Time [29] [30]DB2 / Oracle Flashback Table SQL Point-in-Time FLASHBACK TABLE <table> TO TIMESTAMP <timestamp> UNDO DB2 Point-in-Time Oracle Flashback Database Point-in-Time REDO Point-in-Time DB2 Flashback Database RMAN QA Flashback Database ReserveAmerica Joshua Ort Oracle DB2 Point-in-Time Point-in-Time Point-in-Time 10 GB 1 10 TB 10 2 6 Oracle Database 10g IBM DB2 UDB v8.2 : 33 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
3: Flashback Database Point-In-Time RTO Oracle DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 34 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
ORACLE DB2 CPU DB2 Oracle 6: Oracle DB2 Oracle DB2 DBA Oracle PartitioningOption DB2 PartitioningOption DB2 DBA 3 Oracle Database 10g IBM DB2 UDB v8.2 : 35 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Amazon 14 HP 32CPU 2 HP 5 Amazon.com Director of DB Services Matt Swan 1 RAC RAC ASM Oracle ASM I/O DB2 Oracle IBM DB2 8.1 Oacle Oracle DBA DB2 DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 36 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
HA Oracle DB2 8.2 Database Manager Configuration Database Configuration [31] HA DBA Oracle DB2 7: Oracle DB2 Oracle DB2 DB2 Oracle DB2 2 DB2 Adding a Cluster Node Oracle Database 10g IBM DB2 UDB v8.2 : 37 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
DB2 Oracle Oracle DB2 Oracle DB2 Oracle DB2 IBM Innocent Bystander DB2 1 DB2 IBM DB2 v8.1 DB2 v8.2 Automating Database Maintenance DB2 v8.2 Automatic Database Maintenance 3 1 2 DB2 REORG INDEXES [32] REORG TABLE [32] Oracle Oracle DML DB2 v8.1 DB2 v8.2 Oracle DBA Amazon.com Director of DB Services Matt Swan Oracle Oracle9i DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 38 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
2 Oracle8i DB2 DB2 Control Center Indexes Control Center Tables Reorganize Indexes REORG INDEXES ALL FOR TABLE Oracle Oracle / IOT IOT IOT IOT Amazon Amazon.com Director of DB Services Matt Swan Oracle Database 10g Release 2 CHECK NOT NULL Oracle Database 10g IBM DB2 UDB v8.2 : 39 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
DB2 DB2 Oracle Oracel DB2 Oracle DB2 Oracle Oracle Oracle DB2 Oracle Oracle Maximum Availability Architecture MAA [33]Oracle Maximum Availability Architecture MAA Oracle MAA Oracle Oracle Oracle Maximum Availability Architecture Oracle MAA MAA MTTR Oracle High Availability Systems Engineering Group MAA Oracle Oracle9i Oracle Database 10g MAA Web [33] Oracle Database 10g IBM DB2 UDB v8.2 : 40 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
MAA MAA Oracle Enterprise Manager Oracle Application Server Oracle E-Business Suite Oracle Collaboration Suite Oracle Oracle HA IBM DB2 HA Oracle Oracle Oracle Database [34]Oracle [35] [36] Maximum Availability Architecture Ohio Savings Bank Oracle Global IT Oracle Database 10g Maximum Availability Architecture WAN Oracle E-Business Suite Data Guard RAC BACS LTD BT Group Chicago Stock Exchange Genentech BACS LTD Oracle9i BT Group Oracle9i 20 1 Chicago Stock Exchange Oracle HP 100% Genentech Oracle9i Real Application Clusters 2 Oracle Database 10g IBM DB2 UDB v8.2 : 41 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Southwest Airlines Talk America Southwest Airlines Oracle Database 10g RAC ASM 10 Data Guard ADT Security Services Amadeus Fannie Mae First American Real Estate Solutions Swedish Post VP Bank Data Guard SQL Apply Data Guard Data Guard POC: Oracle Database 10g 1 835 Oracle9i Data Guard Oracle Database 10g Data Guard Data Guard SQL Apply DR Data Guard SQL Apply RMAN ChevronTexaco CSX Fannie Mae Starwood Hotels Trilegiant Purdue Pharma L.P Colgate-Palmolive RMAN DUPLICATE DBA RMAN 16TB 1TB/ Oracle Database 10g RMAN RMAN 8TB RMAN RMAN Banknorth Group, Inc ReserveAmerica Oracle 10g Oracle Database 10g IBM DB2 UDB v8.2 : 42 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Oracle Oracle Oracle Oracle RAC Data Guard RMAN DB2 Oracle Oracle RAC Data Guard RMAN Oracle Maximum Availability Architecture Oracle Oracle Oracle DB2 DB2 Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 43 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
1. Oracle http://otn.oracle.co.jp/document/products/oracle10g/index.html 2. Oracle http://otn.oracle.co.jp/products/database/oracle10g/index.html 3. Oracle9i http://otndnld.oracle.co.jp/products/database/oracle10g/htdocs/maa/maa.htm 4. High Availability and Crash Recovery in Oracle9i Database http://www.oracle.com/technology/deploy/availability/pdf/db2_hacrash_response. pdf 5. IBM Redbook DB2 UDB V8.2 on the Windows Environment http://www.redbooks.ibm.com 6. DB2 Universal Database for Windows High Availability Support Using Microsoft Cluster Server Overview (TR-74.176) http://www-900.ibm.com/cn/software/db2/products/download/whitepaper/db2mscs.p df 7. IBM DB2 Universal Database Administration Guide: Performance, Version 8.2, Chapter 11: Redistributing Data Across Database Partitions 8. IBM DB2 Universal Database Administration Guide: Planning, Version 8.2, Chapter 5: Physical Database Design 9. IBM DB2 Universal Database Application Development Guide: Programming Client Applications, Version 8.2, Chapter 31: Programming Considerations for Partitioned Database Environments 10. Oracle 10g Real Application Cluste IBM DB2 UDB v8.2 http://otn.oracle.co.jp/products/database/oracle10g/index.html 11. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 1: Developing a Good Backup and Recovery Strategy 12. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 2: Database Backup 13. Overview: Oracle Information Lifecycle Management http://www.oracle.com/technology/deploy/availability/htdocs/ilm_overview.html 14. Partitioning in DB2 Using the UNION ALL View http://www-106.ibm.com/developerworks/db2/library/techarticle/0202zuzarte/0202z uzarte.pdf 15. Overview: Automatic Storage Management http://www.oracle.com/technology/products/database/asm/index.html 16. Overview: Oracle Hardware Assisted Resilient Data (HARD) Initiative http://www.oracle.com/technology/deploy/availability/htdocs/hard.html 17. Oracle Data Guard Oracle Database 10g IBM DB2 UDB v8.2 : 44 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
http://otndnld.oracle.co.jp/products/database/oracle10g/htdocs/availability/dataguar doverview.html 18. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 7: High Availability Disaster Recovery (HADR) 19. A look at the new functions in DB2 Universal Database V8.2 http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0404zikopoulos /index.html 20. The Basics of DB2 Log Shipping http://www-106.ibm.com/developerworks/db2/library/techarticle/0304mcinnis/0304 mcinnis.html 21. Setting Up a User Exit on DB2 UDB V8 to Archive Database Logs http://www-106.ibm.com/developerworks/db2/library/techarticle/0307kline/0307klin e.html 22. An Overview of Transactional Logging in DB2 Universal Database http://www-106.ibm.com/developerworks/db2/library/techarticle/0301kline/0301klin e.html 23. IBM DB2 Universal Database Administration Guide: Performance, Version 8.2, Appendix A: DB2 Registry and Environment Variables 24. Technical Comparison of DB2 HADR and Oracle Data Guard http://www-306.ibm.com/software/data/db2/udb/hadr.html 25. Oracle MetaLink Note 205637.1: Data Guard 9i Configuring Transparent Application Failover in a Data Guard Environment http://metalink.oracle.com/ 26. IBM DB2 Universal Database Introduction to Replication and Event Publishing 8.2 7 : Comparison of Q replication to high availability disaster recovery (HADR) 27. IBM DB2 Technote 21205366 HADR and LOB replication, http://www-1.ibm.com/support/docview.wss?uid=swg21205366 28. http://otndnld.oracle.co.jp/products/database/oracle10g/htdocs/d-80/flashback_over view.htm 29. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 4: Roll Forward Recovery 30. IBM DB2 Technote 21006525 What is the purpose of the minimum recovery time for a tablespace? http://www-1.ibm.com/support/docview.wss?uid=swg21006525 31. IBM DB2 Universal Database Administration Guide: Performance, Version 8.2, Chapter 13: Configuring DB2 32. IBM DB2 Universal Database Command Reference, Version 8.2 Oracle Database 10g IBM DB2 UDB v8.2 : 45 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
33. Maximum Availability Architecture MAA http://otndnld.oracle.co.jp/products/database/oracle10g/htdocs/maa/maa.htm 34. Oracle Customers http://www.oracle.com/customers/index.html 35. Oracle High Availability Case Studies http://www.oracle.com/technology/deploy/availability/htdocs/ha_casestudies.html 36. Real Application Clusters http://www.oracle.com/customers/products/rac.html Oracle Database 10g IBM DB2 UDB v8.2 : 46 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability
Oracle Database 10g IBM DB2 UDB v8.2 : 2005 9 : Ashish Ray : Donna Cooksey Joseph Meeks Larry Carpenter Lilian Hobbs Paul Tsien Tammy Bednar Timothy Chien Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Copyright 2005, Oracle. Oracle Oracle Corporation