goldengate配置ddl支持

Bertha 。 2022-01-16 11:41 257阅读 0赞

切换到goldengate软件目录下面登录数据库sqlplus / as sysdba：  
a.@marker\_setup.sql  
b.@ddl\_setup.sql  \#此处的输入goldengate管理用户oggadmin必须指定单独的表空间并且自动扩展。  
c.@role\_setup.sql  
d.@ddl\_enable.sql  
e.@?/rdbms/admin/dbmspool.sql  
f.@ddl\_pin.sql oggadmin   \#\#此处oggadmin为配置在goldnegate中的管理账户  
  
备注：oracle10需要关闭recyclebin，oracle11g以后不需要关闭recyclebin；  
源端添加参数：  
ddl &  
include mapped objname app.t\_bi\_sku &  
include mapped objname app.t\_bi\_barcode ;  
  
pump进程添加参数：  
ddl  
  
应用进程添加参数：  
DDL INCLUDE MAPPED  
DDLERROR DEFAULT IGNORE RETRYOP  
  
  
具体的脚本执行如下：  
1.在源端执行marker\_setup.sql脚本：  
\[oracle@goldengate\]$ ls marker\_setup.sql  
marker\_setup.sql  
\[oracle@goldengate\]$ sqlplus / as sysdba  
SQL\*Plus: Release 11.2.0.4.0 Production on Tue Mar 19 15:21:11 2019  
Copyright (c) 1982, 2013, Oracle.  All rights reserved.  
Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options  
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:oggadmin   \#\#配置goldengate的管理用户  
Marker setup table script complete, running verification script...  
Please enter the name of a schema for the GoldenGate database objects:  
Setting schema name to OGGADMIN  
MARKER TABLE  
\-------------------------------  
OK  
MARKER SEQUENCE  
\-------------------------------  
OK  
Script complete.  
SQL>  
  
2.执行第二个脚本ddl\_setup.sql：  
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:oggadmin  
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.  
declare  
\*  
ERROR at line 1:  
ORA-20783:  
ORA-20783:  
Oracle GoldenGate DDL Replication setup:  
\*\*\* Please move OGGADMIN to its own tablespace  
ORA-06512: at line 34  
  
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options  
  
解决：  
alter user OGGADMIN default tablespace OGG\_TBS;  
alter user OGGADMIN quota unlimited on OGG\_TBS;  
  
3.  
SQL> @role\_setup.sql  
GGS Role setup script  
This script will drop and recreate the role GGS\_GGSUSER\_ROLE  
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.)  
  
You will be prompted for the name of a schema for the GoldenGate database objects.  
NOTE: The schema must be created prior to running this script.  
NOTE: Stop all DDL replication before starting this installation.  
Enter GoldenGate schema name:oggadmin  
Wrote file role\_setup\_set.txt  
PL/SQL procedure successfully completed.  
Role setup script complete  
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:  
GRANT GGS\_GGSUSER\_ROLE TO <loggedUser>  
where <loggedUser> is the user assigned to the GoldenGate processes.  
SQL> grant GGS\_GGSUSER\_ROLE to oggadmin;  
Grant succeeded.  
4.执行其它的一些sql脚本：  
SQL> @ddl\_enable.sql  
  
Trigger altered.  
  
SQL> @?/rdbms/admin/dbmspool.sql  
  
Package created.  
Grant succeeded.  
SQL>  @ddl\_pin.sql oggadmin  
PL/SQL procedure successfully completed.  
PL/SQL procedure successfully completed.  
PL/SQL procedure successfully completed.

转载于:https://blog.51cto.com/1937519/2365522