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
