RAC Useful CRSCTL Commands

CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects. Oracle Clusterware 11g release 2 (11.2) introduces cluster-aware commands with which you can perform check, start, and stop operations on the cluster. You can run these commands from any node in the cluster on another node […]

Read More

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

Ways to avoid ORA-01555 snapshot too old error

Being the “Oracle DBA ” when the UNDO topic comes in an interview question. Normally interviewer as an about ORA-01555 snapshot too old error.   We reply about three or four lines as an answer For this question. For strong knowledge, we must have deep knowledge about this. Let’s have look on ORA-01555 snapshot too old error. ORA-01555: snapshot too old: rollback […]

Read More

Tuning the locks of SGA

This post describes some deep knowledge of SGA. LOCK_SGA is used to make sure that the contents from the SGA are not flushed, i.e data from the DB buffer cache not written back to disc. It is like to pin the contents of SGA. SGA_LOCK  locks the entire SGA into physical memory. It is usually advisable to […]

Read More

MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET

Today’s article is about to add some deep knowledge in the Oracle’s database knowledge. We are going to have look at basic elements of Oracle database. This article is most useful for freshers and beneficial for experienced DBAs too.   In Oracle Database we read about MEMORY_TARGET, SGA_TARGET, and PGA_AGGREGATE_TRAGET. Let’s have a technical definition of these teams. […]

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

Steps for Create Standby Database From OEM 13c Cloud Control

In this post, we are going to have look on steps creation of Standby Database From OEM 13c Cloud Control. Creating or adding standby database for an existing primary database is a matter of few clicks in OEM 13c cloud control. Prerequisites: Source database is already registered in cloud control. An agent is deployed target host. Oracle […]

Read More

Steps to Apply Database Patch From OEM Cloud Control

Being a Core DBA we have deep  knowledge about patching.On the internet we have lots of knowledge is available about patching.This patching is different from the normal one. In this article, we are going to have look on steps which use to Apply Database Patch From OEM Cloud Control.  With help of OEM cloud control, […]

Read More

Generate Custom Report From OEM Cloud Control

REPORTING module can be used in OEM cloud control to generate custom reports like database status report of all target databases. Repository database contains all the target details and metric information. So the best way is to run a query against the repository database. Here we have provided steps for generating database consolidation report ENTERPRISE […]

Read More