some ggsci replicat analysis and restart commands

on January 5, 2017 at 1:47 pm
Posted In: Oracle Golden Gate (Cat)

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 
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.