alter replicat cfeaqrep, exttrail /backup/oracle/OGG/dirdat/cfedwh/AQ000000006

stop replicat cfeaqrep

alter replicat cfeaqrep extseqno 11, extrba 0

start replicat cfeaqrep aftercsn 662496036

 

select scn_to_timestamp (529512856) from dual;

info cfeaqext, showch 
info cfeaqext, detail
ALTER EXTRACT cfeaqext  SCN 529512856
ALTER EXTRACT cfeaqext  ETROLLOVER
info cfeaqext, showch
alter replicat CFEAQREP
ALTER REPLICAT CFEAQREP EXTSEQNO 133
ALTER REPLICAT CFEAQREP EXTRBA 0
start replicat CFEAQREP after scn value ok…

ALTER REPLICAT CFEAQREP EXTSEQNO 3
ALTER REPLICAT CFEAQREP EXTRBA 0

ADD EXTRACT cfeaqext integrated tranlog, begin now.
register extract cfeaqext database.
ADD EXTTRAIL /backup/oracle/OGG/dirdat/cfedwh/AQ  EXTRACT cfeaqext  MEGABYTES 250.
start extract cfeaqext.

info cfeaqext  showch.
ALTER EXTRACT cfeaqext  SCN 529512856.
ALTER EXTRACT cfeaqext  ETROLLOVER.
info cfeaqext  showch.
start extract cfeaqext.

add replicat cfeaqrep integrated exttrail /backup/oracle/OGG/dirdat/cfedwh/AQ.
start replicat cfeaqrep aftercsn 529512856.
info cfeaqrep  detail.
info cfeaqrep.

 
CACHEMGR CACHESIZE 4G in extract parameter file .
It will limit memory consumption but may use LOTS of disk