Menu Bar

Tuesday, October 10, 2023

CRS

 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