Corruption Undo Tablespace Delete and Create (Non Backup)
1. select name from v$datafile;
2. rename undo.dbf datafile (with os)
3. startup mount;
4. alter database datafile ‘/u01/erpdb/oracledata/db/apps_st/data/undo01.dbf’ offline drop;
5. select segment_name,tablespace_name,status from dba_rollback_segs; (media recovery isteyen objeler)
6. create spfile from pfile;
7. edit pfile
_offline_rollback_segments=(_SYSSMU12_1441199644$,_SYSSMU11_1441199140$,_SYSSMU10_1441199130$,_SYSSMU9_1441196857$,_SYSSMU8_1441196857$,_SYSSMU7_1441196857$,_SYSSMU6_1441196848$,_SYSSMU5_1441196848$,_SYSSMU5_1441196848$,_SYSSMU4_1441196848$,_SYSSMU3_1441196845$,_SYSSMU2_1441196845$,_SYSSMU1_1441196845$)
8. alter database open;
9. drop tablespace UNDO;
10. create UNDO tablespace undotbs1 datafile ‘Path’;
11. alter system set undo_management = auto scope=spfile;