Saturday , September 23 2023

ORA-01552: cannot use system rollback segment for non-system tablespace ‘XXXX’


The problem was that the UNDO table space had several data files in recover mode.


Problematic files are recovered from backup and made online.

Assume that the problematic file’s number is 2.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *