GoldenGate 11g 简要配置步骤
描述:源端和目标端为Oracle 10gR2数据库,将scott数据库导出,在源端与目标端新增test用户,并导入scott的逻辑备份,来实现两个数据库之间test下数据同步。两个数据库的实例均为db01。 -- scott 资源导入导出命令 expdp scott/tiger schemas=scott dumpfile=scott.dmp directory=backup; impdp scott/tiger schemas=scott dumpfile=scott.dmp directory=backup; -- 创建GoldenGate用户并授权(S&T) CREATE USER ogg IDENTIFIED BY ogg DEFAULT TABLESPACE “USERS” TEMPORARY TABLESPACE “TEMP”; GRANT “DBA” TO ogg ; -- 创建数据库用户并授权(S&T) CREATE USER test IDENTIFIED BY welcome DEFAULT TABLESPACE “EXAMPLE” TEMPORARY TABLESPACE “TEMP”; GRANT “DBA” TO test ; -- 导入scott到test中(S&T) impdp test/welcome remap_schema=scott:test dumpfile=scott.dmp directory=backup; -- 检查附加日志并打开(S&T) SQL> archive log list; SQL> alter database add supplemental log data; SQL> alter system archive log current; SQL> alter database force logging; SQL> select log_mode,supplemental_log_data_min,force_logging from v$database; ...