文件名称：GoldenGate Oracle University 培训教材
文件大小：2.41MB
文件格式：PDF
更新时间：2015-08-13 03:33:01
GoldenGate Oracle 培训教材
oracle数据库同步、备份产品： ABOUT GOLDENGATE – COMPANY AND SOLUTIONS———— 5 TECHNOLOGY OVERVIEW————18 ARCHITECTURE ———— 22 CONFIGURING ORACLE GOLDENGATE ———— 28 STEP 1 PREPARE THE ENVIRONMENT————— 29 GOLDENGATE COMMAND INTERFACE————— 46 STEP 2 CHANGE CAPTURE 51 STEP 3 INITIAL LOAD———— 64 STEP 4 CHANGE DELIVERY 71 EXTRACT TRAILS AND FILES 76 GOLDENGATE DATA FORMAT 79 ALTERNATIVE FORMATS ———— 85 VIEWING IN LOGDUMP ———— 92 REVERSING THE TRAIL SEQUENCE ————— 104 PARAMETERS ———— 107 GLOBALS PARAMETERS 109 MANAGER PARAMETERS ———— 110 EXTRACT PARAMETERS———— 113 REPLICAT PARAMETERS ———— 122 DATA MAPPING AND TRANSFORMATION ———— 131 DATA SELECTION AND FILTERING————— 131 COLUMN MAPPING———— 138 FUNCTIONS———— 141 SQLEXEC ———— 149 MACROS———— 158 USER TOKENS———— 163 USER EXITS ———— 170 ORACLE SEQUENCES ———— 177 CONFIGURATION OPTIONS 178 BATCHSQL———— 179 COMPRESSION ———— 182 ENCRYPTION ———— 183 EVENT ACTIONS ———— 187 BIDIRECTIONAL CONSIDERATIONS ————— 192 ORACLE DDL REPLICATION 202 MANAGING ORACLE GOLDENGATE ———— 211 COMMAND LEVEL SECURITY 211 TRAIL MANAGEMENT———— 214 PROCESS STARTUP AND TCP/IP ERRORS ———— 219 REPORTING AND STATISTICS 221 MONITIORING ORACLE GOLDENGATE ———— 229 TROUBLESHOOTING———— 235 TECHNICAL SUPPORT ———— 244