Fast Start Failover in Data Guard

Oracle Data Guard work on two database roles Primary and Standby. In the previous article, we have seen switching the role of Primary and standby database and failover Primary role to Standby database manually. To see Manual Switch Over Manual SwitchOver in Oracle To see Manual Fail Over Manual Failover in Data Guard With Oracle Data Guard […]

Read More

Flashback Database after Resetlogs in data guard

In this Post, We will see How enabling Flashback helps us in case of Primary Database resetlogs. Flashback Database and it’s Benefits in Data Guard Environment Here I am simulating a scenario of Point in Time Recovery. My standby database is in sync with Primary Database and I have restored an old backup in Primary Database […]

Read More

Flashback Database and it’s Benefits in Data Guard Environment

Let us first understand Flashback Database : With Flashback Database technology of Oracle, you can quickly bring your database to an earlier point in time by undoing all changes that took place since that time. This operation is fast because you do not need to restore backups. Oracle Flashback Database, lets you quickly recover the […]

Read More

Offloading Backup to Standby in Data Guard

As Oracle Data Guard came up with many advantages, One of its benefits is we can offload backup to Physical Standby Database. Using the RMAN Recovery Catalog in a Data Guard Configuration   We need to user Recover Catalog to offload backup to the standby database. We will offload backup to the physical standby database […]

Read More

Using the RMAN Recovery Catalog in a Data Guard Configuration

Recover Catalog: A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. Benefits and Restrictions of RMAN in DataGuard In easy words, RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Recovery catalog and data guard : Use of the RMAN recovery […]

Read More

Installing Oracle 18c Data Guard on Cloud

This article shows how to create Oracle 18c Data Guard in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Data Guard Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter DG18. – […]

Read More

Data Guard Archive Tracing

You can trace the archive logs on either the primary or the standby database by setting the log_archive_trace initialization parameter

Trace files located in user_dump_dest location. On the primary database, the log_archive_trace parameter controls the output of the ARCn (archiver) FAL (fetcharchived log) LGWR (log writer) background processes. On the standby databases, it traces […]

Read More