Friday, 14 June 2019

How to add integrated extract process in GG



GGSCI (source.example.com as ggadmin@DB11G) 15> edit params extract1


-- Add parameters as per your requirement
-- Change Data Capture parameter file to extract
-- source table changes
--
EXTRACT extract1
USERIDALIAS srcdb DOMAIN admin
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
EXTTRAIL ./dirdat/aa
SOURCECATALOG pdb1
TABLE hr.EMPLOYEES;

TABLE hr.DEPARTMENTS; 

GGSCI (source.example.com as ggadmin@DB11G) 16> add extract extract1, integrated tranlog begin now
EXTRACT (Integrated) added.

GGSCI (source.example.com as ggadmin@DB11G) 20> add exttrail ./dirdat/aa, extract extract1, megabytes 100
EXTTRAIL added.

GGSCI (source.example.com as ggadmin@DB11G) 21> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
EXTRACT     STOPPED     EXTRACT1    00:00:00      00:06:18

GGSCI (source.example.com as ggadmin@DB11G) 22>

No comments:

Post a Comment

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...