Neil's Blog
Never say die
posts - 1,comments - 5,trackbacks - 0
AUM

将rollback segment 改为UNDO tablespace.

参考文档: SAP Note 600141

SQL> create undo tablespace PSAPUNDO   datafile '/oracle/UP1/sapdata1/undo_1/undo.data1' size 2000 M reuse
         autoextend off;    (注:不能用SAPDBA建立,否则DB会起不来)

Remark: An Undo tablespace always has the following attributes
   - extent management:        LOCAL (LMTS)
   - allocation type:          SYSTEM (autoallocate)
   - segment space management: MANUAL

ADD following parameter in  /oracle/UP1/920_64/dbs/initUP1.ora
 
 undo_tablespace = PSAPUNDO

undo_retention = 43200 # 12h as start value

undo_management = AUTO


Delete following lines from initSID.ora

   Parameter: 'rollback_segments'
   Parameter: 'transactions' 
   Parameter: 'transactions_per_rollback_segment'
   Parameter: 'max_rollback_segments'

SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database open;
SQL> DROP ROLLBACK SEGMENT <name>;

DROP ROLLBACK SEGMENT PRS_0;
DROP ROLLBACK SEGMENT PRS_1;
DROP ROLLBACK SEGMENT PRS_2;
DROP ROLLBACK SEGMENT PRS_3;
DROP ROLLBACK SEGMENT PRS_4;
DROP ROLLBACK SEGMENT PRS_5;
DROP ROLLBACK SEGMENT PRS_6;
DROP ROLLBACK SEGMENT PRS_7;
DROP ROLLBACK SEGMENT PRS_8;
DROP ROLLBACK SEGMENT PRS_9;
DROP ROLLBACK SEGMENT PRS_10;
DROP ROLLBACK SEGMENT PRS_11;
DROP ROLLBACK SEGMENT PRS_12;
DROP ROLLBACK SEGMENT PRS_13;
DROP ROLLBACK SEGMENT PRS_14;
DROP ROLLBACK SEGMENT PRS_15;
DROP ROLLBACK SEGMENT PRS_16;
DROP ROLLBACK SEGMENT PRS_17;
DROP ROLLBACK SEGMENT PRS_18;
DROP ROLLBACK SEGMENT PRS_19;

SQL> DROP TABLESPACE PSAPROLL including contents and datafiles;

手工在操作系统下删除相关的文件目录。

 

posted on 2007-03-21 14:16 Neil 阅读(148) 评论(0)  编辑 收藏 引用 所属分类: SAP BASIS
只有注册用户登录后才能发表评论。