Undo tablespace faults and ORA-01548 Processing

The processing logs cannot be retained on site, and the logs are written in memory. Give yourself a thought prompt.

When a development database is started, an undo error is reported. The environment is Oracle 10.2.0.5 and aix 5308.

Start the database and prompt that undo is damaged.
ORA-01157: cannot identify/lock data file 4-see DBWR trace file
ORA-01110: data file 4: '/u01/app/oracle/oradata/YONGDB/undotbs01.dbf'

View:
Select file #, name, status from v $ datafile;
Result: The status of the undotbs1 tablespace is media recover.

Therefore, first Delete the undo data file and open the database

SQL> alter database datafile '/oradata/gyldb/undotbs01.dbf' offline for drop;

Database altered.

SQL> alter database open;

Database altered.

Create a new undo tablespace

SQL> create undo tablespace UNDOTBS2 datafile '/oradata/gyldb/undotbs021.dbf' size 500 m;

Tablespace created.

SQL> alter system set undo_tablespace = UNDOTBS2;

System altered.

Then, delete the problematic undo tablespace.
SQL> drop tablespace UNDOTBS1 including contents and datafiles;
Drop tablespace UNDOTBS1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_ SYSSMU1_3638931391 $ 'found, terminate
Dropping tablespace

 

Select SEGMENT_NAME, TABLESPACE_NAME, STATUS from dba_rollback_segs

Create pfile = '/home/oracle/yd. ora' from spfile
Shut down the database and restore pfile.
_ Partition upted_rollback_segments = (_ SYSSMU2_3033359625 $ ', _ partition $, _ SYSSMU8_2755301871 $, _ partition $, _ SYSSMU2_3033359625 $)

 

SQL> drop tablespace undotbs1 including contents and datafiles;
Drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_ SYSSMU10_3267518184 $ 'found, terminate dropping tablespace

 

Continue check

SQL> select SEGMENT_NAME, TABLESPACE_NAME, STATUS from dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------
SYSTEM ONLINE
_ SYSSMU10_3267518184 $ UNDOTBS1 NEEDS RECOVERY
_ SYSSMU24_1022883919 $ UNDOTBS2 ONLINE
_ SYSSMU23_1498951573 $ UNDOTBS2 ONLINE
_ SYSSMU22_1897326838 $ UNDOTBS2 ONLINE
_ SYSSMU21_3263997952 $ UNDOTBS2 ONLINE
_ Syssmu16_40936000073 $ UNDOTBS2 ONLINE
_ SYSSMU15_758499186 $ UNDOTBS2 ONLINE
_ Syssmu14_00001607053 $ UNDOTBS2 ONLINE
_ Syssmu13_351_7649 $ UNDOTBS2 ONLINE
_ SYSSMU12_2563089079 $ UNDOTBS2 ONLINE

SEGMENT_NAME TABLESPACE_NAME STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------
_ SYSSMU11_3918295226 $ UNDOTBS2 ONLINE

Close again and add the following content after pfile:
_ OFFLINE_ROLLBACK_SEGMENTS = (_ SYSSMU10_3267518184 $)

Or try
Alter rollback segment '_ SYSSMU10_3267518184 $ 'offline;
Drop rollback segment '_ SYSSMU10_3267518184 $ ';

Delete after pfile is started again
Drop tablespace undotbs1 including contents and datafiles;

Then create a new default undotbs1

Create undo tablespace UNDOTBS1 datafile '/oradata/gyldb/undotbs01.dbf' size 10000 m reuse;

Alter system set undo_tablespace = UNDOTBS1;

Below

Solve the problem