undo表空間佔用磁碟空間滿案例處理
undo佔用磁碟空間使用100%，其內容只增不減，資料庫事物無法完成，
資料庫奇慢無比，以下是處理方法
資料庫奇慢無比，以下是處理方法
[oracle@localhost ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 291G 56G 221G 21% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda5 19G 773M 17G 5% /oraredo
/dev/sda6 19G 18G 0 100% /oraundo
/dev/sda7 56G 42G 11G 80% /oracle
/dev/sda8 459G 24G 412G 6% /oradatab
/dev/sda9 926G 159G 720G 19% /oradataa
[oracle@localhost ~]$ sqlplus /nolog
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 291G 56G 221G 21% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda5 19G 773M 17G 5% /oraredo
/dev/sda6 19G 18G 0 100% /oraundo
/dev/sda7 56G 42G 11G 80% /oracle
/dev/sda8 459G 24G 412G 6% /oradatab
/dev/sda9 926G 159G 720G 19% /oradataa
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jul 29 20:28:20 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
>conn / as sysdba
Connected.
SYS AS SYSDBA >CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
'/oradataa/undotbs02.dbf' SIZE 50M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;
Connected.
SYS AS SYSDBA >CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
'/oradataa/undotbs02.dbf' SIZE 50M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;
Tablespace created.
SYS AS SYSDBA >show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SYS AS SYSDBA >alter system set undo_tablespace='UNDOTBS' scope=both;
System altered.
SYS AS SYSDBA >show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SYS AS SYSDBA >select tablespace_name,segment_name,status from dba_rollback_segs;
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ---------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU12$ ONLINE
UNDOTBS1 _SYSSMU13$ OFFLINE
UNDOTBS1 _SYSSMU14$ OFFLINE
UNDOTBS1 _SYSSMU15$ OFFLINE
UNDOTBS1 _SYSSMU16$ OFFLINE
UNDOTBS1 _SYSSMU17$ OFFLINE
UNDOTBS1 _SYSSMU18$ OFFLINE
UNDOTBS1 _SYSSMU19$ OFFLINE
UNDOTBS1 _SYSSMU20$ OFFLINE
UNDOTBS1 _SYSSMU21$ OFFLINE
------------------------------ ------------------------------ ---------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU12$ ONLINE
UNDOTBS1 _SYSSMU13$ OFFLINE
UNDOTBS1 _SYSSMU14$ OFFLINE
UNDOTBS1 _SYSSMU15$ OFFLINE
UNDOTBS1 _SYSSMU16$ OFFLINE
UNDOTBS1 _SYSSMU17$ OFFLINE
UNDOTBS1 _SYSSMU18$ OFFLINE
UNDOTBS1 _SYSSMU19$ OFFLINE
UNDOTBS1 _SYSSMU20$ OFFLINE
UNDOTBS1 _SYSSMU21$ OFFLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ---------------
UNDOTBS1 _SYSSMU22$ OFFLINE
UNDOTBS1 _SYSSMU23$ OFFLINE
UNDOTBS1 _SYSSMU24$ OFFLINE
UNDOTBS1 _SYSSMU25$ OFFLINE
UNDOTBS1 _SYSSMU26$ OFFLINE
UNDOTBS1 _SYSSMU27$ OFFLINE
UNDOTBS1 _SYSSMU28$ OFFLINE
UNDOTBS1 _SYSSMU29$ OFFLINE
UNDOTBS1 _SYSSMU30$ OFFLINE
UNDOTBS1 _SYSSMU31$ OFFLINE
UNDOTBS1 _SYSSMU32$ OFFLINE
------------------------------ ------------------------------ ---------------
UNDOTBS1 _SYSSMU22$ OFFLINE
UNDOTBS1 _SYSSMU23$ OFFLINE
UNDOTBS1 _SYSSMU24$ OFFLINE
UNDOTBS1 _SYSSMU25$ OFFLINE
UNDOTBS1 _SYSSMU26$ OFFLINE
UNDOTBS1 _SYSSMU27$ OFFLINE
UNDOTBS1 _SYSSMU28$ OFFLINE
UNDOTBS1 _SYSSMU29$ OFFLINE
UNDOTBS1 _SYSSMU30$ OFFLINE
UNDOTBS1 _SYSSMU31$ OFFLINE
UNDOTBS1 _SYSSMU32$ OFFLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ---------------
UNDOTBS1 _SYSSMU33$ OFFLINE
UNDOTBS2 _SYSSMU34$ ONLINE
UNDOTBS2 _SYSSMU35$ ONLINE
UNDOTBS2 _SYSSMU36$ ONLINE
UNDOTBS2 _SYSSMU37$ ONLINE
UNDOTBS2 _SYSSMU38$ ONLINE
UNDOTBS2 _SYSSMU39$ ONLINE
UNDOTBS2 _SYSSMU40$ ONLINE
UNDOTBS2 _SYSSMU41$ ONLINE
UNDOTBS2 _SYSSMU42$ ONLINE
UNDOTBS2 _SYSSMU43$ ONLINE
------------------------------ ------------------------------ ---------------
UNDOTBS1 _SYSSMU33$ OFFLINE
UNDOTBS2 _SYSSMU34$ ONLINE
UNDOTBS2 _SYSSMU35$ ONLINE
UNDOTBS2 _SYSSMU36$ ONLINE
UNDOTBS2 _SYSSMU37$ ONLINE
UNDOTBS2 _SYSSMU38$ ONLINE
UNDOTBS2 _SYSSMU39$ ONLINE
UNDOTBS2 _SYSSMU40$ ONLINE
UNDOTBS2 _SYSSMU41$ ONLINE
UNDOTBS2 _SYSSMU42$ ONLINE
UNDOTBS2 _SYSSMU43$ ONLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ---------------
UNDOTBS2 _SYSSMU44$ ONLINE
UNDOTBS2 _SYSSMU45$ ONLINE
UNDOTBS2 _SYSSMU46$ ONLINE
UNDOTBS2 _SYSSMU47$ ONLINE
UNDOTBS2 _SYSSMU48$ ONLINE
UNDOTBS2 _SYSSMU49$ ONLINE
UNDOTBS2 _SYSSMU50$ ONLINE
UNDOTBS2 _SYSSMU51$ ONLINE
UNDOTBS2 _SYSSMU52$ ONLINE
UNDOTBS2 _SYSSMU53$ ONLINE
UNDOTBS2 _SYSSMU54$ ONLINE
------------------------------ ------------------------------ ---------------
UNDOTBS2 _SYSSMU44$ ONLINE
UNDOTBS2 _SYSSMU45$ ONLINE
UNDOTBS2 _SYSSMU46$ ONLINE
UNDOTBS2 _SYSSMU47$ ONLINE
UNDOTBS2 _SYSSMU48$ ONLINE
UNDOTBS2 _SYSSMU49$ ONLINE
UNDOTBS2 _SYSSMU50$ ONLINE
UNDOTBS2 _SYSSMU51$ ONLINE
UNDOTBS2 _SYSSMU52$ ONLINE
UNDOTBS2 _SYSSMU53$ ONLINE
UNDOTBS2 _SYSSMU54$ ONLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ---------------
UNDOTBS2 _SYSSMU55$ ONLINE
UNDOTBS2 _SYSSMU56$ ONLINE
UNDOTBS2 _SYSSMU57$ ONLINE
UNDOTBS2 _SYSSMU58$ ONLINE
------------------------------ ------------------------------ ---------------
UNDOTBS2 _SYSSMU55$ ONLINE
UNDOTBS2 _SYSSMU56$ ONLINE
UNDOTBS2 _SYSSMU57$ ONLINE
UNDOTBS2 _SYSSMU58$ ONLINE
48 rows selected.
SYS AS SYSDBA >
如上：undotbs1表空間的segment_name: _SYSSMU12$還處於online狀態，再查多次
SYS AS SYSDBA >select tablespace_name,segment_name,status from dba_rollback_segs;
同時：
[oracle@localhost ~]$ ps -ef | grep ora_
oracle 713 24762 0 20:27 pts/5 00:00:00 grep ora_
oracle 24180 1 0 19:36 ? 00:00:00 ora_pmon_ora10g
oracle 24182 1 0 19:36 ? 00:00:00 ora_psp0_ora10g
oracle 24184 1 0 19:36 ? 00:00:00 ora_mman_ora10g
oracle 24186 1 1 19:36 ? 00:00:33 ora_dbw0_ora10g
oracle 24188 1 1 19:36 ? 00:00:32 ora_dbw1_ora10g
oracle 24190 1 0 19:36 ? 00:00:07 ora_lgwr_ora10g
oracle 24192 1 0 19:36 ? 00:00:00 ora_ckpt_ora10g
oracle 24194 1 1 19:36 ? 00:00:50 ora_smon_ora10g
oracle 24196 1 0 19:36 ? 00:00:00 ora_reco_ora10g
oracle 24198 1 0 19:36 ? 00:00:00 ora_cjq0_ora10g
oracle 24200 1 0 19:36 ? 00:00:00 ora_mmon_ora10g
oracle 24202 1 0 19:36 ? 00:00:00 ora_mmnl_ora10g
oracle 24215 1 0 19:36 ? 00:00:18 ora_p000_ora10g
oracle 24217 1 0 19:36 ? 00:00:08 ora_p001_ora10g
oracle 24219 1 0 19:36 ? 00:00:04 ora_p002_ora10g
oracle 24221 1 0 19:36 ? 00:00:03 ora_p003_ora10g
oracle 24223 1 0 19:36 ? 00:00:09 ora_p004_ora10g
oracle 24225 1 0 19:36 ? 00:00:04 ora_p005_ora10g
oracle 24227 1 0 19:36 ? 00:00:05 ora_p006_ora10g
oracle 24229 1 0 19:36 ? 00:00:04 ora_p007_ora10g
oracle 24231 1 0 19:36 ? 00:00:09 ora_p008_ora10g
oracle 24233 1 0 19:36 ? 00:00:08 ora_p009_ora10g
oracle 24235 1 0 19:36 ? 00:00:04 ora_p010_ora10g
oracle 24237 1 0 19:36 ? 00:00:04 ora_p011_ora10g
oracle 24239 1 0 19:36 ? 00:00:07 ora_p012_ora10g
oracle 24241 1 0 19:36 ? 00:00:03 ora_p013_ora10g
oracle 24243 1 0 19:36 ? 00:00:06 ora_p014_ora10g
oracle 24404 1 0 19:38 ? 00:00:06 ora_p015_ora10g
oracle 24406 1 0 19:38 ? 00:00:08 ora_p016_ora10g
oracle 24408 1 0 19:38 ? 00:00:02 ora_p017_ora10g
oracle 24410 1 0 19:38 ? 00:00:04 ora_p018_ora10g
oracle 24412 1 0 19:38 ? 00:00:07 ora_p019_ora10g
oracle 24414 1 0 19:38 ? 00:00:09 ora_p020_ora10g
oracle 24416 1 0 19:38 ? 00:00:04 ora_p021_ora10g
oracle 24418 1 0 19:38 ? 00:00:03 ora_p022_ora10g
oracle 24420 1 0 19:38 ? 00:00:05 ora_p023_ora10g
oracle 24422 1 0 19:38 ? 00:00:07 ora_p024_ora10g
oracle 24426 1 0 19:38 ? 00:00:05 ora_p025_ora10g
oracle 24428 1 0 19:38 ? 00:00:04 ora_p026_ora10g
oracle 24430 1 0 19:38 ? 00:00:07 ora_p027_ora10g
oracle 24432 1 0 19:38 ? 00:00:00 ora_qmnc_ora10g
oracle 24434 1 0 19:38 ? 00:00:04 ora_p028_ora10g
oracle 24436 1 0 19:38 ? 00:00:04 ora_p029_ora10g
oracle 24438 1 0 19:38 ? 00:00:07 ora_p030_ora10g
oracle 24440 1 0 19:38 ? 00:00:11 ora_p031_ora10g
oracle 24466 1 0 19:38 ? 00:00:00 ora_q000_ora10g
oracle 24468 1 0 19:38 ? 00:00:00 ora_q001_ora10g
[oracle@localhost ~]$
可以看到oracle很多並行程式，到資料庫檢視
select * from v$process where spid in('24412','24414','24416','24418')
select * from v$session where paddr in('00000000BDBBC820','00000000BDBBD7F0','00000000BDBBD008','00000000BDBBDFD8')
select * from v$sqlarea where sql_id='4gd6b1r53yt88'
[oracle@localhost ~]$ ps -ef | grep ora_
oracle 713 24762 0 20:27 pts/5 00:00:00 grep ora_
oracle 24180 1 0 19:36 ? 00:00:00 ora_pmon_ora10g
oracle 24182 1 0 19:36 ? 00:00:00 ora_psp0_ora10g
oracle 24184 1 0 19:36 ? 00:00:00 ora_mman_ora10g
oracle 24186 1 1 19:36 ? 00:00:33 ora_dbw0_ora10g
oracle 24188 1 1 19:36 ? 00:00:32 ora_dbw1_ora10g
oracle 24190 1 0 19:36 ? 00:00:07 ora_lgwr_ora10g
oracle 24192 1 0 19:36 ? 00:00:00 ora_ckpt_ora10g
oracle 24194 1 1 19:36 ? 00:00:50 ora_smon_ora10g
oracle 24196 1 0 19:36 ? 00:00:00 ora_reco_ora10g
oracle 24198 1 0 19:36 ? 00:00:00 ora_cjq0_ora10g
oracle 24200 1 0 19:36 ? 00:00:00 ora_mmon_ora10g
oracle 24202 1 0 19:36 ? 00:00:00 ora_mmnl_ora10g
oracle 24215 1 0 19:36 ? 00:00:18 ora_p000_ora10g
oracle 24217 1 0 19:36 ? 00:00:08 ora_p001_ora10g
oracle 24219 1 0 19:36 ? 00:00:04 ora_p002_ora10g
oracle 24221 1 0 19:36 ? 00:00:03 ora_p003_ora10g
oracle 24223 1 0 19:36 ? 00:00:09 ora_p004_ora10g
oracle 24225 1 0 19:36 ? 00:00:04 ora_p005_ora10g
oracle 24227 1 0 19:36 ? 00:00:05 ora_p006_ora10g
oracle 24229 1 0 19:36 ? 00:00:04 ora_p007_ora10g
oracle 24231 1 0 19:36 ? 00:00:09 ora_p008_ora10g
oracle 24233 1 0 19:36 ? 00:00:08 ora_p009_ora10g
oracle 24235 1 0 19:36 ? 00:00:04 ora_p010_ora10g
oracle 24237 1 0 19:36 ? 00:00:04 ora_p011_ora10g
oracle 24239 1 0 19:36 ? 00:00:07 ora_p012_ora10g
oracle 24241 1 0 19:36 ? 00:00:03 ora_p013_ora10g
oracle 24243 1 0 19:36 ? 00:00:06 ora_p014_ora10g
oracle 24404 1 0 19:38 ? 00:00:06 ora_p015_ora10g
oracle 24406 1 0 19:38 ? 00:00:08 ora_p016_ora10g
oracle 24408 1 0 19:38 ? 00:00:02 ora_p017_ora10g
oracle 24410 1 0 19:38 ? 00:00:04 ora_p018_ora10g
oracle 24412 1 0 19:38 ? 00:00:07 ora_p019_ora10g
oracle 24414 1 0 19:38 ? 00:00:09 ora_p020_ora10g
oracle 24416 1 0 19:38 ? 00:00:04 ora_p021_ora10g
oracle 24418 1 0 19:38 ? 00:00:03 ora_p022_ora10g
oracle 24420 1 0 19:38 ? 00:00:05 ora_p023_ora10g
oracle 24422 1 0 19:38 ? 00:00:07 ora_p024_ora10g
oracle 24426 1 0 19:38 ? 00:00:05 ora_p025_ora10g
oracle 24428 1 0 19:38 ? 00:00:04 ora_p026_ora10g
oracle 24430 1 0 19:38 ? 00:00:07 ora_p027_ora10g
oracle 24432 1 0 19:38 ? 00:00:00 ora_qmnc_ora10g
oracle 24434 1 0 19:38 ? 00:00:04 ora_p028_ora10g
oracle 24436 1 0 19:38 ? 00:00:04 ora_p029_ora10g
oracle 24438 1 0 19:38 ? 00:00:07 ora_p030_ora10g
oracle 24440 1 0 19:38 ? 00:00:11 ora_p031_ora10g
oracle 24466 1 0 19:38 ? 00:00:00 ora_q000_ora10g
oracle 24468 1 0 19:38 ? 00:00:00 ora_q001_ora10g
[oracle@localhost ~]$
可以看到oracle很多並行程式，到資料庫檢視
select * from v$process where spid in('24412','24414','24416','24418')
select * from v$session where paddr in('00000000BDBBC820','00000000BDBBD7F0','00000000BDBBD008','00000000BDBBDFD8')
select * from v$sqlarea where sql_id='4gd6b1r53yt88'
其中查到backgroud程式在recover恢復資料庫
Deq: Txn Recovery
證明undo裡面還有前滾重做redo所需要的undo回滾資料，所以UNDOTBS1的_SYSSMU12$ 段一直處於online狀態，經過多次查詢，半數小時過後
UNDOTBS1的_SYSSMU12$ 段終於處於offline狀態，此時可以刪除表空間undotbs1及其磁碟檔案，oracle的並行backgroud恢復程式也消失了
[oracle@localhost ~]$ ps -ef | grep ora_
oracle 3086 24762 0 20:40 pts/5 00:00:00 grep ora_
oracle 24180 1 0 19:36 ? 00:00:00 ora_pmon_ora10g
oracle 24182 1 0 19:36 ? 00:00:00 ora_psp0_ora10g
oracle 24184 1 0 19:36 ? 00:00:00 ora_mman_ora10g
oracle 24186 1 0 19:36 ? 00:00:35 ora_dbw0_ora10g
oracle 24188 1 0 19:36 ? 00:00:33 ora_dbw1_ora10g
oracle 24190 1 0 19:36 ? 00:00:08 ora_lgwr_ora10g
oracle 24192 1 0 19:36 ? 00:00:00 ora_ckpt_ora10g
oracle 24194 1 1 19:36 ? 00:00:50 ora_smon_ora10g
oracle 24196 1 0 19:36 ? 00:00:00 ora_reco_ora10g
oracle 24198 1 0 19:36 ? 00:00:00 ora_cjq0_ora10g
oracle 24200 1 0 19:36 ? 00:00:00 ora_mmon_ora10g
oracle 24202 1 0 19:36 ? 00:00:00 ora_mmnl_ora10g
oracle 24432 1 0 19:38 ? 00:00:00 ora_qmnc_ora10g
oracle 24466 1 0 19:38 ? 00:00:00 ora_q000_ora10g
oracle 24468 1 0 19:38 ? 00:00:00 ora_q001_ora10g
[oracle@localhost ~]$
Deq: Txn Recovery
證明undo裡面還有前滾重做redo所需要的undo回滾資料，所以UNDOTBS1的_SYSSMU12$ 段一直處於online狀態，經過多次查詢，半數小時過後
UNDOTBS1的_SYSSMU12$ 段終於處於offline狀態，此時可以刪除表空間undotbs1及其磁碟檔案，oracle的並行backgroud恢復程式也消失了
[oracle@localhost ~]$ ps -ef | grep ora_
oracle 3086 24762 0 20:40 pts/5 00:00:00 grep ora_
oracle 24180 1 0 19:36 ? 00:00:00 ora_pmon_ora10g
oracle 24182 1 0 19:36 ? 00:00:00 ora_psp0_ora10g
oracle 24184 1 0 19:36 ? 00:00:00 ora_mman_ora10g
oracle 24186 1 0 19:36 ? 00:00:35 ora_dbw0_ora10g
oracle 24188 1 0 19:36 ? 00:00:33 ora_dbw1_ora10g
oracle 24190 1 0 19:36 ? 00:00:08 ora_lgwr_ora10g
oracle 24192 1 0 19:36 ? 00:00:00 ora_ckpt_ora10g
oracle 24194 1 1 19:36 ? 00:00:50 ora_smon_ora10g
oracle 24196 1 0 19:36 ? 00:00:00 ora_reco_ora10g
oracle 24198 1 0 19:36 ? 00:00:00 ora_cjq0_ora10g
oracle 24200 1 0 19:36 ? 00:00:00 ora_mmon_ora10g
oracle 24202 1 0 19:36 ? 00:00:00 ora_mmnl_ora10g
oracle 24432 1 0 19:38 ? 00:00:00 ora_qmnc_ora10g
oracle 24466 1 0 19:38 ? 00:00:00 ora_q000_ora10g
oracle 24468 1 0 19:38 ? 00:00:00 ora_q001_ora10g
[oracle@localhost ~]$
SYS AS SYSDBA >drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
SYS AS SYSDBA >
[oracle@localhost ~]$ ll /oraundo
total 16
drwx------ 2 oracle oinstall 16384 Mar 14 11:00 lost+found
[oracle@localhost ~]$
total 16
drwx------ 2 oracle oinstall 16384 Mar 14 11:00 lost+found
[oracle@localhost ~]$
磁碟上的undotbs01檔案也已刪除掉
在等待UNDOTBS1的_SYSSMU12$ 段offline的過程中，做了一個測試
begin
for i in 1..10000000 loop
insert into test values(i);
end loop;
end;
/
begin
for i in 1..10000000 loop
insert into test values(i);
end loop;
end;
/
注意用toad觀察undo表空間undotbs1和undotbs2結果，undotbs2的空間使用率一直在增長，且undotbs1
的空間沒見增長，可以斷定，undo表空間改變已經生效，且新的所有事物undo資料都寫進了undotbs2上
的空間沒見增長，可以斷定，undo表空間改變已經生效，且新的所有事物undo資料都寫進了undotbs2上
[oracle@localhost oraundo]$ ll /oraundo/
total 16
drwx------ 2 oracle oinstall 16384 Mar 14 11:00 lost+found
[oracle@localhost oraundo]$
[root@localhost oraundo]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 291G 56G 221G 21% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda5 19G 773M 17G 5% /oraredo
/dev/sda6 19G 18G 0 100% /oraundo
/dev/sda7 56G 42G 11G 80% /oracle
/dev/sda8 459G 24G 412G 6% /oradatab
/dev/sda9 926G 159G 720G 19% /oradataa
[root@localhost oraundo]# umount /dev/sda6
umount: /oraundo: device is busy
umount: /oraundo: device is busy
[root@localhost oraundo]# umount /dev/sda6 /oraundo
umount: /oraundo: device is busy
umount: /oraundo: device is busy
umount: /oraundo: device is busy
umount: /oraundo: device is busy
total 16
drwx------ 2 oracle oinstall 16384 Mar 14 11:00 lost+found
[oracle@localhost oraundo]$
[root@localhost oraundo]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 291G 56G 221G 21% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda5 19G 773M 17G 5% /oraredo
/dev/sda6 19G 18G 0 100% /oraundo
/dev/sda7 56G 42G 11G 80% /oracle
/dev/sda8 459G 24G 412G 6% /oradatab
/dev/sda9 926G 159G 720G 19% /oradataa
[root@localhost oraundo]# umount /dev/sda6
umount: /oraundo: device is busy
umount: /oraundo: device is busy
[root@localhost oraundo]# umount /dev/sda6 /oraundo
umount: /oraundo: device is busy
umount: /oraundo: device is busy
umount: /oraundo: device is busy
umount: /oraundo: device is busy
不知什麼原因，/oraundo下已無檔案，但其使用情況依然是100%
重啟資料庫：
[oracle@localhost ~]$ sqlplus /nolog
重啟資料庫：
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jul 29 20:55:15 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
>conn / as sysdba
Connected to an idle instance.
SYS AS SYSDBA >startup
ORACLE instance started.
Connected to an idle instance.
SYS AS SYSDBA >startup
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 2084264 bytes
Variable Size 352322136 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SYS AS SYSDBA >
Fixed Size 2084264 bytes
Variable Size 352322136 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SYS AS SYSDBA >
[root@localhost oraundo]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 291G 56G 221G 21% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda5 19G 773M 17G 5% /oraredo
/dev/sda6 19G 173M 18G 1% /oraundo
/dev/sda7 56G 42G 11G 80% /oracle
/dev/sda8 459G 24G 412G 6% /oradatab
/dev/sda9 926G 159G 720G 19% /oradataa
[root@localhost oraundo]#
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 291G 56G 221G 21% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda5 19G 773M 17G 5% /oraredo
/dev/sda6 19G 173M 18G 1% /oraundo
/dev/sda7 56G 42G 11G 80% /oracle
/dev/sda8 459G 24G 412G 6% /oradatab
/dev/sda9 926G 159G 720G 19% /oradataa
[root@localhost oraundo]#
磁碟空間顯示正常
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16400082/viewspace-767727/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- undo 表空間滿了的處理方法
- Oracle undo表空間爆滿的處理方法Oracle
- undo表空間故障處理
- UNDO表空間損壞的處理
- sysaux 表空間爆滿處理方法UX
- MySQL 磁碟空間滿導致表空間相關資料檔案損壞故障處理MySql
- 處理TEMP表空間滿的問題
- oracle中undo表空間丟失處理方法Oracle
- undo表空間損壞的處理過程
- Oracle查詢表佔磁碟空間大小及移動表空間Oracle
- Oracle undo表空間爆滿的解決Oracle
- oracle undo 表空間Oracle
- 理解UNDO表空間
- oracle sysaux表空間滿了處理辦法OracleUX
- Oracle的temp表空間被佔滿Oracle
- oracle的還原表空間UNDO寫滿磁碟空間，解決該問題的具體步驟Oracle
- Linux磁碟空間佔滿問題快速排雷Linux
- 【UNDO】使用重建UNDO表空間方法解決UNDO表空間過大問題
- oracle UNDO表空間一個bug——undo表空間快速擴充套件Oracle套件
- 自動undo表空間模式下切換新的undo表空間模式
- Oracle undo 表空間管理Oracle
- oracle重建UNDO表空間Oracle
- oracle undo表空間管理Oracle
- undo表空間總結
- Shell磁碟空間和表空間告警程式
- 檢視佔用磁碟空間的程式
- MySQL ibdata1撐爆佔滿磁碟空間MySql
- ORACLE 中undo表空間爆滿的解決方法Oracle
- 搬運工：temp表空間被過多佔用處理方法
- MySQL InnoDB Undo表空間配置MySql
- AWR佔用sysaux表空間太大UX
- linux檢視mysql佔用磁碟空間LinuxMySql
- 伺服器磁碟空間滿了伺服器
- undo表空間滿導致的ogg discard檔案寫滿
- oracle查詢表空間的空間佔用情況Oracle
- 一次臨時表空間大量佔用問題的處理
- ORACLE線上切換undo表空間Oracle
- UNDO表空間不足解決方法