ORA-01552 :非系统表空间‘XXX’不能使用系统回退段
故障分析:
UNDO表空间数据文件受损,导致执行更新操作失败。
故障解决:
创建的新的undo表空间,undo_management置为MANUAL,重置undo指向新的undo表空间,undo_management置为AUTO,正常打开数据库。
执行步骤如下:
SQL> create undo tablespace undotbs2 datafile 'D:\app\Administrator\oradata\orcl\UNDOTBS02.dbf' size 3g;
SQL> alter system set undo_management=manual scope=spfile;
SQL> shutdown immediate;
SQL> startup
SQL> alter system set undo_tablespace=undotbs2 scope=spfile;
SQL> alter system set undo_management=auto scope=spfile;
SQL> shutdown immediate;
SQL> startup