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:~>
港控/mmm°
不念不忘少年蓝@
深藏阁楼爱情的钟
青旅半醒
灰太狼
小灰灰
还没有评论，来说两句吧...