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 […]
Monthly Archives: October 2017
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 [oracle@host01 ~]$ srvctl status database -d TEST Instance TEST1 is running on node host01 Instance TEST2 is running […]
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 […]