Situation :
While installing GRID s/w I used up all my allocated ASM disk space to create the CRS mount/diskgroup
Now I need to create database and need DATA and RECO disk group , but i'm unable to create it as all the disks are already taken up by CRS mount.
SQL> column diskgroup format a10;
SQL> column disk_name format a10;
SQL> column failgroup format a10;
SQL> select dg.name diskgroup, dk.name disk_name, dk.failgroup, dk.mount_status, dk.mode_status from v$asm_disk dk, v$asm_diskgroup dg where dk.group_number = dg.group_number;
DISKGROUP DISK_NAME FAILGROUP MOUNT_S MODE_ST
---------- ---------- ---------- ------- -------
CRS CRS_0002 CRS_0002 CACHED ONLINE
CRS CRS_0001 CRS_0001 CACHED ONLINE
CRS CRS_0000 CRS_0000 CACHED ONLINE
SQL>
ASMCMD> lsdsk -k
Total_MB Free_MB OS_MB Name Failgroup Failgroup_Type Library Label UDID Product Redund Path
4096 3706 4096 CRS_0000 CRS_0000 REGULAR System UNKNOWN /dev/oracleasm/disks/CRS1
23552 21510 23552 CRS_0001 CRS_0001 REGULAR System UNKNOWN /dev/oracleasm/disks/DATA1
23551 21510 23551 CRS_0002 CRS_0002 REGULAR System UNKNOWN /dev/oracleasm/disks/FRA1
ASMCMD>
ASMCMD>
SQL> SELECT SUBSTR(dg.name,1,16) AS diskgroup, SUBSTR(d.name,1,16) AS asmdisk,
d.mount_status, d.state, SUBSTR(d.failgroup,1,16) AS failgroup
FROM V$ASM_DISKGROUP dg, V$ASM_DISK d WHERE dg.group_number = d.group_number; 2 3
DISKGROUP ASMDISK MOUNT_S STATE FAILGROUP
---------------- ---------------- ------- -------- ----------------
CRS CRS_0002 CACHED NORMAL CRS_0002
CRS CRS_0000 CACHED NORMAL CRS_0000
CRS CRS_0001 CACHED NORMAL CRS_0001
[oracle@oraclelab1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 51199 46726 0 46726 0 Y CRS/
ASMCMD>
AS
SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP;
NAME TYPE TOTAL_MB FREE_MB
------------------------------ ------ ---------- ----------
REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
----------------------- --------------
CRS EXTERN 51199 46726
0 46726
As you can see my all 50GB disk space is used up by CRS.
So lets free it up
lets drop
Name Path
CRS_0000 /dev/oracleasm/disks/CRS1
CRS_0001 /dev/oracleasm/disks/DATA1
CRS_0002 /dev/oracleasm/disks/FRA1
SQL>
alter diskgroup CRS drop disk CRS_0001 rebalance power 5 wait;
ASMCMD shows those disks are freed from ASM.
ASMCMD> lsdsk
Path
/dev/oracleasm/disks/CRS1
/dev/oracleasm/disks/FRA1
ASMCMD> lsdsk --candidate
Path
/dev/oracleasm/disks/DATA1
ASMCMD>
set lines 999;
col diskgroup for a10
col diskname for a12
col path for a30
select a.name DiskGroup,b.name DiskName, b.total_mb,
(b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup
a where a.group_number (+) =b.group_number order by b.group_number,b.name;
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
export ORACLE_HOME=/u01/app/12.1.0.2/grid
export PATH=/u01/app/12.1.0.2/gridbin/
export ORACLE_SID=+ASM2
[grid@testdb1 ~]$ asmcmd
ASMCMD> ls
No comments:
Post a Comment