ASM_POWER_LIMIT specifies the disk rebalancing speed of the ASM instance. The higher the limit, the faster rebalancing operation, but consume lot of CPU. Lower values will take longer, but consume few...

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

This article explains the steps for multiplexing redologs in oracle RAC. Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to that of multiplexing in standal...

CRSCTL Utility is used to managed oracle clusterware resources and components. 1. STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs 2. Enable/D...

It is always recommended to create database in RAC using DBCA only (GUI) . But for some reason, if  you want to create manually, then follow below steps: In this article , we will create a database i...

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

              If you wish to change the scan listener port post installation, then follow below steps. Here we will change the port from 1522 to 1523. 1. Check the scan listener configuration $...

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

  Below are the steps for dropping database in Oracle RAC.   1. Make cluster database to FALSE SQL> alter system set cluster_database=FALSE scope=spfile sid='*'; System altered. 2. Stop the d...

            Follow below steps for enabling archive log mode in oracle RAC. 1. stop the database service. srvctl stop database -d DBACLASS 2. start the database in mount state. srvctl start data...