Oracle GoldenGate配置说明.docxVIP

Oracle GoldenGate配置说明与整理体系结构图创建与编辑参数文件在启动Oracle GoldenGate Manager的任何GGSCI命令行下，输入EDIT PARAMS命令，就可创建与编辑指定的参数。EDIT PARAMS name of parameter file参数文件名定义Trail文件名，只能包含两个字府。GolendGate相应的进程会自动加上6位数字，组成完整的文件名。另外，所有目录最好不要超过8个字符，且不能有中文字府及空格等。Captured data must be processed into a series of files called a trail, where it is stored for processing by the next Oracle GoldenGate process downstream. The basic configuration is:■ a local trail on the source system■ a remote trail on the target system.The name can be a relative or fully qualified path name. The actual trail name can contain only two characters, such as ./dirdat/tr. Oracle GoldenGate appends this name with a six-digit sequence number whenever a new file is created, such as./dirdat/aa000002.决定用哪种捕捉数据变化的方法对于Oralce数据库而言，OGG提供了两种捕捉数据变化的方法，分别称为传统方法与集成方法。传统方法(Classic Method)在传统方法中，OGG从源数据库的redo或archive日志文件中、或者从备份数据库系统的复制的归档日志中捕捉数据变化，生成相应的变化Trail文件。Classic capture supports most Oracle data types fully, with restricted support for the complex data types. Classic capture is the original, fast, and time-proven Oracle GoldenGate capture method that supports a broad array of the most commonly used Oracle data types and features. You can use classic capture for any source Oracle RDBMS that is supported by Oracle GoldenGate.集成方法(integrated capture Method)在集成捕捉方法中，OGG抽取进程直接使用数据库的日志挖掘服务器以LCR（logical change records）的形式来捕捉数据的变化。这种捕捉模式的优势是相对传统的数据变化捕捉方式而言，能支持更多复杂数据类型。In integrated capture mode, the Oracle GoldenGate Extract process interacts directly with a database logmining server to receive data changes in the form of logical change records (LCR). Integrated capture supports more data and storage types as compared to classic capture, and the support is more transparent.The following are some additional benefits of integrated capture:■ Because integrated capture is fully integrated with the database, no additional setup is required to work with Oracle RAC, ASM, and TDE.■ Integrated capture uses the database logmining server to access th