info <extract-name>, showch
info ECACA1, showch
To make the replicat to go new file:
====================================
ALTER replicat RMSDPC22, EXTSEQNO 3886 extrba 0
to rollover to new file for ext:
=============================
alter extract ECACA3, ETROLLOVER
to switch the extract to next sequence and to thread 1
===========================================================
alter <extract-name>, extseqno 10, extrba 0
Tracing for process:
========================
send < rep name>, trace ./dirrpt/reptrace.trc
To generate new report file:
=============================
send RMSDPC11, report
to set find long running transation
===================================
WARNLONGTRANS 2HRS
WARNLONGTRANS 2hours
WARNLONGTRANS 1DAY
WARNLONGTRANS 600sec
WARNLONGTRANS 40s
bounded recovery:
===================
BR BROFF
========================
TRANLOGOPTIONS parameter with the PURGEORPHANEDTRANSACTIONS option to
enable the purging of orphaned transactions that occur when a node fails and Extract cannot capture the rollback
===================
DBOPTIONS DEFERREFCONST
Valuable information thanks for sharing oracle dba ..
ReplyDelete