How to free space from an ASM diskgroup? (Doc ID 1553744.1)
How to free space from an ASM diskgroup? (Doc ID 1553744.1)
Applies to:Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.1 [Release 11.1 to 12.1]Information in this document applies to any platform. SymptomsYou need to take free space from an ASM diskgroup and move it to another host or another diskgroup on the same host. All of the disks are currently used. Cause
You have allocated LUNs for a DISKGROUP but have not used all the space in that diskgroup and would like to move some of the space to another host or another diskgroup on the same server. Example:
Disk Group Sector Block Allocation
Name Size Size Unit Size State Type Total Size (MB) Used Size (MB) Pct. Used -------------------- ------- ------- ------------ ----------- ------ --------------- -------------- --------- DATADG_02 512 4,096 1,048,576 MOUNTED EXTERN 3,112,780 1,446,038 46.45 FRADG_02 512 4,096 1,048,576 MOUNTED EXTERN 344,001 18,006 5.23 --------------- -------------- Grand Total: 3,456,781 1,464,044
NAME PATH GROUP_NUMBER OS_MB TOTAL_MB FREE_MB
------------------ ---------------------- ------------ ---------- ---------- ---------- DATADG_02_0000 /dev/rdsk/emcpower89g 1 155639 155639 83343 DATADG_02_0001 /dev/rdsk/emcpower90g 1 155639 155639 83329 DATADG_02_0002 /dev/rdsk/emcpower91g 1 155639 155639 83323 DATADG_02_0003 /dev/rdsk/emcpower92g 1 155639 155639 83331 DATADG_02_0004 /dev/rdsk/emcpower93g 1 155639 155639 83340 DATADG_02_0005 /dev/rdsk/emcpower94g 1 155639 155639 83343 DATADG_02_0006 /dev/rdsk/emcpower95g 1 155639 155639 83334 DATADG_02_0007 /dev/rdsk/emcpower96g 1 155639 155639 83341 DATADG_02_0008 /dev/rdsk/emcpower97g 1 155639 155639 83338 DATADG_02_0009 /dev/rdsk/emcpower98g 1 155639 155639 83341 DATADG_02_0010 /dev/rdsk/emcpower87g 1 155639 155639 83336 NAME PATH GROUP_NUMBER OS_MB TOTAL_MB FREE_MB ------------------ ---------------------- ------------ ---------- ---------- ---------- DATADG_02_0011 /dev/rdsk/emcpower79g 1 155639 155639 83344 DATADG_02_0012 /dev/rdsk/emcpower78g 1 155639 155639 83342 DATADG_02_0013 /dev/rdsk/emcpower77g 1 155639 155639 83320 DATADG_02_0014 /dev/rdsk/emcpower76g 1 155639 155639 83326 DATADG_02_0015 /dev/rdsk/emcpower75g 1 155639 155639 83352 DATADG_02_0016 /dev/rdsk/emcpower74g 1 155639 155639 83345 DATADG_02_0017 /dev/rdsk/emcpower73g 1 155639 155639 83333 DATADG_02_0018 /dev/rdsk/emcpower72g 1 155639 155639 83340 DATADG_02_0019 /dev/rdsk/emcpower88g 1 155639 155639 83341
Solution
ASM load balances file activity by uniformly distributing file extents across all disks in a diskgroup.
Dropping an oracle ASM disk and releasing underlying LUNs after rebalance went through is the correct approach to downsize free space in a diskgroup.
Below are detailed steps how to drop an oracle ASM disk. This example drops DATA3 from diskgroup dgroup1.
ALTER DISKGROUP dgroup1 DROP DISK DATA3;
select sofar "AUs moved So Far", est_work "Aprox AU's to be moved"
from v$asm_operation where group_number = *** disk group number ***;
IMPORTANT: DO NOT inadvertently remove the disk unit physically from the storage array BEFORE it is completely dropped from the diskgroup.
When a disk is dropped, it is not immediately expelled from the diskgroup. Verify that the HEADER_STATUS from the V$ASM_DISK view shows FORMER status, not DROPPING. Additionally, check to make sure that the rebalance operation from the DROP DISK is completed. Disks that belong to a disk group, that is, disks that have a disk group name in the disk header, show a header status of MEMBER. Disks that were discovered, but that have not yet been assigned to a disk group, have a status of either CANDIDATE or PROVISIONED. Disks that previously belonged to a disk group and were dropped cleanly from the disk group have a status of FORMER. For IGNORED disks, it means there may be some duplicate disk paths pointing to the same physical disk. To fix this, we need to remove the duplicate disk paths or revoke the access to the duplicate disk paths. ASM should only see one disk path for each physical device. ReferencesNOTE:270066.1 - Manage ASM instance-creating diskgroup,adding/dropping/resizing disks.NOTE:265633.1 - ASM Technical Best Practices For 10g and 11gR1 Release NOTE:402526.1 - Asm Devices Are Still Held Open After Dismount or Drop NOTE:1306574.1 - ASM 11.2.0.2 Is Not Releasing File Descriptors After Drop or Dismount Diskgroup. |
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1442647/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- ORA-15041 IN A DISKGROUP ALTHOUGH FREE_MB REPORTS SUFFICIENT SPACE
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- ASM磁碟空間假裝耗盡,ORA-15041: diskgroup space exhaustedASM
- 【CURSOR】How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)ASMWhile
- 聊聊dba_temp_free_space的allocated_space和free_space
- How to redirect to a specific web page after sign out from Entra IDWeb
- Oracle 最新PSU (Doc ID 2118136.2)Oracle
- linux vdo驗證 oracle asm diskgroup sector_size 4096 udev asmlibLinuxOracleASMdev
- expdp/impdp變慢 (Doc ID 2469587.1)
- Reading and Understanding Systemstate Dumps (Doc ID 423153.1)
- How To Turn SNMP On/Off ? [ID 472530.1]
- RMAN -- Frequently Asked Question (FAQ) (Doc ID 469777.1)
- Oracle 下載最新psu (Doc ID 2118136.2)Oracle
- how to move a MediaWiki wiki from one server to anotherServer
- How to prevent your jar packages from being decompiled?JARPackageCompile
- How To Copy Any Text To Clipboard From Terminal In UbuntuUbuntu
- cannot reclaim 52428800 bytes disk space from 4070572032 limitAIMIT
- 關於Oracle dba_free_space 檢視的研究Oracle
- Linux 6.9 加盤後的Oracle 12c ASM DiskGroup配置過程LinuxOracleASM
- PRCT-1011 : Failed to run "oifcfg" (Doc ID 1380183.1)AI
- [轉帖]Release Schedule of Current Database Releases (Doc ID 742060.1)Database
- What is OPAQUE_TRANSFORM Hint and how to Control it [ID 780503.1]OpaqueORM
- ImportError: cannot import name 'get_ora_doc' from partially initialized moduleImportErrorZed
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- oracle11g: Scheduler Maintenance Tasks or Autotasks (Doc ID 756734.1)OracleAINaN
- 【DBA】Relinking Oracle Home 常見問題 (Doc ID 2048232.1)Oracle
- 11g-Reduce Transportable Tablespace Downtime using XTTS (Doc ID 1389592.1)TTS
- [20201110]How to get the Data Guard broker configuration from a SQL query.txtSQL
- Static and Animated 3D Scene Generation from Free-form Text Descriptions3DORM
- Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1)GoOracleAI
- diskgroup "DATADG" cannot be mounted
- ASM DG Usable_file_MB和Req_mir_free_MB的含義ASM
- 12c DG新特性 - Active Data Guard Far Sync (Doc ID 2179719.1)
- 【GRID】Grid Infrastructure 啟動的五大問題 (Doc ID 1526147.1)ASTStruct
- 【DATAGUARD】Data Guard 12C 新特性:Far Sync Standby (Doc ID 2179719.1)
- ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors (Doc ID 2165402.1)PackageError