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.

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
Previous Topic: Deqeueing is not progressing after a RAC instance fails
Next Topic: Contention in stream apply process
Goto Forum:
  


Current Time: Fri Mar 29 04:28:36 CDT 2024