ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Resize_undo_tablespace

Resize_undo_tablespace

原创 Linux操作系统 作者:senseinvest 时间:2009-06-17 21:17:23 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-26

  • 博文量
    51
  • 访问量
    27652