Oracle Net Configuration for Data Guard

In Previous article we have seen Primary Database Preparation for Data Guard Configuration. Setting the parameter on primary database for physical standby database. In this article we will see Oracle Net Configuration on Primary and Standby. Step 1 : Configure tnsnames.ora file at Production.

Here we can see two net services. TESTDB for Primary […]

Read More

Setting the parameter on primary database for physical standby database.

In the previous article, we have seen basics about the Architecture of Oracle Dataguard. Oracle Dataguard Architecture We can configure DataGuard with main three stages. Preparing Primary Database. Setting up net services between primary and standby database. Creating Standby Database. In this article, we will set the parameters on the primary database. We will see […]

Read More

Benefits of using Dataguard

In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture The main benefit of any DR server is we can say to protect Production Server’s critical data from any natural and unnatural disasters. We keep our Production Server in one place while our DR server can set up […]

Read More

Protection modes in Oracle Dataguard

In previous article we have gone through architecture of Oracle Dataguard and redo apply and sql apply architecture. A main role of any DR server is to protect Production Server’s critical data from any natural and unnatural disasters. Oracle Data Guard have different flavors to provide protection to Production’s critical data. That we can see […]

Read More

Redolog in Oracle

As DBA we are aware that Oracle is a mixture of CRD files. Now we are going to have look at Redolog.     Let’s have a technical definition of Redolog. The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as […]

Read More

Controlfile in Oracle Database

 Today we are going to have look at the most important element of the Oracle Databases.Being Oracle DBA we must have good knowledge about Controlfile. It plays an important role in Oracle Database. If something happens wrong with it we are not able to start our database. Let’s have some important knowledge about Controlfile. Whenever we […]

Read More

Control file recovery

Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile. Instance terminates on startup with

Solution […]

Read More

Tip and Tricks to pass OCM exam

I wrote an exam on 9th and 10th Apr in India, After 17 long days, the result was out. Now officially I’ve successfully passed 11G OCM, Oracle Database 11g Certified Master Exam. It was almost more than 15 months that I’ve been preparing for this exam but actual preparation started almost 6 years back when I […]

Read More

Spfile and Pfile in Oracle

Today we are going to have look on the topic of “PFile and SPFile”. This is the most important element of the Oracle database. Being Oracle DBA we must aware about “PFile and SPFile”. This file plays an important role in  Oracle database. Let’s have look at the technical definition of “PFile and SPFile”. It will be […]

Read More