对 undo表空间管理测试1 的环境清理：
http://blog.csdn.net/wanghui5767260/article/details/20145959
SYS@ORCL>select tablespace_name,segment_name,status from dba_rollback_segs;
TABLESPACE_NAME SEGMENT_NA STATUS
------------------------------ ---------- ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 RBS1 ONLINE
UNDOTBS1 _SYSSMU10$ OFFLINE
UNDOTBS1 _SYSSMU9$ OFFLINE
UNDOTBS1 _SYSSMU8$ OFFLINE
UNDOTBS1 _SYSSMU7$ OFFLINE
UNDOTBS1 _SYSSMU6$ OFFLINE
UNDOTBS1 _SYSSMU5$ OFFLINE
UNDOTBS1 _SYSSMU4$ OFFLINE
UNDOTBS1 _SYSSMU3$ OFFLINE
UNDOTBS1 _SYSSMU2$ OFFLINE
TABLESPACE_NAME SEGMENT_NA STATUS
------------------------------ ---------- ----------------
UNDOTBS1 _SYSSMU1$ OFFLINE
12 rows selected.
SYS@ORCL>alter rollback segment rbs1 offline;
Rollback segment altered.
SYS@ORCL>select tablespace_name,segment_name,status from dba_rollback_segs;
TABLESPACE_NAME SEGMENT_NA STATUS
------------------------------ ---------- ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 RBS1 OFFLINE
UNDOTBS1 _SYSSMU10$ OFFLINE
UNDOTBS1 _SYSSMU9$ OFFLINE
UNDOTBS1 _SYSSMU8$ OFFLINE
UNDOTBS1 _SYSSMU7$ OFFLINE
UNDOTBS1 _SYSSMU6$ OFFLINE
UNDOTBS1 _SYSSMU5$ OFFLINE
UNDOTBS1 _SYSSMU4$ OFFLINE
UNDOTBS1 _SYSSMU3$ OFFLINE
UNDOTBS1 _SYSSMU2$ OFFLINE
TABLESPACE_NAME SEGMENT_NA STATUS
------------------------------ ---------- ----------------
UNDOTBS1 _SYSSMU1$ OFFLINE
12 rows selected.
SYS@ORCL>drop rollback segment rbs1;
Rollback segment dropped.
SYS@ORCL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ORCL>< http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KCjxwPr+qyryxvrTOytTR6aO6dW5kb7Htv9W85LncwO2y4srUMi0tLS0t0N64xLLOyv3OxLz+aW5pdE9SQ0wub3JhxeTWw6Ossum/tHVuZG/XtMysPC9wPgo8cD5TWVNAT1JDTCZndDtjcmVhdGUgcGZpbGUgZnJvbSBzcGZpbGU7PGJyPgo8YnI+Cjxicj4KRmlsZSBjcmVhdGVkLjxicj4KPGJyPgo8YnI+ClNZU0BPUkNMJmd0OyE8YnI+CltvcmFjbGVAd2hnZyB+XSQgY2QgJE9SQUNMRV9IT01FL2Ricy88YnI+CltvcmFjbGVAd2hnZyBkYnNdJCBzdHJpbmdzIHNwZmlsZU9SQ0wub3JhIDxicj4KT1JDTC5fX2RiX2NhY2hlX3NpemU9MTc2MTYwNzY4PGJyPgpPUkNMLl9famF2YV9wb29sX3NpemU9NDE5NDMwNDxicj4KT1JDTC5fX2xhcmdlX3Bvb2xfc2l6ZT00MTk0MzA0PGJyPgpPUkNMLl9fc2hhcmVkX3Bvb2xfc2l6ZT05NjQ2ODk5Mjxicj4KT1JDTC5fX3N0cmVhbXNfcG9vbF9zaXplPTA8YnI+CiouYXVkaXRfZmlsZV9kZXN0PQ=="/u01/app/oracle/admin/ORCL/adump'
*.background_dump_dest='/u01/app/oracle/admin/ORCL/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/ORCL/control01.ctl','/u01/app/oracle/oradata/ORCL/control02.ctl','/u01/app/oracle/oradata/ORCL/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/ORCL/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ORCL'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/ORCL/udump'
[oracle@whgg dbs]$ vim initORCL.ora
ORCL.__db_cache_size=176160768
ORCL.__java_pool_size=4194304
ORCL.__large_pool_size=4194304
ORCL.__shared_pool_size=96468992
ORCL.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ORCL/adump'
*.background_dump_dest='/u01/app/oracle/admin/ORCL/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/ORCL/control01.ctl','/u01/app/oracle/oradata/ORCL/control02.ctl','/u01/app/oracle/oradata/ORCL/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/ORCL/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ORCL'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_a