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

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

Automatic Gap Detection and Resolution

Archive Gap: It means set of Archive Logs are not transmitted from Primary Database to Standby Database for some reason. The main reason could be your Network Connectivity. When network connectivity resumes data guard resumes redo data transmission from the Primary to Standby site. Causes of Archive Gaps : Network Disconnection. Standby database outage. I/O issues […]

Read More

ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

You may get this error while creating a tablespace in your environment.

Oracle has some boundaries to set datafile maximum size based on the db_block_size parameter. db_block_size maximum allowed size for datafile 2k 8GB 4K 16GB 8K 32GB 16K 64GB 32K 128GB The formula to calculate the max size is db_block_size * 4194303. If […]

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