oracle tran 配置,【GoldenGate】Oracle GoldenGate(三) DDL同步配置

最新推荐文章于 2024-08-22 10:48:50 发布

weixin_39588679

最新推荐文章于 2024-08-22 10:48:50 发布

阅读量163

点赞数

文章标签： oracle tran 配置

该博客记录了在Oracle数据库中禁用回收站并安装GoldenGate DDL Replication的过程。首先通过SQL命令关闭回收站，然后执行安装脚本，期间检查并确认系统满足安装条件，如回收站为空。最后，脚本成功完成安装并验证了各种组件的状态，表明DDL Replication安装成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SYS@ prod>alter system set recyclebin='off' scope=both;

SYS@ prod>show parameter recyclebin

NAME TYPE VALUE

------------------------------------

----------- --------------

recyclebin string off

SYS@ prod>@ddl_setup

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 GoldenGate database objects.

NOTE: The schema must be created prior to

running this script.

NOTE: On Oracle 10g and up, system

recycle bin must be disabled.

NOTE: Stop all DDL replication before

starting this installation.

Enter GoldenGate schema name:ogg

You will be prompted for the mode of

installation.

To install or reinstall DDL replication,

enter INITIALSETUP

To upgrade DDL replication, enter NORMAL

Enter mode of installation:INITIALSETUP

Working, please wait ...

Spooling to file ddl_setup_spool.txt

Using OGG as a GoldenGate schema name,

INITIALSETUP as a mode of installation.

Working, please wait ...

RECYCLEBIN must be empty.

This installation will purge RECYCLEBIN

for all users.

To proceed, enter yes. To stop

installation, enter no.

Enter yes or no:yes

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

DDLORA_GETTABLESPACESIZE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

CLEAR_TRACE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

CREATE_TRACE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

TRACE_PUT_LINE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

INITIAL_SETUP STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

DDL HISTORY TABLE

-----------------------------------

DDL HISTORY TABLE(1)

-----------------------------------

DDL DUMP TABLES

-----------------------------------

DDL DUMP COLUMNS

-----------------------------------

DDL DUMP LOG GROUPS

-----------------------------------

DDL DUMP PARTITIONS

-----------------------------------

DDL DUMP PRIMARY KEYS

-----------------------------------

DDL SEQUENCE

-----------------------------------

GGS_TEMP_COLS

-----------------------------------

GGS_TEMP_UK

-----------------------------------

DDL TRIGGER CODE STATUS:

Line/pos Error

--------------------

-----------------------------------------------------------------

No errors No errors

DDL TRIGGER INSTALL STATUS

-----------------------------------

DDL TRIGGER RUNNING STATUS

----------------------------------------------------------------------

ENABLED

STAYMETADATA IN TRIGGER

----------------------------------------------------------------------

OFF

DDL TRIGGER SQL TRACING

----------------------------------------------------------------------

DDL TRIGGER TRACE LEVEL

-----------------------------------------------

LOCATION OF DDL TRACE FILE

----------------------------------------------------------------------------

/u01/app/oracle/admin/prod/udump/ggs_ddl_trace.log

Analyzing installation status...

STATUS OF DDL REPLICATION

------------------------------------------------------------------------------------------------------------------------

SUCCESSFUL installation of DDL Replication software components

Script complete.