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.

SOLUTION :

Problematic files are recovered from backup and made online.

Assume that the problematic file’s number is 2.

dbtut
Author: 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 *