RAC

How to create ACFS file system in RAC using command line:

ACFS i.e Oracle ASM Cluster File System is cluster file system service used for High availability services. Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS...

ASM_POWER_LIMIT in oracle ASM

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

Multiplex redolog in Oracle RAC

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

Useful CRSCTL commands

CRSCTL Utility is used to managed oracle clusterware resources and components. 1. STOP & START CRS: ( run from root user) [crayon-5beb1be412d5a640922405/] 2. Enable/Disable auto restart of CRS. [c...

Create RAC database manually

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

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

How to modify scan listener port in Oracle RAC

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

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

Drop database in oracle RAC

  Below are the steps for dropping database in Oracle RAC.   1. Make cluster database to FALSE [crayon-5beb1be415624824923148/] 2. Stop the db service [crayon-5beb1be41562b416541138/] 3. start t...

Page 1 of 212
Skip to toolbar