oracle partly available,Best practice to create a new undo tablespace.

Create pfile from spfile to edit

SQL> Create pfile=’/tmp/initsid.ora’ from spfile;

Shutdown the instance

set the following parameters in the pfile /tmp/initsid.ora

undo_management = manual

event = ‘10513 trace name context forever, level 2’

SQL>>startup restrict pfile=’/tmp/initsid.ora’

SQL>select tablespace_name, status, segment_name from dba_rollback_segs where status != ‘OFFLINE’;https://www.cndba.cn/xw15575450545/article/3447

If any are ‘PARTLY AVAILABLE’ or ‘NEEDS RECOVERY’ - Please open an issue with Oracle Support or update the current SR. There are many options from this moment and Oracle Support Analyst can offer different solutions for the bad undo segments.https://www.cndba.cn/xw15575450545/article/3447

6 Create new undo tablespace - example

SQL>create undo tablespace (new undo tablespace) datafile

(datafile) size 2000M;

7 Drop old undo tablespace

SQL>drop tablespace (old undo tablespace) including contents and datafiles;

9 SQL>startup nomount; —> Using your Original spfilehttps://www.cndba.cn/xw15575450545/article/3447

10 Modify the spfile with the new undo tablespace name

SQL> Alter system set undo_tablespace = ‘(new tablespace created in step 6)’ scope=spfile;

https://www.cndba.cn/xw15575450545/article/3447

https://www.cndba.cn/xw15575450545/article/3447

11 SQL>shutdown immediate;https://www.cndba.cn/xw15575450545/article/3447https://www.cndba.cn/xw15575450545/article/3447

12 SQL>startup; —> Using spfile

SQL> Create pfile=’/tmp/initsid.ora’ from spfile;https://www.cndba.cn/xw15575450545/article/3447

版权声明：本文为博主原创文章，未经博主允许不得转载。

重建undo