===========================
Unregister and Register Extract
===========================
DBLOGIN USERID OGG PASSWORD XXXXXX
DBLOGIN USERID OGG PASSWORD XXXXXX
STOP EXTRACT EXT_I_01
UNREGISTER EXTRACT EXT_I_01 DATABASE
DELETE EXTRACT EXT_I_01
REGISTER EXTRACT EXT_I_01 DATABASE
ADD EXTRACT EXT_I_01 INTEGRATED TRANLOG, BEGIN NOW
ADD EXTTRAIL /software/ogg/191/dirdat/01/out/ei EXTRACT EXT_I_01
===========================
Unregister and Register Datapump
Unregister and Register Datapump
===========================
DELETE EXTRACT DPM_I_01
ADD EXTRACT DPM_I_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/ei
ADD RMTTRAIL /software/ogg/191/dirdat/01/in/ei EXTRACT DPM_I_01
START EXTRACT DPM_I_01
INFO DPM_I_01
===========================
Unregister and Register Replicat
===========================
STOP REPLICAT REP_I_01
DELETE REPLICAT REP_I_01
ADD REPLICAT REP_I_01, EXTTRAIL /software/ogg/191/dirdat/01/in/ei
START REPLICAT REP_I_01
===========================
Unregister and Register Group
===========================
DBLOGIN USERID OGG, PASSWORD XXXXXX
STOP EXTRACT EXT_N_01
UNREGISTER EXTRACT EXT_N_01 DATABASE
DELETE EXTRACT EXT_N_01
REGISTER EXTRACT EXT_N_01 DATABASE
ADD EXTRACT EXT_N_01 INTEGRATED TRANLOG, BEGIN NOW
ADD EXTTRAIL /software/ogg/191/dirdat/01/out/en EXTRACT EXT_N_01
START EXTRACT EXT_N_01
STOP EXTRACT DPM_N_01
DELETE EXTRACT DPM_N_01
ADD EXTRACT DPM_N_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/en
ADD RMTTRAIL /software/ogg/191/dirdat/01/in/en EXTRACT DPM_N_01
START EXTRACT DPM_N_01
STOP REPLICAT REP_N_01
DELETE REPLICAT REP_N_01
ADD REPLICAT REP_N_01, INTEGRATED EXTTRAIL /software/ogg/191/dirdat/01/in/en
START REPLICAT REP_N_01
Whenever starting a GG processes, it is logged
alert log:
GoldenGate Apply Reader AS01 for OGG$REP_N_01 with pid=158 OS id=17350 stopped
2021-06-28T06:32:25.564814+00:00
GoldenGate APPLY AP05 for OGG$REP_N_01 with pid=157, OS id=17346 stopped
2021-06-28T06:32:33.662778+00:00
GoldenGate Apply: OGG$REP_N_01 APPLY Dropped
2021-06-28T06:32:33.663002+00:00
APPLY OGG$REP_N_01: Apply User: OGG
2021-06-28T06:32:33.663083+00:00
APPLY OGG$REP_N_01: Apply Tag: 00
2021-06-28T06:32:47.704457+00:00
GoldenGate Apply: OGG$REP_N_01 APPLY Created
2021-06-28T06:32:47.752593+00:00
APPLY OGG$REP_N_01: Apply User: OGG
2021-06-28T06:32:47.752693+00:00
APPLY OGG$REP_N_01: Apply Tag: 00
2021-06-28T06:32:48.323311+00:00
GoldenGate APPLY AP05 for OGG$REP_N_01 started with pid=108, OS id=22864
2021-06-28T06:32:48.329577+00:00
APPLY OGG$REP_N_01: Apply User: OGG
2021-06-28T06:32:48.329670+00:00
APPLY OGG$REP_N_01: Apply Tag: 00
2021-06-28T06:32:48.330235+00:00
APPLY OGG$REP_N_01: Parameter Set by User: ALLOW_DUPLICATE_ROWS Value: Y
2021-06-28T06:32:48.330341+00:00
APPLY OGG$REP_N_01: Parameter Set by User: PRESERVE_ENCRYPTION Value: N
2021-06-28T06:32:48.330442+00:00
APPLY OGG$REP_N_01: Parameter Set by User: EAGER_SIZE Value: 15100
2021-06-28T06:32:48.330524+00:00
APPLY OGG$REP_N_01: Parameter Set by User: CDGRANULARITY Value: ROW
2021-06-28T06:32:48.330606+00:00
APPLY OGG$REP_N_01: Parameter Set by User: SUPPRESSTRIGGERS Value: Y
2021-06-28T06:32:48.330687+00:00
APPLY OGG$REP_N_01: Parameter Set by User: _GG_ERROR_HANDLING_MODE Value: ASYNC
2021-06-28T06:32:48.330907+00:00
APPLY OGG$REP_N_01: Parameter Set by User: PARALLELISM Value: 8
2021-06-28T06:32:48.893939+00:00
In ggserr.log
2021-06-28T06:32:26.092+0000 INFO OGG-00994 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: REPLICAT REP_N_01 stopped normal
ly.
2021-06-28T06:32:26.141+0000 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): STOP REPLIC
AT REP_N_01.
2021-06-28T06:32:26.601+0000 ERROR OGG-15163 Oracle GoldenGate Command Interpreter for Oracle: There was a problem sending a messa
ge to REPLICAT REP_N_01 (Connection reset by peer).
2021-06-28T06:32:29.114+0000 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): STOP REPLIC
AT REP_N_01.
2021-06-28T06:32:33.465+0000 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): DELETE REPL
ICAT REP_N_01.
2021-06-28T06:32:34.340+0000 INFO OGG-02529 Oracle GoldenGate Command Interpreter for Oracle: Successfully unregistered REPLICAT
REP_N_01 inbound server OGG$REP_N_01 from database.
2021-06-28T06:32:34.343+0000 INFO OGG-14034 Oracle GoldenGate Command Interpreter for Oracle: Heartbeat entries with [REP_N_01] d
eleted.
2021-06-28T06:32:39.946+0000 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD REPLICA
T REP_N_01 INTEGRATED EXTTRAIL /software/ogg/191/dirdat/01/in/en.
2021-06-28T06:32:43.378+0000 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): START REPLI
CAT REP_N_01.
2021-06-28T06:32:43.380+0000 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 10
.10.51.39:50218 (START REPLICAT REP_N_01 ).
2021-06-28T06:32:43.385+0000 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP_N_01 starting.
2021-06-28T06:32:43.804+0000 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: REPLICAT REP_N_01 starting.
2021-06-28T06:32:43.804+0000 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Operating system character set i
dentified as UTF-8.
2021-06-28T06:32:43.804+0000 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: ANSI SQL parameter syntax is use
d for parameter parsing.
2021-06-28T06:32:43.804+0000 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Successfully set environment variable ORACLE_SID=igt.
2021-06-28T06:32:43.804+0000 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Successfully set environment variable ORACLE_HOME=/software/oracle/122.
2021-06-28T06:32:43.804+0000 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2021-06-28T06:32:43.944+0000 INFO OGG-01360 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: REPLICAT is running in Integrated mode.
2021-06-28T06:32:44.513+0000 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Triggers will be suppressed by default.
2021-06-28T06:32:44.524+0000 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/software/ogg/191/dirtmp.
2021-06-28T06:32:44.535+0000 INFO OGG-06604 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Database IGT CPU info: CPU Count 16, CPU Core Count 16, CPU Socket Count 2.
2021-06-28T06:32:44.618+0000 INFO OGG-02545 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.
2021-06-28T06:32:44.618+0000 INFO OGG-02527 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Integrated Replicat does not populate a trace table.
2021-06-28T06:32:47.777+0000 INFO OGG-02528 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: REPLICAT REP_N_01 successfully registered with database as inbound server OGG$REP_N_01.
2021-06-28T06:32:48.271+0000 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: REPLICAT REP_N_01 started.
2021-06-28T06:32:49.439+0000 INFO OGG-02530 Oracle GoldenGate Delivery for Oracle, rep_n_01.prm: Integrated replicat successfully attached to inbound server OGG$REP_N_01.
===================
Starhome Stuff
===================
DBLOGIN USERID OGG PASSWORD rad21mif
I_01
STOP EXTRACT EXT_I_01
SEND EXTRACT EXT_I_01, FORCESTOP
UNREGISTER EXTRACT EXT_I_01 DATABASE
DELETE EXTRACT EXT_I_01
REGISTER EXTRACT EXT_I_01 DATABASE
ADD EXTRACT EXT_I_01 INTEGRATED TRANLOG, BEGIN NOW
ADD EXTTRAIL /software/ogg/191/dirdat/01/out/ei EXTRACT EXT_I_01
START EXTRACT EXT_I_01
STOP EXTRACT DPM_I_01
SEND EXTRACT DPM_I_01, FORCESTOP
DELETE EXTRACT DPM_I_01
ADD EXTRACT DPM_I_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/ei
ADD RMTTRAIL /software/ogg/191/dirdat/01/in/ei EXTRACT DPM_I_01
START EXTRACT DPM_I_01
INFO DPM_I_01
STOP REPLICAT REP_I_01
SEND REPLICAT REP_I_01, FORCESTOP
DELETE REPLICAT REP_I_01
ADD REPLICAT REP_I_01, EXTTRAIL /software/ogg/191/dirdat/01/in/ei
START REPLICAT REP_I_01
S_01
STOP EXTRACT EXT_S_01
SEND EXTRACT EXT_S_01, FORCESTOP
SEND EXTRACT EXT_S_01, FORCESTOP
UNREGISTER EXTRACT EXT_S_01 DATABASE
DELETE EXTRACT EXT_S_01
REGISTER EXTRACT EXT_S_01 DATABASE
ADD EXTRACT EXT_S_01 INTEGRATED TRANLOG, BEGIN NOW
ADD EXTTRAIL /software/ogg/191/dirdat/01/out/es EXTRACT EXT_S_01
START EXTRACT EXT_S_01
STOP EXTRACT DPM_S_01
SEND EXTRACT DPM_S_01, FORCESTOP
DELETE EXTRACT DPM_S_01
ADD EXTRACT DPM_S_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/es
ADD RMTTRAIL /software/ogg/191/dirdat/01/in/es EXTRACT DPM_S_01
START EXTRACT DPM_S_01
STOP REPLICAT REP_S_01
SEND REPLICAT REP_S_01, FORCESTOP
DELETE REPLICAT REP_S_01
ADD REPLICAT REP_S_01, INTEGRATED EXTTRAIL /software/ogg/191/dirdat/01/in/es
START REPLICAT REP_S_01
P_01
STOP EXTRACT EXT_P_01
SEND EXTRACT EXT_P_01, FORCESTOP
UNREGISTER EXTRACT EXT_P_01 DATABASE
DELETE EXTRACT EXT_P_01
REGISTER EXTRACT EXT_P_01 DATABASE
ADD EXTRACT EXT_P_01 INTEGRATED TRANLOG, BEGIN NOW
ADD EXTTRAIL /software/ogg/191/dirdat/01/out/ep EXTRACT EXT_P_01
START EXTRACT EXT_P_01
STOP EXTRACT DPM_P_01
SEND EXTRACT DPM_P_01, FORCESTOP
DELETE EXTRACT DPM_P_01
ADD EXTRACT DPM_P_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/ep
ADD RMTTRAIL /software/ogg/191/dirdat/01/in/ep EXTRACT DPM_P_01
START EXTRACT DPM_P_01
STOP REPLICAT REP_P_01
SEND REPLICAT REP_P_01, FORCESTOP
DELETE REPLICAT REP_P_01
ADD REPLICAT REP_P_01, INTEGRATED EXTTRAIL /software/ogg/191/dirdat/01/in/ep
START REPLICAT REP_P_01
===================
Check Status
===================
No comments:
Post a Comment