OGG 명령어 정리

 

 

---

 

ogg 터미널 접속

./ggsci


INFO MANAGER (info mgr)
 : Returns information about the Manager port and process id.
SEND MANAGER                
 : Returns information about a running Manager process and optionally child processes.
START MANAGER (start mgr)
 : Starts the Manager process.
STATUS MANAGER (status mgr)
 : Returns the state of the Manager port and process ID.
STOP MANAGER (stop mgr)                
 : Manager process.

 

subdir

GGSCI (strdb1) 1> CREATE SUBDIRS

Creating subdirectories under current directory /u01/ogg

Parameter file                 /u01/ogg/dirprm: already exists.
Report file                    /u01/ogg/dirrpt: already exists.
Checkpoint file                /u01/ogg/dirchk: already exists.
Process status files           /u01/ogg/dirpcs: already exists.
SQL script files               /u01/ogg/dirsql: already exists.
Database definitions files     /u01/ogg/dirdef: already exists.
Extract data files             /u01/ogg/dirdat: already exists.
Temporary files                /u01/ogg/dirtmp: already exists.
Credential store files         /u01/ogg/dircrd: already exists.
Masterkey wallet files         /u01/ogg/dirwlt: already exists.
Dump files                     /u01/ogg/dirdmp: already exists.

 

 

MGR

> info mgr
Manager is running (IP port TCP:strdb1.7809, Process ID 20226).

> edit param mgr
-------------------------
PORT 7809

 

Extract

GGSCI (strdb1) 2> info extract EXT01 detail

EXTRACT    EXT01     Last Started 2024-08-13 21:20   Status ABENDED
Checkpoint Lag       00:00:00 (updated 00:01:44 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2024-08-11 20:27:28  Seqno 435, RBA 9444352
                     SCN 0.61758976 (61758976)

  Target Extract Trails:

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  ./dirdat/ea                                          2       1319         50 EXTTRAIL

  Extract Source                          Begin             End

  /u01/app/oracle/oradata/STR/redo03.log  2024-08-11 20:27  2024-08-11 20:27
  /u01/app/oracle/oradata/STR/redo03.log  2024-08-11 19:16  2024-08-11 20:27
  /u01/app/oracle/oradata/STR/redo03.log  2024-08-11 19:16  2024-08-11 20:27
  /u01/app/oracle/oradata/STR/redo02.log  2024-08-11 17:31  2024-08-11 19:16
  /u01/app/oracle/oradata/STR/redo02.log  2024-08-11 17:31  2024-08-11 19:16
  Not Available                           * Initialized *   2024-08-11 17:31
  Not Available                           * Initialized *   2024-08-11 17:31
  Not Available                           * Initialized *   2024-08-11 17:31


Current directory    /u01/ogg

Report file          /u01/ogg/dirrpt/EXT01.rpt
Parameter file       /u01/ogg/dirprm/ext01.prm
Checkpoint file      /u01/ogg/dirchk/EXT01.cpe
Process file
Error log            /u01/ogg/ggserr.log

 

 

Replicat

-- DML 처리 성능 비교 확인
stats {rep} , reportrate sec , table tmall.*
stats {rep} , reportrate sec , table tmall.[테이블명]