Database Tutorials

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

dbtut

6 years ago

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.

SQL> recover datafile 2;
SQL> alter database datafile 2 online;

1 2	SQL> recover datafile 2; SQL> alter database datafile 2 online;

Exit mobile version