GoldenGate Database Initial Setup
GoldenGate Uni-Directional Replication
GoldenGate Bi-Directional Replication

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

Globals
Manager

Extract
Data Pump
Replication

Extract
Data Pump
Replication

PL/SQL For the Sequences Solution

Exceptions Setup

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
set linesize 140 pagesize 50
select groupname, committime, local_insert_time, 
       (local_insert_time - committime)*24*60*60 as "LAG (Seconds)"
from GGS_MON.GGS_LAGTIME
where (local_insert_time - committime)*24*60*60 > 59
order by 2;

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 pages 0 feedback off linesize 160
SELECT 'EXEC mol_sequences.mol_sequence_sync(''' || SEQUENCE_OWNER || ''',''' || SEQUENCE_NAME || ''',100);'
FROM DBA_SEQUENCES
WHERE SEQUENCE_OWNER IN ('MAILONLINE','RDRCOMMENTS','REGISTRATION','LEGAL','FBIAGENT');

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