转载

OGG搭建(单实例-->单实例）


点击(此处)折叠或打开

  1. [oracle@Test11g ogg]$ ldd --version
  2. ldd (GNU libc) 2.5
  3. Copyright (C) 2006 Free Software Foundation, Inc.
  4. This is free software; see the source for copying conditions. There is NO
  5. warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  6. Written by Roland McGrath and Ulrich Drepper.


点击(此处)折叠或打开

  1. [oracle@Test11g ogg]$ ldd ggsci
  2.     librt.so.1 => /lib64/librt.so.1 (0x000000317dc00000)
  3.     libdl.so.2 => /lib64/libdl.so.2 (0x000000317ac00000)
  4.     libgglog.so => /ogg/libgglog.so (0x00002ad522ebd000)
  5.     libggrepo.so => /ogg/libggrepo.so (0x00002ad52331f000)
  6.     libdb-6.1.so => /ogg/libdb-6.1.so (0x00002ad5235a1000)
  7.     libggperf.so => /ogg/libggperf.so (0x00002ad523985000)
  8.     libggparam.so => /ogg/libggparam.so (0x00002ad523bbb000)
  9.     libicui18n.so.48 => /ogg/libicui18n.so.48 (0x00002ad524d6d000)
  10.     libicuuc.so.48 => /ogg/libicuuc.so.48 (0x00002ad52515c000)
  11.     libicudata.so.48 => /ogg/libicudata.so.48 (0x00002ad5254de000)
  12.     libpthread.so.0 => /lib64/libpthread.so.0 (0x000000317b000000)
  13.     libxerces-c.so.28 => /ogg/libxerces-c.so.28 (0x00002ad526ca3000)
  14.     libantlr3c.so => /ogg/libantlr3c.so (0x00002ad52726a000)
  15.     libmysqlclient.so.18 => /ogg/libmysqlclient.so.18 (0x00002ad527483000)
  16.     libggnnzitp.so => /ogg/libggnnzitp.so (0x00002ad527bc0000)
  17.     libm.so.6 => /lib64/libm.so.6 (0x000000317a800000)
  18.     libc.so.6 => /lib64/libc.so.6 (0x000000317a400000)
  19.     /lib64/ld-linux-x86-64.so.2 (0x000000317a000000)
  20.     libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x0000003180000000)
  21.     libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x000000317fc00000)

在环境变量中添加变量，我的ogg安装目录是/ogg，没有说必须用oracle用户安装，但是我们默认这么搞。

点击(此处)折叠或打开

  1. export PATH=/ogg:$PATH
  2. export LD_LIBRARY_PATH=/ogg:$LD_LIBRARY_PATH
http://yunpan.cn/c3V9rbMguvHsV  访问密码 1f09
下载解压，进入Disk1执行runInstaller

OGG搭建(单实例-->单实例）


OGG搭建(单实例-->单实例）

OGG搭建(单实例-->单实例）

OGG搭建(单实例-->单实例）

source和target都要安装，target配置Replicate ，source配置extract


开启归档，强制日志，附加日志：通过附加日志获取更多的内容，比如说表的主键，rowid等。

点击(此处)折叠或打开

  1. 08:40:30 SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;

  3. LOG_MODE SUPPLEME FOR
  4. ------------ -------- ---
  5. ARCHIVELOG YES NO

  7. Elapsed: 00:00:00.02
  8. 08:40:36 SQL> alter database add supplemental log data;

  10. Database altered.

  12. Elapsed: 00:00:00.42

  14. 08:41:28 SQL> alter database force logging;

  16. Database altered.

  18. Elapsed: 00:00:00.41
  19. 08:41:47 SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;

  21. LOG_MODE SUPPLEME FOR
  22. ------------ -------- ---
  23. ARCHIVELOG YES YES

  25. Elapsed: 00:00:00.01
务必切换一次日志
08:43:29 SQL> alter system switch logfile;
System altered.
创建OGG所需要的表空间，12C必须创建，11g可以不用创建。

点击(此处)折叠或打开

  1. 08:43:37 SQL> create tablespace ggs datafile '/u01/app/oracle/oradata/test/ggs.dbf' size 10m autoextend on;

  3. Tablespace created.

  5. Elapsed: 00:00:00.97
  6. 08:49:15 SQL> create user ggs identified by ggs default tablespace ggs;

  8. User created.

  10. Elapsed: 00:00:00.67
  11. 08:49:45 SQL> grant connect,resource to ggs;

  13. Grant succeeded.

  15. Elapsed: 00:00:00.15
  16. 08:50:00 SQL> grant execute on utl_file to ggs;

  18. Grant succeeded.
执行脚本

点击(此处)折叠或打开

  1. 08:50:14 SQL> @/ogg/marker_setup.sql

  3. Marker setup script

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

  9. Enter Oracle GoldenGate schema name:ggs

  11. Elapsed: 00:00:00.14
  12. Elapsed: 00:00:00.04

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

  18. MARKER TABLE
  19. -------------------------------
  20. OK
  21. Elapsed: 00:00:00.14

  23. MARKER SEQUENCE
  24. -------------------------------
  25. OK
  26. Elapsed: 00:00:00.02

  28. Script complete.
  29. 08:55:15 SQL> @/ogg/ddl_setup.sql

  31. Oracle GoldenGate DDL Replication setup script

  33. Verifying that current user has privileges to install DDL Replication...
  34. Elapsed: 00:00:00.02
  35. Elapsed: 00:00:00.01

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

  42. Enter Oracle GoldenGate schema name:ggs

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

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

  49. Check complete.
  50. Elapsed: 00:00:00.01
  51. Elapsed: 00:00:00.24




  56. Elapsed: 00:00:00.00
  57. Elapsed: 00:00:00.20


  60. Elapsed: 00:00:00.00
  61. Elapsed: 00:00:00.05
  62. Elapsed: 00:00:00.04
  63. Elapsed: 00:00:00.02
  64. Elapsed: 00:00:00.04
  65. Elapsed: 00:00:00.03


  68. Elapsed: 00:00:00.00
  69. Elapsed: 00:00:00.05


  72. Elapsed: 00:00:00.01
  73. Elapsed: 00:00:00.04
  74. Elapsed: 00:00:00.04
  75. Elapsed: 00:00:00.01
  76. Elapsed: 00:00:00.04

  78. Using GGS as a Oracle GoldenGate schema name.

  80. Working, please wait ...
  81. Elapsed: 00:00:00.04

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

  87. CLEAR_TRACE STATUS:

  89. Line/pos     Error
  90. -------------------- -----------------------------------------------------------------
  91. No errors     No errors
  92. Elapsed: 00:00:00.03

  94. CREATE_TRACE STATUS:

  96. Line/pos     Error
  97. -------------------- -----------------------------------------------------------------
  98. No errors     No errors
  99. Elapsed: 00:00:00.06

  101. TRACE_PUT_LINE STATUS:

  103. Line/pos     Error
  104. -------------------- -----------------------------------------------------------------
  105. No errors     No errors
  106. Elapsed: 00:00:00.03

  108. INITIAL_SETUP STATUS:

  110. Line/pos     Error
  111. -------------------- -----------------------------------------------------------------
  112. No errors     No errors
  113. Elapsed: 00:00:00.05

  115. DDLVERSIONSPECIFIC PACKAGE STATUS:

  117. Line/pos     Error
  118. -------------------- -----------------------------------------------------------------
  119. No errors     No errors
  120. Elapsed: 00:00:00.04

  122. DDLREPLICATION PACKAGE STATUS:

  124. Line/pos     Error
  125. -------------------- -----------------------------------------------------------------
  126. No errors     No errors
  127. Elapsed: 00:00:00.04

  129. DDLREPLICATION PACKAGE BODY STATUS:

  131. Line/pos     Error
  132. -------------------- -----------------------------------------------------------------
  133. No errors     No errors
  134. Elapsed: 00:00:00.04

  136. DDL IGNORE TABLE
  137. -----------------------------------
  138. OK
  139. Elapsed: 00:00:00.04

  141. DDL IGNORE LOG TABLE
  142. -----------------------------------
  143. OK
  144. Elapsed: 00:00:00.05

  146. DDLAUX    PACKAGE STATUS:

  148. Line/pos     Error
  149. -------------------- -----------------------------------------------------------------
  150. No errors     No errors
  151. Elapsed: 00:00:00.04

  153. DDLAUX PACKAGE BODY STATUS:

  155. Line/pos     Error
  156. -------------------- -----------------------------------------------------------------
  157. No errors     No errors
  158. Elapsed: 00:00:00.05

  160. SYS.DDLCTXINFO    PACKAGE STATUS:

  162. Line/pos     Error
  163. -------------------- -----------------------------------------------------------------
  164. No errors     No errors
  165. Elapsed: 00:00:00.04

  167. SYS.DDLCTXINFO    PACKAGE BODY STATUS:

  169. Line/pos     Error
  170. -------------------- -----------------------------------------------------------------
  171. No errors     No errors
  172. Elapsed: 00:00:00.03

  174. DDL HISTORY TABLE
  175. -----------------------------------
  176. OK
  177. Elapsed: 00:00:00.05

  179. DDL HISTORY TABLE(1)
  180. -----------------------------------
  181. OK
  182. Elapsed: 00:00:00.04

  184. DDL DUMP TABLES
  185. -----------------------------------
  186. OK
  187. Elapsed: 00:00:00.05

  189. DDL DUMP COLUMNS
  190. -----------------------------------
  191. OK
  192. Elapsed: 00:00:00.06

  194. DDL DUMP LOG GROUPS
  195. -----------------------------------
  196. OK
  197. Elapsed: 00:00:00.04

  199. DDL DUMP PARTITIONS
  200. -----------------------------------
  201. OK
  202. Elapsed: 00:00:00.06

  204. DDL DUMP PRIMARY KEYS
  205. -----------------------------------
  206. OK
  207. Elapsed: 00:00:00.10

  209. DDL SEQUENCE
  210. -----------------------------------
  211. OK
  212. Elapsed: 00:00:00.01

  214. GGS_TEMP_COLS
  215. -----------------------------------
  216. OK
  217. Elapsed: 00:00:00.05

  219. GGS_TEMP_UK
  220. -----------------------------------
  221. OK
  222. Elapsed: 00:00:00.04

  224. DDL TRIGGER CODE STATUS:

  226. Line/pos     Error
  227. -------------------- -----------------------------------------------------------------
  228. No errors     No errors
  229. Elapsed: 00:00:00.04

  231. DDL TRIGGER INSTALL STATUS
  232. -----------------------------------
  233. OK
  234. Elapsed: 00:00:00.19

  236. DDL TRIGGER RUNNING STATUS
  237. ----------------------------------------------------------------------
  238. ENABLED
  239. Elapsed: 00:00:00.17

  241. STAYMETADATA IN TRIGGER
  242. ----------------------------------------------------------------------
  243. OFF
  244. Elapsed: 00:00:00.00

  246. DDL TRIGGER SQL TRACING
  247. ----------------------------------------------------------------------
  248. 0
  249. Elapsed: 00:00:00.01

  251. DDL TRIGGER TRACE LEVEL
  252. ----------------------------------------------------------------------
  253. NONE
  254. Elapsed: 00:00:00.01

  256. LOCATION OF DDL TRACE FILE
  257. ------------------------------------------------------------------------------------------------------------------------
  258. /u01/app/oracle/diag/rdbms/test/test/trace/ggs_ddl_trace.log
  259. Elapsed: 00:00:00.01

  261. Analyzing installation status...

  263. Elapsed: 00:00:01.15

  265. VERSION OF DDL REPLICATION
  266. ------------------------------------------------------------------------------------------------------------------------
  267. OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2
  268. Elapsed: 00:00:00.06

  270. STATUS OF DDL REPLICATION
  271. ------------------------------------------------------------------------------------------------------------------------
  272. SUCCESSFUL installation of DDL Replication software components
  273. Elapsed: 00:00:00.00

  275. Script complete.
  276. 08:55:52 SQL> @/ogg/role_setup.sql

  278. GGS Role setup script

  280. This script will drop and recreate the role GGS_GGSUSER_ROLE
  281. To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)

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

  287. Enter GoldenGate schema name:ggs
  288. Wrote file role_setup_set.txt

  290. PL/SQL procedure successfully completed.

  292. Elapsed: 00:00:00.01

  294. Role setup script complete

  296. Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

  298. GRANT GGS_GGSUSER_ROLE TO <loggedUser>

  300. where <loggedUser> is the user assigned to the GoldenGate processes.

点击(此处)折叠或打开

  1. 08:58:19 SQL> grant GGS_GGSUSER_ROLE to ggs;

  3. Grant succeeded.

  5. Elapsed: 00:00:00.09
  6. 08:58:47 SQL> @/ogg/ddl_enable.sql

  8. Trigger altered.

  10. Elapsed: 00:00:00.01
  11. 08:58:59 SQL> @?/rdbms/admin/dbmspool


  14. Package created.

  16. Elapsed: 00:00:00.10

  18. Grant succeeded.

  20. Elapsed: 00:00:00.06
  21. 08:59:22 SQL> 08:59:22 SQL>
  22. 08:59:23 SQL> @/ogg/ddl_pin.sql
  23. Enter value for 1:
  24. BEGIN dbms_shared_pool.keep(' .DDLReplication', 'P'); END;

  26. *
  27. ERROR at line 1:
  28. ORA-00931: missing identifier
  29. ORA-06512: at "SYS.DBMS_UTILITY", line 156
  30. ORA-06512: at "SYS.DBMS_SHARED_POOL", line 72
  31. ORA-06512: at "SYS.DBMS_SHARED_POOL", line 84
  32. ORA-06512: at line 1


  35. Elapsed: 00:00:00.02
  36. Enter value for 1: 1
  37. BEGIN dbms_shared_pool.keep('1 .trace_put_line', 'P'); END;

  39. *
  40. ERROR at line 1:
  41. ORA-00931: missing identifier
  42. ORA-06512: at "SYS.DBMS_UTILITY", line 156
  43. ORA-06512: at "SYS.DBMS_SHARED_POOL", line 72
  44. ORA-06512: at "SYS.DBMS_SHARED_POOL", line 84
  45. ORA-06512: at line 1


  48. Elapsed: 00:00:00.01

  50. PL/SQL procedure successfully completed.

  52. Elapsed: 00:00:00.02






正文到此结束
所属分类： 编程技术

热门推荐

相关文章

阿里云首购8折
说给你听

本文目录
随机标签
书籍教程
springboot-demo Java入门教程 bootstrap3 CSS Apache基础教程 php ionic 教程 Python mysql教程 eclipse Ubuntu VPS系统配置 AngularJS 教程 MongoDB教程 Struts2教程 Redis教程 Spring教程 Git教程 Java设计模式 Jenkins进阶系列 openfire参考指南 HBase教程 Maven教程 hibernate教程 Docker 教程 memcached教程 Quartz指南 Hive教程 ANTLR教程 Ant教程 java实例教程 SpringCloud Elastic-Job-Lite XStream教程 深入浅出MyBatis Hazelcast教程 ibaties教程 SVN教程 rabittmq教程 Hadoop教程 solr教程 WebService CXF学习 springcloud-demo JPA教程 ActiveMQ中文指南 Java内存模型 java-demo dubbo教程 Linux入门视频教程
近期评论
  1. 1 Spring Cloud Circuit Breaker快速入门Demo
  2. 2 Spring Cloud Bus快速入门Demo
  3. 3 Spring Cloud Config快速入门Demo
  4. 4 Spring Cloud Function快速入门Demo
  5. 5 SSPanel-Uim搭建教程 2023年全新定制版主题-解决老版本命令失效问题
  6. 6 Spring Boot集成Milvus和deeplearning4j实现图搜图功能
  7. 7 Spring Boot集成Aviator实现参数校验
  8. 8 ACME自动申请免费的通配符https域名证书
  9. 9 wordpress 数据库和文件优化
  10. 10 CentOS安装Docker与Docker-Compose
网站信息
  • 文章总数：82,696 篇
  • 文件总数：284,257 个
  • 标签总数：2,380 个
  • 分类总数：84 个
  • 留言数量：2,560 条
  • 在线人数：668 人
  • 运行天数：4,392天
  • 最后更新：2024年11月05日20点
Loading...

其他链接

关于本站

本站定位：个人技术类博客

本站作用：写博客、记日志、闲聊扯淡鼓捣技术。

问题交流

[HBLOG]公众号 HBLOG HBLOG