Zero Downtime Installation Guide for Oracle

10.3 HotFix 3

Back Next

Resetting the Messaging Stream After an Oracle Flashback

After an Oracle flashback, you can reset the messaging stream. Use the

reset_message_queue_trail_files.sql

script, which is included in the replication package.

The script runs the following commands:

stop EQENVA
stop PQENVA
DELETE EXTTRAIL D:\ggs\dirdat\enva\qe
ADD EXTTRAIL D:\ggs\dirdat\enva\qe, EXTRACT EQENVA, MEGABYTES 5
DELETE RMTTRAIL D:\ggs\dirdat\envb\qr
ADD RMTTRAIL D:\ggs\dirdat\envb\qr, EXTRACT PQENVA, MEGABYTES 5
start EQENVA
start PQENVA
SEND EXTRACT EQENVA ROLLOVER
SEND EXTRACT PQENVA ROLLOVER

The DELETE and ADD commands reset the transaction pointers for the files. The commands do not delete the files.

The ROLLOVER command forces the extract to start a new trail file. For example, if the current file is qe000023, it starts file qe000024.

After the script is finished, start the Oracle GoldenGate Command Interpreter and run the following commands:

GGSCI > DBLOGIN USERID [orsid] PASSWORD “[password]”
GGSCI > CLEANUP CHECKPOINTTABLE [orsid]. GGS_EVENT_CHECKPOINT

Rename Saved Search

Table of Contents

Zero Downtime Installation Guide for Oracle

Zero Downtime Installation Guide for Oracle

Resetting the Messaging Stream After an Oracle Flashback

Resetting the Messaging Stream After an Oracle Flashback