SQL>  startup mount restrict pfile='/home/oracle/ora.ora' ;    
ORA-32006: FAST_START_IO_TARGET initialization parameter has been deprecated
ORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecated
ORACLE instance started.Total System Global Area 8551575552 bytes
Fixed Size                  2176808 bytes
Variable Size            2382366936 bytes
Database Buffers         6157238272 bytes
Redo Buffers                9793536 bytes
Database mounted.
SQL> alter database datafile '/archdata/migtemp/undotbs01.dbf' offline ;Database altered.SQL> alter database open;Database altered.SQL>  create undo tablespace undotbs9 datafile '/archdata/undotbs09.dbf' size 1000M autoextend on retention noguarantee;
 create undo tablespace undotbs9 datafile '/archdata/undotbs09.dbf' size 1000M autoextend on retention noguarantee
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: '/archdata/migtemp/undotbs01.dbf'SQL> drop tablespace undotbs1 including contents and datafiles; 
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU2_1351147975$' found, terminate
dropping tablespace
SQL>  select SEGMENT_NAME,TABLESPACE_NAME,STATUS from dba_rollback_segs;SEGMENT_NAME                   TABLESPACE_NAME                STATUS
------------------------------ ------------------------------ ----------------
SYSTEM                         SYSTEM                         ONLINE
_SYSSMU2_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU3_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU4_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU5_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU6_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU7_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU8_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU9_1351147975$           UNDOTBS1                       NEEDS RECOVERY
_SYSSMU10_1351147975$          UNDOTBS1                       NEEDS RECOVERY
_SYSSMU11_1351147975$          UNDOTBS1                       OFFLINESEGMENT_NAME                   TABLESPACE_NAME                STATUS
------------------------------ ------------------------------ ----------------
_SYSSMU12_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU13_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU14_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU15_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU16_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU17_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU41_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU42_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU43_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU44_1351147975$          UNDOTBS1                       OFFLINE
_SYSSMU45_1351147975$          UNDOTBS1                       OFFLINESEGMENT_NAME                   TABLESPACE_NAME                STATUS
------------------------------ ------------------------------ ----------------
_SYSSMU46_1351147975$          UNDOTBS1                       OFFLINE
*.undo_tablespace='UNDOTBS1'
_CORRUPTED_ROLLBACK_SEGMENTS=(_SYSSMU1_1351147975$,_SYSSMU2_1351147975$,_SYSSMU3_1351147975$,_SYSSMU4_1351147975$,_SYSSMU5_1351147975$,_SYSSMU6_1351147975$,_SYSSMU7_1351147975$,_SYSSMU8_1351147975$,_SYSSMU9_1351147975$,_SYSSMU10_1351147975$,_SYSSMU11_1351147975$)~
~
~
~
~
~
"ora.ora" 45L, 1726C written                                                                                      
oracle@linux_lbi_09:~> 
oracle@linux_lbi_09:~> exit
exitSQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount restrict pfile='/home/oracle/ora.ora' ; 
ORA-32006: FAST_START_IO_TARGET initialization parameter has been deprecated
ORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecated
ORACLE instance started.Total System Global Area 8551575552 bytes
Fixed Size                  2176808 bytes
Variable Size            2382366936 bytes
Database Buffers         6157238272 bytes
Redo Buffers                9793536 bytes好不容易重建表空间之后,重启,报错,如下:
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.Total System Global Area 8551575552 bytes
Fixed Size                  2176808 bytes
Variable Size            2382366936 bytes
Database Buffers         6157238272 bytes
Redo Buffers                9793536 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 17155
Session ID: 885 Serial number: 5oracle@linux_lbi_09:~> oerr ora 01092
01092, 00000, "ORACLE instance terminated. Disconnection forced"
// *Cause:  The instance this process was connected to was terminated
//          abnormally, probably via a shutdown abort. This process
//          was forced to disconnect from the instance.
// *Action: Examine the alert log for more details. When the instance has been 
//          restarted, retry action.
oracle@linux_lbi_09:~> oracle删除undo表空间问题。Oracle