EXADATA Commands & (ADDING DISK & DELETING DISK)

 IBSWITCH INFO:

-------------------------

ibhosts

ibswitches

LIST DISKS VIA KFOD:

------------------------------------

kfod disks=all dscvgroup=true | grep -i abc3pceladm03 |grep -i datac1
kfod disks=all dscvgroup=true | grep -i abc3pceladm03

 List all Disks via CELLCLI:

-----------------------------------

cellcli -e list griddisk

cellcli -e list griddisk attributes name,asmmodestatus

list griddisk attributes name where asmdeactivationoutcome!='Yes'

cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

cellcli -e list griddisk attributes name,asmmodestatus

[root@abc3pceladm03 log]# cellcli -e LIST GRIDDISK ATTRIBUTES name,asmDiskGroupName,cachingpolicy,size,offset
         DATA1_CD_00_abc3PCELADM03     DATA1          default         6.1015625T              32M
         DATA1_CD_01_abc3PCELADM03     DATA1          default         6.1015625T              32M
         DATA1_CD_02_abc3PCELADM03     DATA1          default         6.1015625T              32M
         DATA1_CD_03_abc3PCELADM03     DATA1          default         6.1015625T              32M
         DATA1_CD_04_abc3PCELADM03     DATA1          default         6.1015625T              32M
         DATA1_CD_05_abc3PCELADM03     DATA1          default         6.1015625T              32M
         DBFS_DG_CD_02_abc3pceladm03    DBFS_DG         default         33.796875G              7.1192474365234375T
         DBFS_DG_CD_03_abc3pceladm03    DBFS_DG         default         33.796875G              7.1192474365234375T

         RREC1_CD_00_abc3pceladm03     RREC1          none            1.01763916015625T       6.1016082763671875T
         RREC1_CD_01_abc3pceladm03     RREC1          none            1.01763916015625T       6.1016082763671875T
         RREC1_CD_02_abc3pceladm03     RREC1          none            1.01763916015625T       6.1016082763671875T
         RREC1_CD_03_abc3pceladm03     RREC1          none            1.01763916015625T       6.1016082763671875T
         RREC1_CD_04_abc3pceladm03     RREC1          none            1.01763916015625T       6.1016082763671875T

LIST DISKS FROM CELLCLI:

list grid disk from cellnode 3:
=>  ssh abc3pceladm03

 CellCLI> list griddisk
         DATAC1_CD_00_ABC3PCELADM03     active
         DATAC1_CD_01_ABC3PCELADM03     active
         DATAC1_CD_02_ABC3PCELADM03     active
         DATAC1_CD_03_ABC3PCELADM03     active

-----------------

Veritas:

======

Backup list command:

bplist -C abcx212cpdb02-bak -t 4 -l -R / 

ASM DISKGROUP SIZE:

=================

set lines 300 pages 999
col COMPATIBILITY for a12
col DATABASE_COMPATIBILITY for a12
col NAME for a12
col state for a9
col type for a9
select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB/1024 "TOTAL GB",FREE_MB/1024 "FREE GB",((TOTAL_MB-FREE_MB)/1024) "USED GB",((total_mb-free_mb)/total_mb)*100 "%Used",OFFLINE_DISKS,COMPATIBILITY,DATABASE_COMPATIBILITY from v$aSQL> sm_diskgroup order by GROUP_NUMBER;

Database creation:

==============================================
DBCA:

nohup $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc
-gdbName RCT  -sid RCT  -SysPassword We1come-SystemPassword We1come$
-emConfiguration NONE -redoLogFileSize 200  
-storageType ASM -asmSysPassword We1come$
-diskGroupName +DATAU1
-RECOVERYGROUPNAME +RECOU1
-characterSet AL32UTF8
-nationalCharacterSet AL32UTF8
-automaticMemoryManagement true
-totalMemory 2048  
-databaseType MULTIPURPOSE
-nodelist abcx212cudbadm01,abcx212cudbadm02 > RCT_creation.log &
============================

CHANGE RE BALANCE FROM 1 to 16:

GROUP_NUMBER OPERA PASS      STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE                                  CON_ID
------------ ----- --------- ---- ---------- ---------- ---------- ---------- ---------- ----------- -------------------------------------------- ----------
           3 REBAL RESYNC    DONE          1          1          0          0          0           0                                          0
           3 REBAL RESILVER  DONE          1          1          0          0          0           0                                          0
           3 REBAL REBALANCE RUN           1          1    2682423    2854811       1225         140                                          0
           3 REBAL COMPACT   WAIT          1          1          0          0          0           0                                          0

SYS@+ASM2> alter diskgroup REDOC1 rebalance power 16 nowait;

Diskgroup altered.

SYS@+ASM2> select * from v$asm_operation;

GROUP_NUMBER OPERA PASS      STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE                                  CON_ID
------------ ----- --------- ---- ---------- ---------- ---------- ---------- ---------- ----------- -------------------------------------------- ----------
           3 REBAL RESYNC    DONE         16         16          0          0          0           0                                          0
           3 REBAL RESILVER  DONE         16         16          0          0          0           0                                          0
           3 REBAL REBALANCE EST          16         16          0          0          0           0                                          0
           3 REBAL COMPACT   WAIT         16         16          0          0          0           0  

Disk repaire time:

===============
 col VALUE for a30;
 col NAME for a20;
 select dg.name,a.value from v$asm_diskgroup dg, v$asm_attribute a where  dg.group_number=a.group_number  and a.name='disk_repair_time';

 
 NAME                 VALUE
-------------------- ------------------------------
DATA1               800h
DB_DG              800h
REDOC1               800h