Difference between revisions of "ASM"
From dbawiki
(Created page with "===Restart ASM=== /opt/oracle/oak/onecmd/tmp/restartasm.sh <pre> /u01/app/11.2.0.4/grid/bin/crsctl stop res ora.crsd -init /u01/app/11.2.0.4/grid/bin/crsctl stop res ora.asm -...") |
(→Restart ASM) |
||
| Line 13: | Line 13: | ||
fi | fi | ||
/u01/app/11.2.0.4/grid/bin/crsctl start res ora.crsd -init | /u01/app/11.2.0.4/grid/bin/crsctl start res ora.crsd -init | ||
| + | </pre> | ||
| + | ===Check free space in ASM diskgroups=== | ||
| + | cat /opt/oracle/oak/onecmd/tmp/chekDGSpaceSql.sh | ||
| + | <pre> | ||
| + | #! /bin/sh | ||
| + | export ORACLE_HOME=/u01/app/12.1.0.2/grid | ||
| + | export ORACLE_SID=+ASM1 | ||
| + | $ORACLE_HOME/bin/sqlplus '/as sysasm' <<EOF | ||
| + | column path format a40 | ||
| + | column name format a35 | ||
| + | set linesize 200 | ||
| + | select name, total_mb,free_mb from v\$asm_diskgroup; | ||
| + | quit | ||
| + | EOF | ||
| + | </pre> | ||
| + | gives | ||
| + | <pre> | ||
| + | NAME TOTAL_MB FREE_MB | ||
| + | ----------------------------------- ---------- ---------- | ||
| + | RECO 2424000 2379084 | ||
| + | REDO 763120 687700 | ||
| + | DATA 14745600 2930908 | ||
</pre> | </pre> | ||
Revision as of 15:06, 20 January 2017
Restart ASM
/opt/oracle/oak/onecmd/tmp/restartasm.sh
/u01/app/11.2.0.4/grid/bin/crsctl stop res ora.crsd -init /u01/app/11.2.0.4/grid/bin/crsctl stop res ora.asm -init /u01/app/11.2.0.4/grid/bin/crsctl start res ora.asm -init ps -ef | grep -v grep | grep -q smon_+ASM if [ $? -ne 0 ] then echo 'asm instance did not start in 1st attempt, sleeping for 30 secs and retrying' sleep 30 /u01/app/11.2.0.4/grid/bin/crsctl start res ora.asm -init fi /u01/app/11.2.0.4/grid/bin/crsctl start res ora.crsd -init
Check free space in ASM diskgroups
cat /opt/oracle/oak/onecmd/tmp/chekDGSpaceSql.sh
#! /bin/sh export ORACLE_HOME=/u01/app/12.1.0.2/grid export ORACLE_SID=+ASM1 $ORACLE_HOME/bin/sqlplus '/as sysasm' <<EOF column path format a40 column name format a35 set linesize 200 select name, total_mb,free_mb from v\$asm_diskgroup; quit EOF
gives
NAME TOTAL_MB FREE_MB ----------------------------------- ---------- ---------- RECO 2424000 2379084 REDO 763120 687700 DATA 14745600 2930908
