1、 Introduction to Disaster Recovery Migration and Synchronous Replication of GoldenGate Database (35 OGG project cases)
GoldenGate/OGG Introduction:
GoldenGate/OGG is a log based structured data replication integration platform. It obtains data changes by analyzing the online log or archive log of the source database. It can achieve real-time capture, transformation and delivery of a large number of transaction data, achieve data synchronization between the source database and the target database, and maintain sub second data latency. GoldenGate's sales market covers many countries around the world, and its customers are distributed in government, banking, telecommunications, securities, media, medical and other industries, most of which are among the top 500 enterprises in the world. Golden Gate can realize real-time replication of large amounts of data in sub second level between heterogeneous IT infrastructures (including almost all common operating system platforms and all database platforms).
![1666426028228754.png](https://s2.51cto.com/images/20221022/1666426028228754.png)
GoldenGate can implement the following multiple application scenarios:
Primary/standby disaster recovery for homogeneous/heterogeneous databases
Homogeneous/heterogeneous database data synchronization
Homogeneous/heterogeneous data centralization
Homogeneous/heterogeneous database data distribution
Homogeneous/heterogeneous database upgrade
Homogeneous/heterogeneous database migration
Homogeneous/heterogeneous database read/write separation
Isomorphic/heterogeneous online report
Homogeneous/heterogeneous real-time data warehouse supply
Homogeneous/heterogeneous transaction tracking
Homogeneous/heterogeneous dual business centers
![1666426029547014.png](https://s2.51cto.com/images/20221022/1666426029547014.png)
Course objectives:
After learning 35 projects of GoldenGate/OGG courses of Fengge series, you will gain:
Master the GoldenGate technology, be able to complete the daily maintenance and advanced management of OGG19c/21c, be familiar with disaster recovery migration and real-time synchronous replication of data of homogeneous/heterogeneous databases through OGG, including Oracle MySQL, SQLServer, PostgreSQL, DB2, MongoDB, Kafka, Hadoop HDFS/HBase and other platforms conduct mutual data migration and synchronous replication to achieve data interaction between various businesses of the enterprise. In combination with the enterprise data integration platform or data middle platform, the enterprise can open up internal data islands and become an irreplaceable comprehensive data talent in enterprises and institutions!
****** be careful ******
This series of courses There are 3 sets of courses in total. The courses have a strong connection. It is not recommended to buy them separately
Students who have only purchased the second or third set of courses cannot provide learning software and some materials
Welcome to:
51CTO school style big data/Oracle/MySQL database learning dedicated QQ group: 454129134, 925203979
Some screenshots of this course:
![1666426029740217.jpg](https://s2.51cto.com/images/20221022/1666426029740217.jpg)
![1666426029902689.jpg](https://s2.51cto.com/images/20221022/1666426029902689.jpg)
![1666426028744532.jpg](https://s2.51cto.com/images/20221022/1666426028744532.jpg)
II Fengge GoldenGate database disaster recovery migration and synchronous replication (35 OGG project cases) outline
The first set of Fengge OGG topic: https://edu.51cto.com/course/32466.html
one GoldenGate Advanced Management Training 01 (OGG isomorphism, database migration, data synchronization, disaster recovery replication)
(*) OGG19c disaster recovery migration 01 (Oracle11g to 11g, single fs, classic ogg initialization)
(*) OGG19c disaster recovery migration 02 (Oracle11g to 19c, single fs, classic expdp initialization)
(*) OGG19c disaster recovery migration 03 (Oracle19c to 19c, RACto stand-alone, classic expdp initialization)
(*) OGG19c disaster recovery migration 04 (Oracle19c to 19c, ASM to ASM, classic Rman initialization)
(*) OGG19c disaster recovery migration 05 (Oracle19c to 19c, single fs, integrated expdp initialization)
(*) OGG19c disaster recovery migration 06 (Oracle19c to 19c, win to linux asm, integrated cross platform)
(*) OGG21c disaster recovery migration 07 (Oracle19c to 19c, CDB/PDB, microservice graphics expdp)
(*) OGG21c disaster recovery migration 08 (Oracle19c to 19c, single fs, microservice command RMAN)
(*) OGG19c disaster recovery migration 09 (GoldenGate Veridata data comparison and automatic repair)
(*) Daily maintenance and senior management of GoldenGate
(* * *) Daily management order of OGG daily maintenance
(* * *) OGG daily maintenance database start and stop process
(* * *) Operation and test of basic functions of OGG daily maintenance
(* * *) Classic and integrated mode conversion of OGG daily maintenance
(* * *) Monitoring script writing and application of OGG daily maintenance
(* * *) Steps of OGG routine maintenance modification table (small table)
(* * *) Steps of OGG routine maintenance modification table (large table)
(* * *) Restarting of OGG routine maintenance table
(* * *) OGG Daily Maintenance Table Data Filtering and Distribution 1
(* * *) OGG daily maintenance table data filtering and distribution 2
(* * *) Table data conversion and mapping of OGG daily maintenance
(* * *) Add columns to the target end table of OGG routine maintenance
(* * *) How to handle the OGG routine maintenance table without primary key
(* * *) Log analysis tool logdump for OGG daily maintenance
(* * *) Consolidation and split of extraction process of OGG daily maintenance
(* * *) Use of Chinese table names for OGG daily maintenance
(* * *) The archive backup of OGG routine maintenance is deleted
(* * *) Disaster recovery environment switching steps for OGG daily maintenance
The second set of Fengge OGG topic: https://edu.51cto.com/course/32465.html
2. GoldenGate Advanced Management Training 02 (OGG isomorphism, database migration, data synchronization, disaster recovery replication)
(*) OGG19c migration synchronization 10 (Oracle11g to MySQL 5.7)
(*) OGG21c migration synchronization 11 (Oracle19c to MySQL 8.0)
(*) OGG21c migration synchronization 12 (Oracle19c to SQLServer)
(*) OGG21c migration synchronization 13 (Oracle19c to PostgreSQL)
(*) OGG21c migration synchronization 14 (Oracle19c to MongoDB)
(*) OGG21c migration synchronization 15 (SQLServer to SQLServer)
(*) OGG21c migration synchronization 16 (SQLServer to Oracle)
(*) OGG21c migration synchronization 17 (SQLServer to MySQL)
(*) OGG21c migration synchronization 18 (SQLServer to PostgreSQL)
(*) 0.OGG21c Migration Synchronization 19 (SQLServer to MongoDB)
(*) OGG21c migration synchronization 20 (SQLServer to Kafka)
(*) OGG21c migration synchronization 21 (DB2 to Oracle)
The third set of Fengge OGG topic: https://edu.51cto.com/course/32464.html
3. GoldenGate Advanced Management Training 03 (OGG isomorphism, database migration, data synchronization, disaster recovery replication)
(*) OGG21c migration synchronization 22 (PostgreSQL to Oracle)
(*) OGG21c migration synchronization 23 (PostgreSQL to MySQL)
(*) OGG21c migration synchronization 24 (PostgreSQL to SQLServer)
(*) OGG21c migration synchronization 25 (PostgreSQL to MongoDB)
(*) OGG21c migration synchronization 26 (PostgreSQL to Kafka)
(*) OGG21c migration synchronization 27 (MySQL 5.7 to Oracle19c)
(*) OGG21c migration synchronization 28 (MySQL 8.0 to MySQL 8.0)
(*) OGG21c migration synchronization 29 (MySQL 8.0 to SQLServer)
(*) OGG21c migration synchronization 30 (MySQL 8.0 to PostgreSQL)
(*) 0.OGG21c migration synchronization 31 (MySQL to MongoDB)
(*) OGG21c migration synchronization 32 (MySQL 5.7 to Kafka)
(*) OGG21c migration synchronization 33 (Oracle19c to Kafka)
(*) OGG21c migration synchronization 34 (Oracle19c to Hadoop HDFS)
(*) OGG21c migration synchronization 35 (Oracle19c to Hadoop HBase)
3、 Prepare the actual combat environment of Fengge database, and refer to the related database installation tutorial:
Oracle11gR2 https://edu.51cto.com/course/3427.html
Oracle 19c: https://edu.51cto.com/topic/3872.html
Oracle ASM https://edu.51cto.com/course/4930.html
MySQL5.7 https://edu.51cto.com/course/12294.html
MySQL8.0 https://edu.51cto.com/course/14566.html
PostgreSQL https://edu.51cto.com/course/22644.html
SQLServer https://edu.51cto.com/course/23927.html
DB2 https://edu.51cto.com/course/23448.html
MongoDB https://edu.51cto.com/course/15167.html
Hadoop/HDFS/HBASE/Kafka big data environment: https://edu.51cto.com/topic/4539.html
4、 Fengge Oracle/MySQL/NoSQL training class series courses (system, case, actual combat)
one ) Oracle Cloud database engineer training course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/131.html
two ) MySQL Database Engineer Training Course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/303.html
three )Dual database (Oracle+MySQL) Sharing of series of training courses one point five (regularly updated)
http://www.fgedu.net.cn/oracle.html
4) Big Data Operation and Maintenance Architects Practical Training Topic 2.0
--------------------------------------------------------------------------------
Address: https://edu.51cto.com/topic/4539.html
Familiar with Hadoop big data ecological technology framework, including Cloudera CDH HDFS、Yarn、Hbase、Hive、
Zookeeper, Kafka, Spark, Flink, Flume, Sqoop, ETL/Kettle, ELK, Azkaban and other groups
Component installation configuration and daily maintenance management. Including the construction and maintenance of OLAP database platforms such as Elastic Search, ClickHouse, GreenPlum, TiDB, etc.