Home » Server Options » Replication » Oracle golden gate 12.1.2.1 (OEL 6)
Oracle golden gate 12.1.2.1 [message #635902] Fri, 10 April 2015 16:19 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I am trying to start replicat from a different point . ANy idea why this fails

# Target database.

-rw-r-----   1 oracle   dba      99999751 Apr  3 17:34 PB000139
-rw-r-----   1 oracle   dba      99999886 Apr  3 17:34 PB000140
-rw-r-----   1 oracle   dba      15634631 Apr 10 11:18 PB000141
-rw-r-----   1 oracle   dba          900      Apr 10 11:43 PB000142
-rw-r-----   1 oracle   dba         1708     Apr 10 11:43 PB000143  => Want to start replicat from here 
 
ALTER REPLICAT RP_B ,EXTSEQNO PB000143 ,EXTRBA 1708
ERROR: Invalid number (PB000143) for EXTSEQNO.

ALTER  REPLICAT RP_B ,EXTSEQNO PB000143
ERROR: Invalid number (PB000143) for EXTSEQNO.

ALTER REPLICAT RP_B ,EXTRBA 1708
REPLICAT altered.

Re: Oracle golden gate 12.1.2.1 [message #635903 is a reply to message #635902] Fri, 10 April 2015 17:58 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Got it ! issue was that my REPLICAT was configured to use wrong trail file location .

alter replicat rp_b ,EXTTRAIL /newlocation/PB -- Solved the issue .
Re: Oracle golden gate 12.1.2.1 [message #635904 is a reply to message #635903] Fri, 10 April 2015 17:59 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
And another error : I was using "PB000143" where as it should be just 143 Wink
Previous Topic: ORA-02291: integrity constrain voilated
Next Topic: OGG start PUMP after SCN
Goto Forum:
  


Current Time: Thu Mar 28 15:02:18 CDT 2024