After the core DBA, continue our journey towards RAC environment. Today we are going to explore the steps use for “How to disable and enable archive log in oracle RAC“ Let’s follow the steps. Hopefully, you will feel the difference in RAC. Step1: First we need to stop database instance on node1 using sqlplus. [oracle@rac-node1 […]
Articles Tagged: ORACLE RAC
Recovering OCR using physical backup
Step 1: Identify OCR physical backup using the following command [root@rac1 ~]# ocrconfig -showbackup rac2 2018/04/03 16:57:56 /u01/app/12.1.0/grid/cdata/rac-scan/backup00.ocr 0 rac1 2018/04/01 17:34:19 /u01/app/12.1.0/grid/cdata/rac-scan/backup01.ocr 0 rac1 2018/03/31 13:57:45 /u01/app/12.1.0/grid/cdata/rac-scan/backup02.ocr 0 rac2 2018/04/03 16:57:56 /u01/app/12.1.0/grid/cdata/rac-scan/day.ocr 0 rac1 2018/03/30 14:55:33 /u01/app/12.1.0/grid/cdata/rac-scan/week.ocr 0 Step 2: ocrdump [root@rac1 ~]# ocrdump -backupfile /u01/app/12.1.0/grid/cdata/rac-scan/backup00.ocr Step 3: Bring down all instance and database […]
Evaluation and Prediction in Oracle RAC 12c
In a DBA’s routine, we perform thousands of command every day. Sometimes it also happens we don’t know the post-impact of the command. Then, Oracle 12c Comes up with very powerful feature WHAT IF EVALUATION. It shows us the impact of command without actually performing it. So with help of this our life can become […]
Server Pools in Oracle RAC
Before Release of Oracle Clusterware 11g release 2, we define a specific instance belong to specific node.a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster. And it is pretty well with small no of nodes in your RAC database. But when no of nodes […]
Creating RAC database With PDBS
In this Article we will Create RAC Database with PDBS using DBCA. Step 1 : Once you use dbca , first screen that will open is as below select Create Database and click next: Step 2 : Select Advanced Mode and click Next Step 3 : Select RAC database as database type and Admin Managed […]
vipca error in Oracle RAC
Today we are going to learn about the error occurs in the Oracle RAC environment. Vipca is not opening new configuration window and is giving error [root@node2 bin]# ./vipca Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])] To resolve this issue Perform two steps [root@node2 bin]# ./oifcfg setif -global bond0/192.168.0.0:public [root@node2 bin]# ./oifcfg setif -global eth2/192.168.1.0:cluster_interconnect [root@node2 […]
ORA-27300: OS system dependent operation
In this article, we are going to have a look at ” ORA-27300″. In this article, we are going to learn how to solve this error. Let’s have fun with ORA-27300 During the creation of a new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted. Error Details are ORA-27300: […]
ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION
This is the post for the error “ORA-29702”. ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION Cause: An unexpected error occurred while performing a CGS operation. Action: Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors. ##################################################### ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION ##################################################### […]
Plug Single Instance PDB to RAC CDB
In this article we will Plug Single Instance PDB to RAC CDB. Single Instance CDB Name Single Instance PDB Name RAC Instance CDB RAC Instance Name RAC Node globdb pdb1 CDB1 RAC1 Node1 RAC2 Node2 Step 1 : Check status of Globdb and CDB1 [oracle@rac2 ~]$ srvctl status database -d globdb Instance globdb is running […]
ACFS file system Mount and Dismount Operation
Before we shut down ASM instance it is important to dismount acfs file system , Once it is dismounted all open references to Oracle ASM files are removed . If ACFS file system is active and ASM instance is forcibly shut down , acfs file system will be placed in offline error state.If any file […]