Oracle Active Data Guard Overview & Architecture

We have seen 3 types of Standby Databases Physical Standby Database Logical Standby Database Snapshot Standby Database To know more about it Oracle Dataguard Oracle 11g comes with a new option : Oracle Active Data Guard. Oracle Active Data Guard is an optional license for Oracle Database Enterprise Edition. Active Data Guard enables advanced capabilities that that […]

Read More

Converting a Snapshot Standby Database to a Physical Standby Database

In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby. Prerequisites : Snapshot database is already exists Primary Database Snapshot Standby database mgr mgr Step 1 : Check Primary Database Information :

Step 2 : Check Snapshot Database Information :

[…]

Read More

Converting a Physical Standby Database to a Snapshot Standby Database

In the previous post, we can read about Snapshot Standby Overview. In this post, we can convert to Snapshot Standby. Prerequisites : Physical Standby Database is already created and synchronized with Primary Database . Database Details : Step 1: Check Primary database :

Step 2 : Check Standby Database :

Step 3 : […]

Read More

Snapshot Standby Databases: Overview & Architecture

Snapshot Standby Database : We have already seen types of standby database in Data Guard. Oracle Dataguard In this article we are going to see Snapshot Standby Database in deep. In snapshot standby type database stays in a read,write mode that is fully update-able database. Snapshot standby database is created by converting physical standby database […]

Read More

Start transport and Application of redo in Data Guard

In a previous post, we have seen various methods to create Physical Standby Database. Create Standby Database using duplicate database for standby RMAN command In this post, we will see how archive logs are transferred and recovered from a standby database and concern processes for redo transport and recovery. There are main two processes in […]

Read More

Create Physical Standby Database using RMAN Backup Restore

We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby database creation and configuration using RMAN backup and restore. Step 1: Connect to the Primary database and check if recovery area has enough space configured or not.

Step 2: Connect to […]

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