GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to rename Replicate trailing files

edited Sep 13, 2012 12:51AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
Hi,
I've a simple replication set up between Oracle DB1 (containing Extract process EHR, local trail file L1 and a Data Pump process PHR) and Oracle DB2 (containing Replicate process RHR which is reading from the trail file L2).

My request is simple. How can I rename the trail files in DB2 from L2 to R1 without the need to re-initialize the data?

I've got GG 11g R2, Oracle 11g R2 on Windows 32-bit.

Thanks in advance.

GGSCI (WIN11SRC) 58> view params phrdev1
Extract PHRDEV1
----------------------------------------
-- Data Pump extract <font color="navy"><b>for</b></font> HR schema
----------------------------------------
PassThru
RmtHost WIN11TRG, MgrPort 7840
RmtTrail dirdat/l2
ReportCount Every 10000 Records, Rate
Report at 01:00
ReportRollover at 01:15
DiscardFile dirrpt/PHRDEV1.dsc, Append
DiscardRollover at 01:00
Table HR.EMPLOYEES;
Table HR.JOBS;
Table HR.JOB_HISTORY;
Table HR.LOCATIONS;
Table HR.DEPARTMENTS;
 
 
GGSCI (WIN11TRG) 32> view params rhrdev1
Replicat RHRDEV1
------------------------------------------
-- Replicat <font color="navy"><b>for</b></font> HR Schema
------------------------------------------
USERID GGS_OWNER@ORA11TRG, PASSWORD **
AssumeTargetDefs
ReportCount Every 30 Minutes, Rate
Report at 01:00
ReportRollover at 01:15
DiscardFile dirrpt/RHRDEV1.dsc, Append
DiscardRollover at 02:00 ON SUNDAY
Map HR.EMPLOYEES, Target HR.EMPLOYEES;
Map HR.JOBS, Target HR.JOBS;
Map HR.JOB_HISTORY, Target HR.JOB_HISTORY;
Map HR.LOCATIONS, Target HR.LOCATIONS;
Map HR.DEPARTMENTS, Target HR.DEPARTMENTS;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center