Basic replication fails with ORA-12008 and 01562 [message #159344] |
Fri, 17 February 2006 09:03 |
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?
|
|
|
|