Difference between revisions of "GGSCI Utility"

From Robs_Wiki
Jump to: navigation, search
(configure supplemental logging)
(configure supplemental logging)
Line 15: Line 15:
 
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> add trandata pdb4.robla.rl_objects   
 
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> add trandata pdb4.robla.rl_objects   
 
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> delete trandata pdb4.robla.rl_objects   
 
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> delete trandata pdb4.robla.rl_objects   
 +
</pre>
 +
== View the GG replication status ==
 +
<pre>
 +
GGSCI (rob01db01.robdomain as c##gg_admin@orcl/CDB$ROOT) 17> info all
 +
 +
Program    Status      Group      Lag at Chkpt  Time Since Chkpt
 +
 +
MANAGER    RUNNING                                         
 +
EXTRACT    RUNNING    PPDB4      00:00:00      00:00:06   
 +
EXTRACT    RUNNING    XPDB4      00:00:00      00:00:07   
 +
REPLICAT    ABENDED    RPDB4      00:00:00      274:29:48 
 
</pre>
 
</pre>

Revision as of 18:18, 6 October 2020

configure a wallet

GGSCI (rob01db01.robdomain) 1> add credentialstore 
GGSCI (rob01db01.robdomain) 1> alter credentialstore add user c##gg_admin password gg_admin alias c##gg_admin_root Credential store altered. 
GGSCI (rob01db01.robdomain) 2> alter credentialstore add user c##gg_admin@pdb4 password gg_admin alias c##gg_admin_pdb4
GGSCI (rob01db01.robdomain) 3> alter credentialstore add user c##gg_admin@pdb5 password gg_admin alias c##gg_admin_pdb5
GGSCI (rob01db01.robdomain as c##gg_admin@orcl/CDB$ROOT) 24> info credentialstore

configure supplemental logging

GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> info trandata pdb4.robla.rl_objects   
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> add trandata pdb4.robla.rl_objects   
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> delete trandata pdb4.robla.rl_objects   

View the GG replication status

GGSCI (rob01db01.robdomain as c##gg_admin@orcl/CDB$ROOT) 17> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     PPDB4       00:00:00      00:00:06    
EXTRACT     RUNNING     XPDB4       00:00:00      00:00:07    
REPLICAT    ABENDED     RPDB4       00:00:00      274:29:48