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