使用crt工具连接服务器登录数据库是能正常进入的,并且是处于读写状态
查看其它相关参数,发现undo以及回滚段状态存在异常
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string
所有的segment均为offline的状态:
SQL> select segment_name, tablespace_name, status from dba_rollback_segs;
修改UNDO相关参数:
SQL> alter system set undo_management=auto scope=spfile;
SQL> shutdown immediate;
SQL> startup;
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
查看回滚段状态:
SQL> select segment_name, tablespace_name, status from dba_rollback_segs;