本文详细介绍了如何使用Data Pump进行OGG的初始化配置，包括在源库和目标库创建用户、配置SourceDB的复制队列、设置Data Pump进程、创建checkpointtable以及启动和验证同步过程。内容涵盖从源端导出数据到目标端导入数据的完整步骤。
使用Data Pump 来进行初始化
（1）配置OGG 进程 datapump （参考datapump模式的搭建）
8.1在source和target database 上创建测试用户
--source database
SQL> create user sender identified by oracle default tablespace users temporary tablespace temp; --创建用户
User created.
SQL> grant connect,resource,dba to sender;
Grant succeeded.
2. --target database
SQL> create user receiver identified by oracle default tablespace users temporary tablespace temp; --创建用户
User created.
SQL> grant connect,resource,dba to receiver;
Grant succeeded.
SQL> create user sender identified by oracle default tablespace users temporary tablespace temp; --创建用户
User created.
SQL> grant connect,resource,dba to sender;
Grant succeeded.
2. --target database
SQL> create user receiver identified by oracle default tablespace users temporary tablespace temp; --创建用户
User created.
SQL> grant connect,resource,dba to receiver;
Grant succeeded.
8.2 配置SourceDB 的复制队列
GGSCI (ogg02) 10> dblogin userid ggs, password ggs
Successfully logged into database.
Successfully logged into database.
最低0.47元/天 解锁文章
扫一扫
1374
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
