OGG(oracle goldengate)实现oracle到oracle数据DDL同步

最新推荐文章于 2024-05-06 11:22:13 发布

落俗zp

最新推荐文章于 2024-05-06 11:22:13 发布

阅读量1.4k

点赞数

分类专栏： Oracle GoldenGate安装使用

本文链接：https://blog.youkuaiyun.com/weixin_41229271/article/details/101217231

版权

注：本篇文章是在已经配置过DML同步或者源端数据库已经开启归档、添加了附加日志等基础上记录的，如未设置，请参考另外一篇：https://blog.youkuaiyun.com/weixin_41229271/article/details/101196319

然后再进行下面的步骤。

源端在ogg安装目录下登陆数据库

SQL> @marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:ogg


Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG

MARKER TABLE
-------------------------------
OK

MARKER SEQUENCE
-------------------------------
OK

Script complete.


---------------------------2:
SQL> @ddl_setup.sql

ORA-20783:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Please move OGG to its own tablespace
ORA-06512: 在 line 34
解决：建立ogg管理用户单独的表空间
http://blog.itpub.net/7199859/viewspace-1062113/
重新执行：
SQL> @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:ogg

Working, please wait ...
Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

Check complete.











Using OGG as a Oracle GoldenGate schema name.

Working, please wait ...

DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG

CLEAR_TRACE STATUS:

Line/pos				 Error
---------------------------------------- -----------------------------------------------------------------
No errors				 No errors

CREATE_TRACE STATUS:

Line/pos				 Error
-------------------------

最低0.47元/天解锁文章