Recover Standby Database from Primary using Service in Oracle

Recover Standby Database from Primary using Service in Oracle

Recover Standby Database from Primary using Service in Oracle: In this article we will discuss about how to Recover Standby Database from Primary using Service in Oracle 19c. If your standby database is out of sync from primary. Or some archive logs got deleted before it is being shipped or applied to standby. Then, you … Read more

ORA-01274 cannot add data file that was originally created as

ORA-01274_ cannot add data file that was originally created as

ORA-01274: cannot add data file that was originally created as: In this paragraph i will discuss about ORA-01274 database error. When you getting ORA-01274 error follow below steps to resolve the issue. Problem: After adding a datafile in primary database, recovery process in standby database stopped with below error. Primary Side: After adding a datafile … Read more

Oracle 19c 2 node RAC to single instance standby database setup

Oracle-19c-2-node-RAC-to-single-instance-standby-database-setup

Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup Oracle 19c 2 node RAC to single instance standby database step by step. Environment Details for both (Primary and Standby): Primary Server side Configurations:- Make sure primary is in archivelog mode: Check FORCE LOGGING … Read more

Convert Physical Standby to Active Dataguard

How to Convert Physical Standby to Active Dataguard

Convert Physical Standby to Active Dataguard : In this article we will discuss about How To Enable Active Dataguard In Physical Standby Database. Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Benefits of using Active Dataguard : Important Note : You … Read more

Create Physical Standby Database Using RMAN Backup and Restore

Create Physical Standby Database Using RMAN Backup and Restore

Step by step guide on how to create a physical standby database using RMAN without using duplicate command. Create a Physical Standby Database Using the RMAN Backup and Restore process.: In this content, you will see and learn how we can Create a Physical Standby Database Using RMAN Backup and Restore. We will performed here … Read more

Oracle Data Guard Concepts

Oracle Data Guard Concepts

Oracle Data Guard Concepts: during this article we are going to discuss about Oracle Data Guard Concepts. The main features of Oracle data guard is A Data guard configuration consists of 1 primary database and one or more standby database. The standby databases are always in sync with primary database. If primary production database is unavailable because of planned or unplanned outage , then we … Read more