一、 Oracle GoldenGate技术原理
Oracle GoldenGate软件是一种基于log(日志)的结构化数据复制软件,它通过解析源数据库在线log或归档log获得数据的增、删、改变化,再将这些变化应用到目标数据库,实现源数据库与目标数据库同步、双活。Oracle GoldenGate 软件可以在异构的IT基础结构(包括几乎所有常用操作系统平台和数据库平台)之间实现大量数据亚秒级的实时复制,其复制过程简图如下:
操作系统
|
数据库
|
|
Windows 2000, 2003, XP
Sun Solaris
HP-UX
IBM AIX
Linux
HP TRU64
HP OpenVMS
HP NonStop
IBM z/OS
|
Capture(捕获)
|
Delivery(投递):
|
Oracle
IBM DB2
MS SQL Server
Sybase ASE
Teradata
Enscribe
SQL/MP
SQL/MX
|
Oracle
IBM DB2
MS SQL Server
Sybase ASE
MySQL
Teradata
Enscribe
SQL/MP
SQL/MX
Ingres
HP Neoview
任何ODBC兼容数据库
|
银行业
|
|
ABN India
ANZ Australia ANZ New Zealand Allied Irish Banks Andrhaa Bank Banca Sella Banco de Credito e Inversion (BCI) Banco Internacional, S.A. – BITAL Banco Nacional de Mexico Bank Gospodarki Zywnosciowej Bank Mandiri Bank of America(美国银行) Bank of Ayudhya Bank Central Asia Bank of Executives Bank of Indonesia Bank Mandiri Bank Negara Indonesia Bank One Bankart BiK Borica China Trust Commercial Bank Comerica Commercial Bank of Greece Consorzio Triveneto Spa Emirates Bank International Eurobank Fleet Financial Services FSPA Foereningssparbanken Global Trust Bank Government Savings Bank HDFC Bank |
HSBC(汇丰银行)
Hsinchu Bank Huntington Services Corp. ICICI BANK Industry Construction Bank Knet Korean Exchange Bank Muzo National Australia Group National Bank Of Greece OTP Bank PKO Bank Polski Postbank Punjab National Bank Rabobank Shanghai Commercial and Savings Bank Siam City Bank State Bank of India State Bank of Mauritius Taitung Business Bank Toronto Dominion Bank Transbank S.A. Twinsoft for Deutsche Bahn Ulster Bank U.S. Bank (US Bancorp) Unibanco Union Bank of India UTI Bank Wachovia Washington Mutual Bank Wells Fargo World Savings … |
金融保险业
|
|
ABN Amro
Affinitas (Consortia) Alliance and Leicester Arta Jasa Assurant Inc. ATH Costa Rica Austrian Payment Systems Bankserv Benefit Bolsa de Valores de Columbia Bombay Stock Exchange Bursatec (Mexican Stock Exchange) Capital Securities Cardsystems Solutions CIBC Concord EFS – Datawise Everlink Payment Systems Federated Investors Fidelity Information Services First Data Resources Australia Pte Ltd Hanvit Securities First Tennessee Girobankard Hyundai Securities ITS Inc. JCB International Co. Jih Sun Securities KeyCorp Kookmin Credit LG Card (LGC) Lotte Card |
Link Interchange Network
Market Axess Corporation MasterLink Futures Corporation MasterLink Securities Merrill Lynch National Credit Card Centre National Processing Company NYCE Corporation PayPoint Paymentech Polaris Securities Polcard PreHoldings (ITC Financial) Promisant Pulse EFT Raymond James Associates Regionsykehuset i Tromsoe Samsung Card Samsung Securities Samsung Winners Card Speedway Superamerica Stored Value Systems T-Chek Systems Total Systems Transacty Travelers Express UBS VISA Western Union Woori Securities |
卫生服务业
|
|
Antelope Valley Hospital
Baptist Health Bronx Lebanon Continuum Health Partners EHIT Fresno Community Hospital Group Health Health Alliance of Cincinnati Huntsville Hospital INOVA Health Systems Iowa Health System Kettering Medical Center Legacy Health System Mayo Clinic Foundation Montefiore Medical Center Nebraska Health Systems |
North Carolina Baptist Health
Oakwood Healthcare Systems OSF Healthcare Park Nicollet Health Services Parkview Health Systems Peace Health Schering-Plough Sharp Healthcare Sisters of Charity of Leavenworth St. Francis Hospital St. Joseph’s Hospital Thomas Jefferson University Hospital University of Chicago Hospitals University of California – San Francisco … |
电信业
|
|
海南移动
Adelphia Communications Corp. BCE/Emergis BellSouth Cable One Cablevision Systems Corp. Comcast Communications Inc. Continental Datagraphics Dell USA DirecTV Genpass Technologies Getronics |
Matav
NuWave Technologies, Inc. Postini Procomp Singapore Computer Systems SIS/ADP Sprint Syscom Texas Electronic Information Comp. Toyo Information Systems West Corp … |
电子商务,零售,交通等
|
|
中华人民共和国海关总署
Boston Consulting Group CIMA Copperweld Duke Energy Genuine Auto Parts Company Gillette Hertz Hyundai Motor America Japan Airlines International Korea Ministry of Information and Communication Mirage Resorts MGM Grand Office of Military Manpower Admin. |
Orbitz
Overstock.com Party City Publix Super Markets Ross Sabre Holdings Safeway Sandia National Labs – U.S. DoE Shell Oil Southwest.com U.S. Air Force U.S. Department of Defense US Foodservice Valero Energy Corporation Water Corporation of Western Australia … |