Work for 16th October

GoldenGate Database Initial Setup
GoldenGate Uni-Directional Replication
GoldenGate Bi-Directional Replication
GoldenGate as a Clusterware Resource
Checking and Diagnosing GoldenGate
Converting Bi-Directional to Uni-Directional

GoldenGate Best Practices - Bi-Directional
GoldenGate High Availability with RAC

Globals
Manager

Extract
Data Pump
Replicat

Extract
Data Pump
Replicat

PL/SQL For the Sequences Solution

Error Messages and Resolution

Exceptions Setup

Alert/Check Script for GoldenGate

set lines 120
col job_name format a20
col ACTUAL_START_DATE format a30
col run_duration format a30
select JOB_NAME, STATUS, to_char(ACTUAL_START_DATE,'DD-MON-YYYY HH24:MI') start_date, RUN_DURATION 
from dba_scheduler_job_run_details 
where job_name = 'SYNC_SEQUENCES_JOB'
order by 3;

set lines 120
col sequence_name format a30
col sync_date format a40
select * from ggate.sync_sequences_log
order by sync_date;

set lines 120
col sequence_name format a30
select * from ggate.mol_gg_sequences
order by owner;

select owner, sequence_name, valueint, valuepoc,
       case when mod(ValueInt,2) = mod(ValuePOC,2) then 'ERROR'
         else 'ODD EVEN SUCCESS'
       end Validation
from ggate.mol_gg_sequences
order by owner, sequence_name;

SET PAGESIZE 0 LINESIZE 120 FEEDBACK OFF
spool /u07/goldengate/dirout/sequence_sync_output.sql
SELECT 'set echo on timing on' from dual;
SELECT 'conn ggate/ggate123' from dual;
SELECT 'exec mol_sequences.mol_sequence_sync(''' || SEQUENCE_OWNER || ''',''' || SEQUENCE_NAME || ''',100);'
FROM DBA_SEQUENCES
WHERE SEQUENCE_OWNER in ('MAILONLINE','RDRCOMMENTS','REGISTRATION','LEGAL','FBIAGENT')
AND   SEQUENCE_NAME not in ('HIBERNATE_SEQUENCE','HEALTHCHECK_SEQ','TN_TEST_SEQ')
ORDER BY 1;
spool off

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
set linesize 100
col group_name format a12
col scn format a16
select GROUP_NAME, LOG_CSN as SCN, SEQNO, RBA, LAST_UPDATE_TS 
from GGATE.CHKPTAB;

SET LINESIZE 160
COL TABLE_NAME FORMAT A40
COL RECCSN FORMAT 999999999999
select to_char(EXCP_DATE,'DD-MON-YYYY HH24:MI:SS') EXCEPTION_DATE, 
       REP_NAME, TABLE_NAME, RECCSN, LOGRBA, LOGPOSITION, SRCROWID SOURCE_ROWID,
       ERRMSG FROM ggate.exceptions;

Migration to another DB Instance