GGSCI Utility

From Robs_Wiki
Revision as of 18:18, 6 October 2020 by Qadmin wiki (talk | contribs) (configure supplemental logging)
Jump to: navigation, search

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