RAC

How to move spfile from file system to ASM in RAC

Below are the steps for moving spfile from file system to ASM diskgroup in RAC. database name – ORCL instance_names – ORCL1,ORCL2 oracle DB nodes – dbhstorcl1, dbhstorcl2 1. Check cu...

How to change spfile in Oracle RAC.

If we are changing spfile in oracle RAC, then we need to use additional SID parameter in the alter system command. Here SID is the instance_name. For changing the parameter in both the instances of th...

Oracle local registry(OLR) in RAC

ORACLE LOCAL REGISTRY(OLR) contains node-specific information required by OHASD . Every node has its own dedicated OLR file.(not shared between the nodes). As OCRs files are present in ASM diskgroup, ...

OLSNODES COMMANDS IN RAC

OLSNODES provides information related RAC nodes. 1. List of nodes in the cluster olsnodes prod54-1 prod55-1 2.Nodes with node number olsnodes -n prod54-1 1 prod55-1 2 3.Node with vip olsnodes -i prod5...

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-5c999231cd09a317209251/] 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...

Page 1 of 212
Skip to toolbar