2.3.2 使用pfile文件启动数据库
SQL> startup pfile='/tmp/pfile.ora';
ORACLE instance started.

Total System Global Area 1620115456 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2253704 bytes
Variable Size? ? ? ? ? ? 989858936 bytes
Database Buffers? ? ? ? ? 620756992 bytes
Redo Buffers? ? ? ? ? ? ? ? 7245824 bytes
Database mounted.
Database opened.

2.3.3 删除回滚段成功
SQL>? drop rollback segment "_SYSSMU10_1695440836$";

Rollback segment dropped.

2.3.4 删除回滚表空间undotbs1成功
SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

2.3.5 此时查询数据库的相关信息
SQL>? select segment_id, segment_name,status,tablespace_name from dba_rollback_segs where status not in ('ONLINE','OFFLINE')
? 2? ;

no rows selected

SQL> select FILE_ID, FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 "MB", MAXBYTES/1024/1024/1024 "GB", AUTOEXTENSIBLE, STATUS, ONLINE_STATUS from dba_data_files;

? FILE_ID FILE_NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TABLESPACE_NAME? ? ? ? ? ? ? ? ? ? ? ? MB? ? ? ? GB AUT STATUS? ? ONLINE_
---------- -------------------------------------------------------- ------------------------------ ---------- ---------- --- --------- -------
? ? ? ? 1 /u02/oracle/JINGYU/datafile/o1_mf_system_bwp198r7_.dbf? SYSTEM? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 700 31.9999847 YES AVAILABLE SYSTEM
? ? ? ? 2 /u02/oracle/JINGYU/datafile/o1_mf_sysaux_bwp19hl8_.dbf? SYSAUX? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 600 31.9999847 YES AVAILABLE ONLINE
? ? ? ? 4 /u02/oracle/JINGYU/datafile/o1_mf_undotbs2_bwqxbnxo_.dbf UNDOTBS2? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100 31.9999847 YES AVAILABLE ONLINE
? ? ? ? 5 /u02/oracle/JINGYU/datafile/o1_mf_dbs_d_ji_bwp4r7cm_.dbf DBS_D_JINGYU? ? ? ? ? ? ? ? ? ? ? ? ? 100 31.9999847 YES AVAILABLE ONLINE

发现此时一切数据文件正常,此时已经可以正常关库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

2.3.6 以spfile正常启动数据库，检查一切正常
SQL> startup
ORACLE instance started.

Total System Global Area 1620115456 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2253704 bytes
Variable Size? ? ? ? ? ? 989858936 bytes
Database Buffers? ? ? ? ? 620756992 bytes
Redo Buffers? ? ? ? ? ? ? ? 7245824 bytes
Database mounted.
Database opened.
SQL> show parameter undo

NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
undo_management? ? ? ? ? ? ? ? ? ? ? string? ? ? AUTO
undo_retention? ? ? ? ? ? ? ? ? ? ? integer? ? 900
undo_tablespace? ? ? ? ? ? ? ? ? ? ? string? ? ? undotbs2
SQL> set linesize 150
SQL> col file_name for a56
SQL> select FILE_ID, FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 "MB", MAXBYTES/1024/1024/1024 "GB", AUTOEXTENSIBLE, STATUS, ONLINE_STATUS from dba_data_files;