This discussion is archived
4 Replies Latest reply: Apr 22, 2013 11:56 PM by 1004794 RSS

ORA-01555 caused by SQL statement below (SQL ID: 96g93hntrzjtr, Query Durat

user13584223 Newbie
Currently Being Moderated
Error:ORA-01555 caused by SQL statement below (SQL ID: 96g93hntrzjtr, Query Duration=0 sec, SCN: 0x0000.136b665c)

Getting above ORA-01555 error while running batch job on standby active dataguard version 11.2.0.2 and only standby database will get very slow once batch job has started, same time primary database will work fine.
Once restarted the standby database, Job will work fine but second day again we will face same issue(ora-01555).
Note: We are getting same error ORA-01555 even after added space on tbs UNDOTBS1,TEMP and increased the undo_retention parameter. There no locking,blocking session are exist and only we are getting above. Didn't get any clue from .trc or drc files also.

Please help to resolve this production issue.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points