ASM

Adding new disk to ASM diskgroup

Adding a disk to an ASM diskgroup is really simple, just an alter command. But when if you are doing this in a production database, then before adding we have to make sure that the disk is healthy. We...

Shell script to monitor asm diskgroup usage

REQUIREMENT: Write a shell script, which will trigger a mail alert, if the utilization of the asm diskgroup reached 90 percent. SOLUTION: 1. Below is the shell script. Make sure to update ORACLE_HOME,...

Install grid infrastructure 12c on standalone server

Grid installation on the standalone database server is also known as oracle Restart. This is required if you wish you use ASM file system with oracle restart feature. Oracle Restart Means, During any ...

Asmcmd new features in oracle 12c

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 ...

Move datafile from file system to ASM disk in 11g

      PROBLEM: One of the junior DBA mistakenly created a datafile in local filesystem instead of ASM disk group in RAC database 11g. But he is quick to realize his mistake. Below steps need to be ...

Copy asm file from one server to another server

Copying file between mount points between different servers is straight forward and can be done using scp or ftp command. But transfering file between asm diskgroups of different servers  will be...

ORA-15235: diskgroup mount mode conflicts with existing mount

 PROBLEM: While mounting a diskgroup in restrict mode, got below error:   SQL> alter diskgroup NEWTST mount restricted; alter diskgroup NEWTST mount restricted * ERROR at line 1: ORA-15032: n...

ORA-15027: active use of diskgroup precludes its dismount

       While dismounting a diskgroup, got the below error:   SQL> alter diskgroup NEWTST dismount; alter diskgroup NEWTST dismount * ERROR at line 1: ORA-15032: not all alterations perform...

How to rename ASM diskgroup with RAC database

         Below are the steps for renaming an ASM diskgroup with database files present inside for a running database.   EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEW...

ORA-15032: not all alterations performed

                    While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12....