Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Basic replication fails with ORA-12008 and 01562
Basic replication fails with ORA-12008 and 01562 [message #159344] Fri, 17 February 2006 09:03 Go to next message
arunpillai
Messages: 1
Registered: February 2006
Junior Member
We have a one-way (Basic) Oracle replication configured from a master site to 15 destination DBs. The total size of the table is about 1GB with 20 million rows. Currently when there is a massive update of about 1-2 million rows at master site, the replication fails at all 15 destination DBs with the following error:

ORA-12008: error in materialized view refresh path
ORA-01562: failed to extend rollback segment number 2
ORA-01650: unable to extend rollback segment RBS_1 by 125 in tablespace ROLLBACK

At the time when the refresh fails, there is at least about 1GB of free RBS available on the destination database. The snapshot refresh is configured to occur manually by calling DBMS_REFRESH.REFRESH with a refresh group. There is no other parameter defined in DBMS_REFRESH other than the refresh group name. The MVIEW is created with the clause REFRESH FAST WITH PRIMARY KEY with no other config parameter.

With the current setup of diskspace, it is not an alternative to create a dedicated RBS to do this transaction becuase of diskspace limitations to create additional Rollbacks.

Can you suggest any method that can avoid the replication failure?
Re: Basic replication fails with ORA-12008 and 01562 [message #159345 is a reply to message #159344] Fri, 17 February 2006 09:06 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Reported By: arunpillai On: Fri, 17 February 2006 16:04

Reason
I need help to resolve this the help and expertise from the forum members. Thnaks.. AP


Don't report to get attention!

MHE
Previous Topic: OWB Browser Installation
Next Topic: Oracle 9i AS - Performance Issue
Goto Forum:
  


Current Time: Thu Mar 28 09:20:04 CDT 2024