SQL Loader in Oracle

Today we are going to learn about “SQL Loader”. The journey of Oracle Database does not end here.  Let’s have look at the technical definition of SQL Loader. what is SQL Loader? The primary method for quickly populating Oracle tables with data from external files is called SQL*Loader. From its powerful data parsing engine that puts […]

Read More

Managing Role in Oracle

Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases.     Let’s […]

Read More

OCM 12C Journey

I wrote two OCM exams back to back because I wanted to write 2-days OCM 12C exam but there was no schedule in India for 2-days OCM 12C exam, So first, I wrote 2-days OCM 11G on 9th & 10th April and then I wrote an exam of OCM 12C Upgrade on 23rd April in […]

Read More

Create Standby Database using duplicate database for standby RMAN command

We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby creation using RMAN duplicate database for standby command. Note: For this process, we need to copy password file from primary side to standby side under $ORACLE_HOME/dbs Database Detail : Connect to Primary Database […]

Read More

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