2、编辑pfile文件
vi new.ora
#*.undo_tablespace='UNDOTBS1'
undo_management = 'MANUAL'
rollback_segments = 'SYSTEM'
3、通过pfile启动Instance
startup mount pfile='/home/oracle/new.ora';
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2229944 bytes
Variable Size 360712520 bytes
Database Buffers 155189248 bytes
Redo Buffers 3805184 bytes
Database mounted.
Elapsed: 00:00:00.00
show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string
4、打开数据库
alter database open;
Database altered.
此时打开数据库正常
5、删除原有的undo tablespace创建新的undo tablespace
drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.