How to Create a Physical Standby Database using Backup Pieces
In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby…
In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby…
1 – Checking if the broker is being used. sqlplus / as sysdba show parameter dg_broker; show parameter dg_broker_start; select name, value from v$parameter where name = ‘dg_broker_start’; …
In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.…
Heterogenous Dataguard is a best use case, when we need to perform DB migration from Windows to Linux with minimum downtime as the actual downtime comprises only DB switch. As both Windows and Linux are Little…
💡 After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover.…
💡 In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database. Login in to…
💡 How do identify a transport error in a Data Guard setup using the broker If the broker has been setup, check the configuration basics: dgmgrl / show configuration; Configuration…
💡 If you wish to remove the dataguard/standby setup from primary database i.e to make the primary database as standalone database without any standby database, then follow below steps. 1.Put…
Introduction This article, will cover Oracle 19c restart data-guard physical standby configuration, but before we start, you need to have two oracle 19c restart servers one as Primary server and…
Monitor the gap between data guard physical Standby with email alert Create a database link between the primary and standby link: — Create a database line on primary server linking…