ORACLE在线切换undo表空间
来源:互联网 发布:网络端口作用 编辑:程序博客网 时间:2024/05/04 18:50
SQL> SHOW PARAMETER UNDO; ---------查看在用的undo空间
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> create undo tablespace UNDOTBS2 datafile '/u01/app/oracle/oradata/dbt/UNDOTBS02.dbf' size 50m; ---创建新的undo
Tablespace created.
SQL> alter system set undo_tablespace='UNDOTBS2'; ---------切换undo
System altered.
SQL> select tablespace_name,segment_name,status from dba_rollback_segs; -----------查看切换后的undo
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU20_3838875384$ OFFLINE
UNDOTBS1 _SYSSMU19_2548865203$ OFFLINE
UNDOTBS1 _SYSSMU18_3450043322$ OFFLINE
UNDOTBS1 _SYSSMU17_3397539351$ OFFLINE
UNDOTBS1 _SYSSMU16_2744645595$ OFFLINE
UNDOTBS1 _SYSSMU15_13835062$ OFFLINE
UNDOTBS1 _SYSSMU14_386546556$ OFFLINE
UNDOTBS1 _SYSSMU13_21018974$ OFFLINE
UNDOTBS1 _SYSSMU12_1706751259$ OFFLINE
UNDOTBS1 _SYSSMU11_2598913974$ OFFLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
UNDOTBS2 _SYSSMU30_1929254600$ ONLINE
UNDOTBS2 _SYSSMU29_1642166937$ ONLINE
UNDOTBS2 _SYSSMU28_2279931538$ ONLINE
UNDOTBS2 _SYSSMU27_233048736$ ONLINE
UNDOTBS2 _SYSSMU26_3260506263$ ONLINE
UNDOTBS2 _SYSSMU25_1741138756$ ONLINE
UNDOTBS2 _SYSSMU24_187621704$ ONLINE
UNDOTBS2 _SYSSMU23_798857500$ ONLINE
UNDOTBS2 _SYSSMU22_3517192271$ ONLINE
UNDOTBS2 _SYSSMU21_3148296371$ ONLINE
21 rows selected.
查询回滚段情况(原undo表空间的回滚段全部offline,可以删除相关表空间)
SQL> select tablespace_name,segment_name,status from dba_rollback_segs; --------UNDOTBS1已经离线
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU20_3838875384$ OFFLINE
UNDOTBS1 _SYSSMU19_2548865203$ OFFLINE
UNDOTBS1 _SYSSMU18_3450043322$ OFFLINE
UNDOTBS1 _SYSSMU17_3397539351$ OFFLINE
UNDOTBS1 _SYSSMU16_2744645595$ OFFLINE
UNDOTBS1 _SYSSMU15_13835062$ OFFLINE
UNDOTBS1 _SYSSMU14_386546556$ OFFLINE
UNDOTBS1 _SYSSMU13_21018974$ OFFLINE
UNDOTBS1 _SYSSMU12_1706751259$ OFFLINE
UNDOTBS1 _SYSSMU11_2598913974$ OFFLINE
SQL> alter tablespace undotbs1 offline;
Tablespace altered.
SQL> drop tablespace undotbs1 including contents and datafiles; ----------删除数据文件
Tablespace dropped.
SQL>
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> create undo tablespace UNDOTBS2 datafile '/u01/app/oracle/oradata/dbt/UNDOTBS02.dbf' size 50m; ---创建新的undo
Tablespace created.
SQL> alter system set undo_tablespace='UNDOTBS2'; ---------切换undo
System altered.
SQL> select tablespace_name,segment_name,status from dba_rollback_segs; -----------查看切换后的undo
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU20_3838875384$ OFFLINE
UNDOTBS1 _SYSSMU19_2548865203$ OFFLINE
UNDOTBS1 _SYSSMU18_3450043322$ OFFLINE
UNDOTBS1 _SYSSMU17_3397539351$ OFFLINE
UNDOTBS1 _SYSSMU16_2744645595$ OFFLINE
UNDOTBS1 _SYSSMU15_13835062$ OFFLINE
UNDOTBS1 _SYSSMU14_386546556$ OFFLINE
UNDOTBS1 _SYSSMU13_21018974$ OFFLINE
UNDOTBS1 _SYSSMU12_1706751259$ OFFLINE
UNDOTBS1 _SYSSMU11_2598913974$ OFFLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
UNDOTBS2 _SYSSMU30_1929254600$ ONLINE
UNDOTBS2 _SYSSMU29_1642166937$ ONLINE
UNDOTBS2 _SYSSMU28_2279931538$ ONLINE
UNDOTBS2 _SYSSMU27_233048736$ ONLINE
UNDOTBS2 _SYSSMU26_3260506263$ ONLINE
UNDOTBS2 _SYSSMU25_1741138756$ ONLINE
UNDOTBS2 _SYSSMU24_187621704$ ONLINE
UNDOTBS2 _SYSSMU23_798857500$ ONLINE
UNDOTBS2 _SYSSMU22_3517192271$ ONLINE
UNDOTBS2 _SYSSMU21_3148296371$ ONLINE
21 rows selected.
查询回滚段情况(原undo表空间的回滚段全部offline,可以删除相关表空间)
SQL> select tablespace_name,segment_name,status from dba_rollback_segs; --------UNDOTBS1已经离线
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU20_3838875384$ OFFLINE
UNDOTBS1 _SYSSMU19_2548865203$ OFFLINE
UNDOTBS1 _SYSSMU18_3450043322$ OFFLINE
UNDOTBS1 _SYSSMU17_3397539351$ OFFLINE
UNDOTBS1 _SYSSMU16_2744645595$ OFFLINE
UNDOTBS1 _SYSSMU15_13835062$ OFFLINE
UNDOTBS1 _SYSSMU14_386546556$ OFFLINE
UNDOTBS1 _SYSSMU13_21018974$ OFFLINE
UNDOTBS1 _SYSSMU12_1706751259$ OFFLINE
UNDOTBS1 _SYSSMU11_2598913974$ OFFLINE
SQL> alter tablespace undotbs1 offline;
Tablespace altered.
SQL> drop tablespace undotbs1 including contents and datafiles; ----------删除数据文件
Tablespace dropped.
SQL>
- ORACLE在线切换undo表空间
- ORACLE在线切换undo表空间
- ORACLE在线切换undo表空间
- oracle undo表空间切换
- Oracle 11g Undo 表空间切换
- Oracle切换undo表空间操作步骤
- undo表空间切换
- 切换UNDO表空间
- oracle表空间---undo表空间切换
- oracle 11g rac undo表空间切换
- Oracle切换undo表空间操作步骤(转)
- ORACLE UNDO表空间
- Oracle UNDO表空间
- oracle-undo表空间
- undo表空间的切换
- undo表空间的切换
- 更改oracle undo表空间
- Oracle:undo表空间管理
- Delphi REST 服务器返回UTF16编码转换成正常string
- Accelerated C++ Exercise 8-2
- Visual Studio中最常用的13个快捷键
- MFC动态创建按钮及添加消息响应
- 推荐引擎初探
- ORACLE在线切换undo表空间
- WinCE串口类及自定义消息显示接收的字符数
- mysql 常用命令
- 递归——汉诺塔
- 常见问题:Voip语音单通(二)如何解决语音单通甚至双不通的问题?
- 11.2.0.4安装环境准备for redhat as 6.4 64位
- 第一章——编译器工作的主要流程
- android解决android-support-v4打包问题
- 使用DDK提供的build进行编译驱动一点总结