Category: ORACLE RAC

Multiplex Redolog In Oracle RAC

Being an Oracle DBA in the initial year of our we work on the standalone database. In the world of backup, we work on multiplexing of the redo log. But as in single instance database is different from RAC environment. Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to […]

Read More →

Steps to add diskgroup in ASM

We know what is ASM in Oracle. Today we have look on diskgroups. In this article we have discussed the technical definition on ASM  diskgroup in first two paragraphs after that we have the steps which we use to add ASM diskgroup The main components of ASM are diskgroups, each of which comprises of several physical […]

Read More →

Oracleasm Utility For ASMLIB

In this article, we are going to have look on Oracleasm Utility For ASMLIB.These lines explain the technical definition of Oracleasm The oracleasm command utility is part of the Oracle ASMLib, and you only use oracleasm commands when you want Oracle ASMLib to be able to access your ASM disks. Oracle notes that the ASMLib is an […]

Read More →

Drop a Oracle RAC Database

I am demonstrating how we can drop the database in RAC environment manually in Oracle12c(12.1.0.2.0) version. I have two node RAC and the database name is TEST.  The instance names are TEST1 & TEST2. Verify the instance

2. Stop the entire cluster environment

3. Start only one instance to edit the cluster_database parameter to […]

Read More →

Multiplex control file in 11gR2 RAC ASM

After creating 11gR2 RAC database, we wanted to enable multiplexing for the control files. Oracle recommends multiplexing the control files . We are using ASM for the storage of control files. At the time of creating the database by dbca we can do multiplexing or we can also do later manually as described below. Goal:- […]

Read More →

An Introduction of Virtualization in Oracle RAC

To provide best solutions to business issues in any organization has to set up its infrastructure. In the world of technology, business focus on it’s better setup of IT departments. Day by day new technology introduces by the champions of IT. New requirements of clients demand new technology as soon as possible. For providing better services organizations […]

Read More →

Background Processes in Oracle ASM

Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas the RDBMS instance processes begin with ora. On Unix, the ASM processes can be listed using the following command: ps […]

Read More →

Background Processes in Oracle RAC

Oracle RAC Background Processes Image Source The GCS and GES processes, and the GRD collaborate to enable Cache Fusion. The Oracle RAC processes and their identifiers are as follows: 1. ACMS: Atomic Controlfile to Memory Service (ACMS) In an Oracle RAC environment, the ACMS per-instance process is an agent that contributes to ensuring a distributed […]

Read More →

RAC : 11gR2 Clusterware Startup Sequence

Here is the brief explanation that how the clusterware brings up step by step . 1. When a node of an Oracle Clusterware cluster start/restarts, OHASD is started by platform-specific means. OHASD is the root for bringing up Oracle Clusterware. OHASD has access to the OLR (Oracle Local Registry) stored on the local file system. […]

Read More →

Back Up & Restore an Oracle ASM Password File with pwget Command

In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]

Read More →
← Newer Entries
Older Entries →