Oracle - GG

Guestbook

Check GG status

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
cradmin1@ppuxesdb01:/root # su - oracle
[oracle@ppuxesdb01 oracle]$ cd $OGG_HOME
[oracle@ppuxesdb01 ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.220222 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_220228.2155_FBO
AIX 7, ppc, 64bit (optimized), Oracle 19c  on Mar  3 2022 22:53:28
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2022, Oracle and/or its affiliates. All rights reserved.



GGSCI (ppuxesdb01) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt   XAG


MANAGER     RUNNING                                                  MANAGED/xag.gg_inq.goldengate/ppuxesdb01
EXTRACT     RUNNING     E_INQ_B     00:00:04      00:00:07           NON-CRITICAL
EXTRACT     RUNNING     E_INQ_ES    00:00:02      00:00:08           NON-CRITICAL
EXTRACT     RUNNING     E_INQ_I     00:00:03      00:00:08           NON-CRITICAL
REPLICAT    RUNNING     R_GG        00:00:06      00:00:01           NON-CRITICAL
REPLICAT    RUNNING     R_OPR_B     00:00:11      00:00:02           NON-CRITICAL
REPLICAT    RUNNING     R_OPR_ES    00:00:00      00:00:08           NON-CRITICAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
cradmin1@ppuxifdb01:/root# su - oracle
[oracle@ppuxifdb01 oracle]$ cd $OGG_HOME
[oracle@ppuxifdb01 ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.220222 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_220228.2155_FBO
AIX 7, ppc, 64bit (optimized), Oracle 19c  on Mar  3 2022 22:53:28
Operating system character set identified as US-ASCII.

Copyright (C) 1995, 2022, Oracle and/or its affiliates. All rights reserved.



GGSCI (ppuxifdb01) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt   XAG


MANAGER     RUNNING                                                  MANAGED/xag.gg_opr.goldengate/ppuxifdb01
EXTRACT     RUNNING     E_GG        00:00:03      00:00:07           NON-CRITICAL
EXTRACT     RUNNING     E_OPR_B     00:00:03      00:00:08           NON-CRITICAL
EXTRACT     RUNNING     E_OPR_ES    00:00:04      00:00:09           NON-CRITICAL
REPLICAT    RUNNING     R_INQ_B     00:00:11      00:00:04           NON-CRITICAL
REPLICAT    RUNNING     R_INQ_ES    00:00:00      00:00:04           NON-CRITICAL
REPLICAT    RUNNING     R_INQ_I     00:00:05      00:00:02           NON-CRITICAL

Contents

  1. Check GG status