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 […]
Category: ORACLE RAC
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 […]
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 […]
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
1 2 3 |
[oracle@host01 ~]$ srvctl status database -d TEST Instance TEST1 is running on node host01 Instance TEST2 is running on node host02 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
[oracle@host01 ~]$ crsctl status resource -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE host01 STABLE ONLINE ONLINE host02 STABLE ora.LISTENER.lsnr ONLINE ONLINE host01 STABLE ONLINE ONLINE host02 STABLE ora.TEST.dg ONLINE ONLINE host01 STABLE ONLINE ONLINE host02 STABLE ora.asm ONLINE ONLINE host01 Started,STABLE ONLINE ONLINE host02 Started,STABLE ora.net1.network ONLINE ONLINE host01 STABLE ONLINE ONLINE host02 STABLE ora.ons ONLINE ONLINE host01 STABLE ONLINE ONLINE host02 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE host02 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE host01 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE host01 STABLE ora.MGMTLSNR 1 ONLINE ONLINE host01 169.254.59.131 192.1 68.1.101,STABLE ora.cvu 1 ONLINE ONLINE host01 STABLE ora.mgmtdb 1 ONLINE ONLINE host01 Open,STABLE ora.oc4j 1 ONLINE ONLINE host01 STABLE ora.scan1.vip 1 ONLINE ONLINE host02 STABLE ora.scan2.vip 1 ONLINE ONLINE host01 STABLE ora.scan3.vip 1 ONLINE ONLINE host01 STABLE ora.test.db 1 ONLINE ONLINE host01 Open,STABLE 2 ONLINE ONLINE host02 Open,STABLE ora.usben.db 1 ONLINE ONLINE host01 Open,STABLE 2 ONLINE ONLINE host02 Open,STABLE ora.host01.vip 1 ONLINE ONLINE host01 STABLE ora.host02.vip 1 ONLINE ONLINE host02 STABLE -------------------------------------------------------------------------------- |
2. Stop the entire cluster environment
1 2 3 4 |
[oracle@host01 ~]$ srvctl stop database -d TEST [oracle@host01 ~]$ srvctl status database -d TEST Instance TEST1 is not running on node host01 Instance TEST2 is not running on node host02 |
3. Start only one instance to edit the cluster_database parameter to […]
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:- […]
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 […]
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 […]
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 […]
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. […]
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 […]