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

Manual Data Guard switchover in Oracle

Manual Data Guard switchover in oracle

Manual data guard switchover in Oracle: In this article we will explain about how to perform Manual Data Guard switchover in Oracle from primary to physical standby database manually. In a Data Guard environment two types of roles primary database and physical standby database are there we can altered these roles without any data lose … 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

Data Guard Protection Modes in oracle

Data Guard Protection Modes in oracle

Data Guard Protection Modes in oracle: In this article we will discuss about Data Guard Protection Modes in oracle. In some situations, a business cannot afford to lose data. In other situations, the availability of the database may be more important than the loss of data. Some applications require maximum database performance and can tolerate … 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