Friday , June 21 2024

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 *