oracle 11g ogg配置,ogg配置DDL

SYS@gg01:~>@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:ggadmin

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 GGADMIN 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 GGADMIN

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

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

OK

DDL HISTORY TABLE(1)

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

OK

DDL DUMP TABLES

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

OK

DDL DUMP COLUMNS

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

OK

DDL DUMP LOG GROUPS

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

OK

DDL DUMP PARTITIONS

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

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

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

0

DDL TRIGGER TRACE LEVEL

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

0

LOCATION OF DDL TRACE FILE

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

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

Analyzing installation STATUS...

STATUS OF DDL REPLICATION

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

SUCCESSFUL installation OF DDL Replication software components

Script complete.

SYS@gg01:~>