Symptom
- If you have a very large multi-user repository (50Gb+), you may get ORA errors when you try to create a database backup:
ORA-00604: Error occurred at recursive SQL Level 1
ORA-08177: Can't serialize access for this transaction
ORA-01555: Snapshot to old -
You may encounter one of the above mentioned errors while creating a backup of a large Common repository.
This message appears as a result of an Oracle read consistency mechanism. While your query is starting to run, the data may be modified simultaneously by other people accessing the data. Oracle cannot access the original copy of the data from the time the query was started, and Oracle cannot undo the changes. The ORA messages refer to insufficient rollback segments or undo_retentions parameter values that are not large enough. The modified data from commits and rollbacks performed causes rollback data to be overwritten if the rollback segments are smaller in size and number of changes made at that time.
Read more...
Environment
SAP Enterprise Continuous Testing by Tricentis
Product
Keywords
TOSCA, AUM, rollback, mode, UNDO_RETENTION , KBA , XX-PART-TRI-ECT , SAP Enterprise Continuous Testing by Tricentis , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview