SAP Knowledge Base Article - Preview

3734303 - Error "User getting ORA errors when trying to create a multi-user repository backup" - Tricentis

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

SAP Enterprise Continuous Testing by Tricentis all versions

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.