Configure OGG to maintain a standby database
1. Overview of a live standby configurationIn thisconfiguration, there is an inactive Oracle GoldenGate Extract groupand an inactive data pump on the live standby system. Both of those...
Tips on GoldenGate
1. Oracle补全日志默认情况下redo日志中只记录rowid以及被修改的字段的信息。当GoldenGate还原该事务,是SQL层面根据唯一键值来定位记录,故需要将主键或其他字段信息附近到日志中。最小附加日志,是开启logmnr...
Monitoring GoldenGate Processing
Overview monitoring toolsGGSCI information commands The ggserr.log file (error log)Process reportThe discard filesThe logs at operating-system levelUsing the information commands ...
GoldenGate Architecture
Architecture1.Manager The GoldenGate Managerprocess is used to manage all of the GoldenGateprocesses and resources. A single Manager process runs on each server wher...
GoldenGate安装、配置
Preinstall:1. Alter source database in archive mode( alter the target either if perform. a bidirectional replication ).2. Add supplemental log to the source database.da...