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 move ASM database files from one diskgroup to anotherASMDatabase
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- [轉]How to release space from databaseDatabase
- Oracle ASM Free Space TableOracleASM
- Script to Report Extents and Contiguous Free Space (Doc ID 162994.1)
- How to release space from database( in other words: resize datafile ) (zt)Database
- How to release space from database( in other words: resize datafile ) 【zt】Database
- How to restore ASM based OCR after complete loss of the CRS diskgroupRESTASM
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- How to copy a datafile from ASM to a file system not using RMANASM
- How To Upgrade ASM from 10.2 to 11.1 (RAC)ASM
- ASM磁碟空間假裝耗盡,ORA-15041: diskgroup space exhaustedASM
- ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS InstanceASM
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- No Response from the Server, Does it Hang or Spin? (Doc ID 68738.1)Server
- Asm diskgroup 的修復ASM
- script of check repair ASM DISKGROUPAIASM
- 一次ASM磁碟空間假裝耗盡 ORA-15041: DISKGROUP SPACE EXHAUSTEDASM
- How To Size the Database Smart Flash Cache (Doc ID 1317950.1)Database
- 給ASM例項增加diskgroupASM
- RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]DatabaseASM
- Duplicate database from non ASM to ASM to a different host [ID 382669.1]DatabaseASM
- How to Find Out How Much Space an Index is UsingIndex
- How To List All The Named Events Set For A Database (Doc ID 436036.1)Database
- RMAN Restore Performance from Tape is Very Poor (Doc ID 850988.1)RESTORM
- ORA-15097 Cannot Shutdown ASM if OCR is Located in ASM (Doc ID 984663.1)ASM
- ASM管理 - 如何重新命名diskgroupASM
- How to Start 11gR2 Grid Infrastrucure in Exclusive Mode (Doc ID 1364971.1)AST
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]ASM
- Using FTP Transferring Non-ASM Datafiles to ASM diskgroupFTPASM
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- Script: To remove Chained Rows from a Table (Doc ID 1019556.6)REMAI
- ASM tools used by Support : KFOD, KFED, AMDU (Doc ID 1485597.1)ASM
- Performing duplicate database with ASM/OMF/RMAN (Doc ID 340848.1)ORMDatabaseASM
- How Indexes Grow and PctfreeIndex
- [doc]How To Efficiently Drop A Table With Many Extents