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

Logical Standby Database : SQL Apply Architecture

Oracle DataGuard supports logical and physical standby databases. Logical Standby: When primary database generates any redo entries it is transferred to standby database and then redo data are converted into SQL statements and then those SQL statements are applied to standby database. To read more about Physical Standby Database Physical Standby Database: Redo Apply Architecture […]

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

Physical Standby Database: Redo Apply Architecture

In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture Oracle Data Guard works on physical standby and logical standby sites. Physical Standby: When primary database generates redo entries, those redo are transferred to standby database and then redo is applied to standby database. Logical Standby: When primary […]

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

Log Shipping in Oracle

In this article we will learn DR creation with log shipping : Prerequisites : Source Database should be in Archive log mode . Enable Archive Log Mode In Oracle RAC Details : Database Name Source DB IP DR DB IP mgr 192.168.1.10 192.168.1.181 Step 1 : To create log shipping DR server force logging and […]

Read More

Oracle Dataguard

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Dataguard maintains these standby as exact copy of primary database. So if […]

Read More