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

TWO_TASK Environment Variables Oracle 12c

There are two environment variables for Unix to connect an Oracle database.One of them is ORACLE_SID and the other one is TWO_TASK. ORACLE_SID is used for connecting a database which is installed to the same host. TWO_TASK is used for connecting an oracle database which is installed another host. I must thank to my fellow DBA […]

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

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

Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS This method can be used only if the on-premises platform is little endian, and […]

Read More