OGG “ABEND” process Troubleshoot

if you are using oracle golden gate(OGG) and in your log encounter a similar error like that : 

2014-01-27 11:51:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
2014-01-27 11:51:19 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, REP1.prm: NLS_LANG character set WE8MSWIN1252 on the target is different from the source database character set AL32UTF8. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2014-01-27 11:51:19 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'TEST.CT1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "TEST"."CT1" SET "OBJECT_NAME" = :a1 WHERE "RNO" = :b0>).
2014-01-27 11:51:19 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1216 in seqno 2.
2014-01-27 11:51:19 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping CTEST.CT1 to TEST.CT1 OCI Error ORA-01403: no data found, SQL <UPDATE "TEST"."CT1" SET "OBJECT_NAME" = :a1 WHERE "RNO" = :b0>.
2014-01-27 11:51:19 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1216 in seqno 2.
2014-01-27 11:51:19 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from CTEST.CT1 to TEST.CT1.
2014-01-27 11:51:19 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP1.prm: PROCESS ABENDING.

and simply cant start it u might wanted to try the method below:

1. connect via ssh to the source Database

export ORACLE_SID=${ORACLE_SID}

2. query FLASHBACK_SCN

sqlplus / as sysdba SQL> select dbms_flashback.get_system_change_number from dual or select current_scn from v$database; GET_SYSTEM_CHANGE_NUMBER ------------------------ 17262230 --ID is your select result SQL> exit

3. export dump

Note : FLASHBACK_SCN is upper shown number.

exp system@${ORACLE_SID} owner=ABEND_process file=ABEND_process.dmp grants=n statistics=none triggers=n compress=n FLASHBACK_SCN=17262230 log=ABEND_process.log

4. Copy the dump to Staging Database

5. connect via ssh to the staging Database

export ORACLE_SID=${STAGING_ORACLE_SID}

6. Drop table

sqlplus / as sysdba SQL>set linesize 999 SQL>set pagesize 999 SQL>select 'drop table '||owner||'.'||object_name||' cascade constraint;' from dba_objects where object_type='TABLE' and owner in ('ABEND_process');

Note : after running the query above copy the the prompted results and run to make sure the table is dropped.

7. import dump

• go to the dump directory

imp system@${ORACLE_STAGING_SID} file=ABEND_process.dmp fromuser= ABEND_process touser= ABEND_process ignore=y log=ABEND_process.log

8. Disable Foreign key

SQL> sqlplus / as sysdba SQL>set linesize 999 SQL>set pagesize 999 SQL>select 'alter table '||owner||'.'||table_name||' disable constraint '||constraint_name||';' from dba_constraints where owner in ('ABEND_process') and constraint_type='R'; SQL>exit

Note : after running the query above copy the the prompted results and run to make sure the table is dropped.

9. Go to stg_goldengate_home

• ./ggsci

SQL>START RP_ ABEND_process aftercsn $FLASHBACK_SCN SQL>exit

Note : $FLASHBACK_SCN is query in source database .