dave-GoldenGate
5墨值下载
Golden Gate
目录
9.1 Oracle Golden Gate 系列一 -- GG 架构说明 ............................................................................................ 8
一. GoldenGate 下载地址 ............................................................................................................................. 8
二. GoldenGate 架构说明 ........................................................................................................................... 10
2.1 Oracle GoldenGate supported processing methods anddatabases .............................................. 10
2.2. Overview of the Oracle GoldenGate architecture ............................................................................ 12
2.2.1 Overview of Extract ................................................................................................................. 13
2.2.2 Overview of datapumps ......................................................................................................... 14
2.2.3 Overview of Replicat ................................................................................................................. 15
2.2.4 Overview of trails ...................................................................................................................... 16
2.2.4.1 Processes that write to, and read, a trail ............................................................................ 16
2.2.4.2 Trail maintenance .................................................................................................................. 16
2.2.4.3 How processes write to a trail .............................................................................................. 17
2.2.4.4 Trail format .............................................................................................................................. 18
2.2.4.5 File versioning ........................................................................................................................ 18
2.2.5 Overview of extract files ........................................................................................................... 19
2.2.6 Overview of checkpoints .......................................................................................................... 19
2.2.7 Overview of Manager ............................................................................................................... 20
2.2.8 Overview of Collector ............................................................................................................... 20
2.3 Overview of processing methods ........................................................................................................ 21
2.4 Overview of groups ............................................................................................................................... 22
2.5 Overview of the Commit Sequence Number (CSN) ......................................................................... 22
9.2 Oracle Golden Gate 系列二 -- GG 的系统需求.................................................................................. 26
一. Memory requirements ........................................................................................................................... 26
二.Disk requirements ................................................................................................................................... 28
三.Storagefor Oracle GoldenGate trails .................................................................................................... 28
四.Temporarydisk requirements ................................................................................................................. 30
五.OracleRAC requirements ....................................................................................................................... 30
六. Network ................................................................................................................................................... 30
七. Operating system privileges ................................................................................................................. 31
八．Itanium requirements ........................................................................................................................... 32
九．Other programs .................................................................................................................................... 32
十. Database configuration ......................................................................................................................... 32
十一. Database client ................................................................................................................................... 33
十二. Database user for Oracle GoldenGateprocesses ......................................................................... 33
十三. Database privileges ........................................................................................................................... 34
1. Regular Oracle database instance ............................................................................................... 34
2. Oracle ASM instance ..................................................................................................................... 35
3. Oracle Enterprise Edition 10.2 or later instance ........................................................................ 36
9.3 Gloden Gate 系列三-GG 支持与不支持的对象类型与操作说明 ....................................................... 37
一．Supported Oracle data types .............................................................................................................. 37
1.1 Numeric data types ...................................................................................................................... 37
1.2 Character data types ................................................................................................................... 37
1.3 Multi-byte character types ........................................................................................................... 37
1.4 Binary data types .......................................................................................................................... 38
1.5 Date and timestamp data types ................................................................................................. 38
1.6 Large object data types ............................................................................................................... 39
1.7 XML data types ............................................................................................................................. 41
1.8 User defined types ....................................................................................................................... 42
1.8.1 General limitationsof support................................................................................................... 42
1.8.2 Limitations forcollection types ................................................................................................. 42
1.8.3 Limitations forobject tables ...................................................................................................... 43
1.8.4 Limitations forspatial types ...................................................................................................... 43
1.9 Other supported data types ........................................................................................................ 43
二. Non-supported Oracle data types ........................................................................................................ 44
三. Supported objects and operations forOracle DML ............................................................................ 44
3.1 Tables, views, and materialized views....................................................................................... 44
3.2 Sequences .................................................................................................................................... 49
四. Non-supported objects and operations for Oracle DML ................................................................... 49
五. Supported objects and operations forOracle DDL ............................................................................ 50
六．Non-supported objects and operations forOracle DDL ................................................................... 50
6.1 Oracle-reserved schemas ........................................................................................................... 50
6.2 Oracle recycle bin ........................................................................................................................ 51
6.3 Other non-supported DDL ........................................................................................................... 51
七. Supported and non-supported object namesand case ..................................................................... 52
7.1 Case sensitivity ............................................................................................................................. 52
7.2 Supported characters .................................................................................................................. 53
7.3 Non-supported characters .......................................................................................................... 54
9.4 Oracle Golden Gate 系列四 -- GG 安装 与 卸载 理论知识 ............................................................ 55
一.GG 安装说明 ........................................................................................................................................... 56
1.1 Downloading Oracle GoldenGate .............................................................................................. 56
1.2 Setting ORACLE_HOME and ORACLE_SID ........................................................................... 56
1.3 Setting library paths for dynamic builds on UNIX .................................................................... 57
1.4 Installing Oracle GoldenGate on Linux and UNIX ................................................................... 60
1.5 Installing support for Oracle sequences .................................................................................... 60
1.6 Configuring Manager and other processes .............................................................................. 62
二.启用 GG 对 DDL 操作的支持 ............................................................................................................... 62
2.1 Overview of the DDL objects ...................................................................................................... 62
2.2 Oracle GoldenGate DDL objects in an Oracle standby configuration ................................... 64
2.3 Installing the DDL objects ........................................................................................................... 64
三.卸载 GG .................................................................................................................................................... 67
9.5 Oracle Golden Gate 系列五 -- GG 使用配置 说明 ............................................................................ 67
一. Preparing the database for Oracle GoldenGate ................................................................................ 68
1.1 Preparing constraints for Oracle GoldenGate .......................................................................... 68
1.1.1 Disabling triggers and cascade constraints ........................................................................... 68
of 329
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论