Test: OGG_extarct&reaplict with PK and duplicates

Test: OGG_extarct&reaplict with PK and duplicates 1. Source table without PK and OGG extract set the PK ”PKEY” 2. Target Table has PK “PKEY” and OGG replicat the PK ”PKEY” –Prepare the testing tables CREATE TABLE SOURCE.TST_TAB01 ( PKEY NUMBER(19) NOT NULL, TIME_IN TIMESTAMP(6), TIME_OUT TIMESTAMP(6), OGG_DATETIME DATE ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 […]

Exaple: expdp&impdp in parfile

impdp_tab01_user.par directory=DMPDIR dumpfile=expdp_tab01_user.dmp logfile=impdp_tab01_user.log parallel=4 cluster=n EXCLUDE=INDEX EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS TABLE_EXISTS_ACTION=REPLACE transform=disable_archive_logging:y transform=storage:n TABLES=USER.tab01 remap_schema=USER:USER remap_tablespace=USERS:USERS impdp c##ogg_user@ORCLPDB1 parfile=impdp_tab01_user.par vi expdp_tab01_user.par DIRECTORY=DMPDIR DUMPFILE=expdp_tab01_user.dmp LOGFILE=expdp_tab01_user.log CLUSTER=N PARALLEL=4 TABLES= USER.tab01 expdp c##ogg_user@pstg parfile=expdp_tab01_user.par vi expdp_orcl_preprod_data_schemas.par DIRECTORY=DMPDIR DUMPFILE=expdp_orcl_preprod_data_schemas_%U.dmp LOGFILE=expdp_orcl_preprod_data_schemas.log FLASHBACK_SCN=1197898541013 CLUSTER=N PARALLEL=4 SCHEMAS=USER,OGG EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS vi impdp_orcl_preprod_data_schemas.par directory=DMPDIR dumpfile=expdp_orcl_preprod_data_schemas_1111.dmp logfile=imppdp_orcl_preprod_data_schemas_.log PARALLEL=10 CLUSTER=N SCHEMAS=USER,OGG TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=STORAGE:N vi expdp_orcl_preprod_data_user.par DIRECTORY=DMPDIR DUMPFILE=expdp_orcl_preprod_data_user_%U.dmp […]

OGG4BD to send boolean data to Cassandra

OGG4BD to send boolean data to Cassandra –Create target table in Cassandra CREATE TABLE TARGET.TARGET01 ( col1 text PRIMARY KEY, col5 float, col2 bigint, col3 timestamp, col4 boolean ) WITH bloom_filter_fp_chance = 0.01 AND caching = {‘keys’: ‘ALL’, ‘rows_per_partition’: ‘NONE’} AND comment = ” AND compaction = {‘class’: ‘org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy’, ‘max_threshold’: ’32’, ‘min_threshold’: ‘4’} AND compression […]

Alert the usage of tablespace

Alert the usage of tablespace —-Create tablespace for user create tablespace yw_cux_data  datafile ‘/u02/lsdb/yw_cux_data01.dbf’ size 100m; create user lsdb_yw identified by ****** default tablespace yw_cux_data temporary  tablespace temp; grant connect,dba to lsdb_yw; grant select on DBA_FREE_SPACE to lsdb_yw; grant select on  DBA_DATA_FILES to lsdb_yw; grant execute on sys.UTL_TCP to lsdb_yw; grant execute on sys.UTL_SMTP to […]

OGG-05259 The Extract’s recovery checkpoint LSN is not in the cdc.lsn_time_mapping table of database ‘test’.

OGG-05259 The Extract’s recovery checkpoint LSN 00009da1:0057deff:0004 is not in the cdc.lsn_time_mapping table of database ‘test’. Symptoms: 2019-10-08 14:33:14 INFO OGG-05257 For CDC tuning best practices, please see https://technet.microsoft.com/en-us/library/dd266396%28v=sql.100%29.aspx. 2019-10-08 14:33:14 WARNING OGG-05292 The Oracle GoldenGate capture job is running on database test with NOMANAGECDCCLEANUP. Oracle GoldenGate will not purge CDC enabled tables. Source Context […]

OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File)

OGG Replicat Abends On LOB Data. OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File) SYMPTOMS: 2018-10-06 18:13:43 ERROR OGG-02188 Unexpected LOB record or record fragment in /trail/DL000000016, rba 1,750. CAUSE: replicat altered to start on trail where the first record is a LOB and not the base record INSERT/UPDATE/DELETE SOLUTION: […]

Install OGG for SQL Server in windows

Install OGG for Sql Server Prepare Check sqlserver veriosn  SELECT @@version Microsoft SQL Server 2016 (SP1-CU10-GDR) (KB4293808) – 13.0.4522.0 (X64) Jul 17 2018 22:41:29 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor) Requirements https://docs.oracle.com/goldengate/c1230/gg-winux/OGGIN/installing-sql-server1.htm#OGGIN-GUID-EB7DD65D-4344-4F72-9B45-18631536AC84 For SQL Server 2016, use or install the Microsoft […]

Docker run OGG4BD to Hadoop

MacBook-Air:.docker $ docker login –username=leosunnyPassword: Login Succeeded MacBook-Air:.docker $ docker pull leosunny/goldengate4bd:12.3.2.1.0 MacBook-Air:~ $ docker run –name=ogg4bd -d leosunny/goldengate4bd:12.3.2.1.0 MacBook-Air:~ $ docker exec -it –user oracle ogg4bd bash [oracle@64eeba6b8b09 ogg]$ pwd /u01/app/ogg [oracle@64eeba6b8b09 ogg]$ ggsci Oracle GoldenGate for Big Data Version 12.3.2.1.0 (Build 018) Oracle GoldenGate Command Interpreter Version 12.3.0.1.2 OGGCORE_OGGADP.12.3.0.1.2_PLATFORMS_180430.2321 Linux, x64, 64bit (optimized), […]