ORA-01403 advanced replication
edited Feb 28, 2013 3:54AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
We have a live server hosting a
master definition site (SID=cncop, REPGROUP=CNC), which usually
replicates to a master site (SID=cncrep, REPGROUP=CNC) using advanced
replication.
We have failed this live server over to our standby server, and are now using the master site (cncrep) as our master database, replicating to the master definition site (cncop).
This was running successfully for approx 18 hours, but this morning at approx. 09:20 hours we started getting replication errors stating 'no data found'.
We have a process in place to synchronise the data from the current live database (in this case cncrep) to the replicated database (in this case cncop) by essentially stopping replication, taking an export from source (cncrep), truncating tables from destination (cncop), and importing data (via datapump) to the destination. We use the 'TABLE_EXISTS_ACTION=replace' for the import, and have tried the truncate option also.
We have failed this live server over to our standby server, and are now using the master site (cncrep) as our master database, replicating to the master definition site (cncop).
This was running successfully for approx 18 hours, but this morning at approx. 09:20 hours we started getting replication errors stating 'no data found'.
We have a process in place to synchronise the data from the current live database (in this case cncrep) to the replicated database (in this case cncop) by essentially stopping replication, taking an export from source (cncrep), truncating tables from destination (cncop), and importing data (via datapump) to the destination. We use the 'TABLE_EXISTS_ACTION=replace' for the import, and have tried the truncate option also.
0