4 Replies Latest reply: Apr 23, 2013 1:56 AM by 1004794 RSS

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

    user13584223
      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.