Resize_undo_tablespace

1.create PSAPUNDO2
sapdba or sqlplus
create undo
    tablespace "PSAPUNDO2" datafile
    '/oracle/LH1/sapdata2/undo2_1/undo2.data1' size  10000m reuse,
    '/oracle/LH1/sapdata2/undo2_2/undo2.data2' size  10000m reuse;

2.switch undo_tablespace
alter system set undo_tablespace = 'PSAPUNDO2';

3.monitor oracle undo status
select segment_name, tablespace_name, status 
from dba_rollback_segs   where tablespace_name='PSAPUNDO';

select * from dba_rollback_segs
where status = 'ONLINE' and tablespace_name = 'PSAPUNDO'
order by tablespace_name, segment_name

4.DROP TABLESPACE PSAPUNDO INCLUDING CONTENTS AND DATAFILES;
SAPDBA

5.monitor sapr3 update process

6.active sapr3 update process by sm13

7.
su - oraLH1
mkdir /oracle/LH1/sapdata1/undo_1
mkdir /oracle/LH1/sapdata1/undo_2
mkdir /oracle/LH1/sapdata1/undo_3

create undo
    tablespace "PSAPUNDO"
    datafile
    '/oracle/LH1/sapdata1/undo_1/undo.data1' size 5000m reuse,
    '/oracle/LH1/sapdata1/undo_2/undo.data2' size 5000m reuse,   
    '/oracle/LH1/sapdata1/undo_3/undo.data3' size 5000m reuse

8.switch undo_tablespace
alter system set undo_tablespace = 'PSAPUNDO';

9.monitor oracle PSAPUNDO2 undo status
select segment_name, tablespace_name, status
  from dba_rollback_segs
  where tablespace_name='PSAPUNDO2';

SELECT *
FROM dba_rollback_segs
WHERE status = 'ONLINE'
AND tablespace_name = 'PSAPUNDO2'
ORDER BY tablespace_name, segment_name

10.DROP TABLESPACE PSAPUNDO2 INCLUDING CONTENTS AND DATAFILES;
SAPDBA 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21495077/viewspace-606618/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21495077/viewspace-606618/