fbpx

Why do we use FAL_SERVER and FAL_CLIENT parameters in Oracle dataguard

FAL_SERVER and FAL_CLIENT

In this article, we are going to understand why we use FAL_SERVER and FAL_CLIENT parameters in the Oracle dataguard environment. FAL full form is “fetch archive log“. The FAL is an oracle data guard environment parameter. With the name, you can clearly understand it fetched the archive logs for the standby database from the primary … Read more

Oracle 11g R2 Dataguard configuration step by step

Oracle 11g R2 Dataguard configuration

data guard configuration steps in oracle 11gr2 Oracle 11g R2 Dataguard configuration step by step, before starting DG configuration you must read the below note. Subscribe on YouTube Oracle Database RDBMS software installed with one database on the PRIMARY server and on STANDBY server installed only RDBMS software without any Database. PRIMARY STANDBY IP Address: 192.168.1.10 IP Address: 192.168.1.20 … Read more

Oracle 19c Active Data Guard-DML Redirection

Oracle 19c Active Data Guard-DML Redirection

DataGuard DML Redirection Hello friends, in this article we are going to discuss the oracle 19c DML Redirection feature with DataGuard. ACTIVE DATAGUARD DML REDIRECTION is a new feature in Oracle 19c which enables the Data Manipulation Language (DML) operations on the standby server to be redirected and run on the production (Primary) database. The updated data will … Read more

Oracle 19c Data Guard Configuration step by step

Oracle 19c Data Guard Configuration

Hello friends in this article, we going to discuss Oracle 19c Data Guard Configuration step by step. Oracle Data Guard is a high availability model which prevents downtime and data loss by using redundant systems and software to eliminate single points of failure. Our Environment for this practice Primary Environment DB_NAME OCP DB_UNIQUE_NAME OCP IP … Read more

How to Convert Physical Standby To Snapshot Standby Database?

How to Convert Physical Standby To Snapshot Standby?

Hello friends, In this article, we are going to discuss how to convert physical standby to snapshot standby database manually. What is snapshot Standby? As you know the standby database is a copy of the primary database. so Oracle snapshot Oracle provides the snapshot standby function, in which the read-write operation is possible without worry. … Read more

Resolve huge archive gap between primary and standby

Resolve huge archive gap between primary and standby

Hello, friends in this tutorial I’m going to demonstrate to you how to Resolve huge archive gap between primary and standby. How do I resolve an archive gap? Suppose in between primary & standby have many archives difference like 500 archives, so we have need to recover it using incremental backup, follow me. Action ON … Read more

Step by Step to configure Oracle 12c Data Guard Physical Standby

oracle 12c data guard configuration

Oracle 12c Data Guard with Active DataGuard feature Oracle 12c Data Guard Configuration (Active Data guard Database using RMAN DUPLICATE FROM ACTIVE command) on Redhat Linux 6 using VMware environment step by step. Requirements: 1) Two machines with Redhat Linux 6 OS.2) Oracle 12c Database software.3) Primary Database name OCPPR & IP ADDRESS IS 192.168.1.104) Standby Database name OCPDR & IP ADDRESS IS 192.168.1.20 … Read more

ORA-10456 cannot open the standby database

ORA-10456 cannot open the standby database

Here we are going to discus how to solve ORA-10456: cannot open standby database media recovery session may be in progress. The ORA-10456 is Oracle Data guard error. Note: The following error is coming at that time when you trying to open your standby database in read-only mode without stopping the archive process. ORA-10456 cannot open the standby database Solution Step-1. Stop MRP process using following … Read more