Let’s have look on New Features in Oracle 12c of ASMCMD. Below are the new features of Oracle 12c version.

 

1. Connecting to ASM instance of remote node:

Now we can connect to asmcmd prompt(asm instance) of remote node from local node.

SYNTAX – asmcmd –inst < REMOTE ASM INSTANCE NAME>

asmcmd --inst +ASM2

2.Move ASM password file using pwmove:

We can move the asm pwfile from one diskgroup to another diskgroup online using pwmove command.

Check the asm pwfile location

$ crsctl stat res ora.asm -p|grep PWFILE
PWFILE=+MGMTDB/orapwASM

$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

Connect to asmcmd and run pwmove command

$echo $ORACLE_HOME
$/crsapp/app/oracle/product/grid12c
echo $ORACLE_SID
+ASM1

$ asmcmd
ASMCMD> pwmove --asm +MGMTDB/orapwASM +B2BWMDB/orapwASM
moving +MGMTDB/orapwASM -> +B2BWMDB/orapwASM

Check the new location.

crsctl stat res ora.asm -p|grep PWFILE
PWFILE=+B2BWMDB/orapwASM

Check the crs status:

$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

We can see cluster components are online during the password movement activity.

3. Rebalance from asmcmd :

Now we can do rebalance of diskgroup from asmcmd prompt also.

To rebalance a diskgroup with power limit of 100

SYNTAX –
rebal –power < POWER_LIMIT> < DISKGROUP_NAME>

ASMCMD> rebal --power 100 B2BWMDB
Rebal on progress.

To monitor the rebalance operation:

ASMCMD> lsop
Group_Name Pass State Power EST_WORK EST_RATE EST_TIME
B2BWMDB COMPACT WAIT 1 0 0 0
B2BWMDB REBALANCE RUN 1 12072 4400 2

4. Miscellaneous asmcmd commands:

Check the patches installed in grid home:

ASMCMD> showpatches

Check asm instance version:

ASMCMD> showversion

Check the cluster mode:

ASMCMD> showclustermode
ASM cluster : Flex mode disabled

Check the cluster state:

ASMCMD> showclusterstate
Normal

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp