OGG(oracle+GoldenGate)学习笔记

Enter mode of installation:initialsetup

Working, please wait ...

Spooling to file ddl_setup_spool.txt

Using GOLDENGATE as a GoldenGate schema name, INITIALSETUP as a mode of installa tion.

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 GOLDENGATE

DDLORA_GETTABLESPACESIZE STATUS:

Line/pos

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

Error

----------------------------------------------------------------- No errors No errors

CLEAR_TRACE STATUS:

Line/pos

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

Error

----------------------------------------------------------------- No errors No errors

17

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

18

DDLREPLICATION PACKAGE STATUS:

Line/pos

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

Error

----------------------------------------------------------------- No errors No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos

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

Error

----------------------------------------------------------------- No errors No errors

DDL HISTORY TABLE

---------------------------------------------------------------------- OK

DDL HISTORY TABLE(1)

---------------------------------------------------------------------- OK

DDL DUMP TABLES

---------------------------------------------------------------------- OK

DDL DUMP COLUMNS

---------------------------------------------------------------------- OK

DDL DUMP LOG GROUPS

---------------------------------------------------------------------- OK

DDL DUMP PARTITIONS

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

19

OK

DDL DUMP PRIMARY KEYS

---------------------------------------------------------------------- OK

DDL SEQUENCE

---------------------------------------------------------------------- OK

GGS_TEMP_COLS

---------------------------------------------------------------------- OK

GGS_TEMP_UK

---------------------------------------------------------------------- OK

DDL TRIGGER CODE STATUS:

Line/pos

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

Error

----------------------------------------------------------------- No errors No errors

DDL TRIGGER INSTALL STATUS

---------------------------------------------------------------------- OK

DDL TRIGGER RUNNING STATUS

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

ENABLED

STAYMETADATA IN TRIGGER

-------------------------------------------------------------------------------- OFF

DDL TRIGGER SQL TRACING

20