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 […]
Articles Tagged: Data Guard
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 […]
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 […]
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 […]
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 […]
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. – […]
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 alter system set log_archive_trace=8 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 […]