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 184.108.40.206 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.
Oracle has also suggested same but they are not 100% sure like issue will get resolved after applying the patches.
they are just given suggestion on this to upgrade the database version.
Since issue is releated to critical production databases (nine databases = 3primary+3standby+3DR) we can't take risk.
Please suggest to resolve the issue
same batch job will run successfully once database get restarted but we will face same issue again on 2nd day.
So we are daily restarting our database complete the batch job.
Database Version: 220.127.116.11
OS: Windows Server 2008 r2