Home » Server Options » Streams & AQ » Do not want to loose any data after Apply process abort (Oracle 10.2.0.3.0 on Linux 64 bit)
Do not want to loose any data after Apply process abort [message #352534] Wed, 08 October 2008 05:03 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
if i have one way replication from production to replication server. dba_capture on production is showing that it is enable and on replication server dba_apply is showing abort status.
In dba_apply_error we have following error
ORA-26687: no instantiation SCN provided for "PRO"."P1" in source database "DEMETER"

PRO is schema and P1 is table name.

What are the steps to Apply all the changes captured before and after the above event occured, because i do not want to loose any data as production database is running.

Report message to a moderator

Re: Do not want to loose any data after Apply process abort [message #352787 is a reply to message #352534] Thu, 09 October 2008 10:41 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Data wont be lost as long as you have archivelogs containing the required checkpoint scn.\
Regards,
Varun Punj

Report message to a moderator

Previous Topic: Deqeueing is not progressing after a RAC instance fails
Next Topic: Contention in stream apply process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 08 08:23:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.