Downstream capture setup from Grid fails with Ora-01555 Snapshot too old
edited Feb 16, 2012 1:39AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi,
I'm trying to set up downstream schema replication in Grid Control 11.1. It fails (after 4 hours) with this:
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 10 with name
"_SYSSMU10_1947237797$" too small
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7983
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2703
ORA-06512: at line 5
When I try a smaller schema, it works well. Both databases are 11.2.0.2. Regular expdb/impdp of the schema works without problem.
It's not clear to me exactly where the job fails. Both the export/import part has been done, and initial data has been imported to target database.
0