Steps to Startup & Shutdown Oracle Data Guard !
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start…
Read moreDataGuard
How to Check Sync between Primary & Standby DB ??
Primary Get standby redo log info: Monitor lag in standby including RAC Monitor recovery progress…
Read moreCommand to Check Archivelog Size
Oracle databases maintain a detailed history of all changes made to the database through archived…
Read moreError: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set (DataGuard Broker Configuration)
The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter…
Read moreProtected: Oracle Data Guard 19c – 100 Interview Questions!!
There is no excerpt because this is a protected post.
Read moreChanging Protection Mode in Data Guard !!
In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of…
Read moreORA-16855: Transport Lag Has Exceeded Specified Threshold in Data Guard !!
The ORA-16855 error indicates that the transport lag (the delay in sending redo data from…
Read moreDataguard Configuration with DG Broker using Active Duplicate in Oracle !!
Hope it helped !! 🙂
Read moreSwitchover to Physical Standby Database in Oracle
Once the standby database is configured and verified to be working properly, we can switch…
Read moreData Guard Protection Mode.
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both…
Read moreORA-16401, ORA-16055 : How to Drop and recreate SRL From Standby Database??
It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log…
Read moreHow to use IMPDP with transform=disable_archive_logging:y
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will…
Read moreFAL (Fetch Archive Log) Gap Resolution
Once an Archive Log is received or archived from a Standby Redo Log on the…
Read moreResizing redo logs and standby Redologs in Dataguard
IN PRIMARY DATABASE :- ------------------------------------- Moving on to the standby database:- ------------------------------------- Scripts used in…
Read moreUnable to generate Listener Log in Prod RAC DB
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the…
Read moreMoving datafile from one location to another in Standby
Check the datafile location along with name: Set standby file management parameter to manual before…
Read moreORA-16047: DGID mismatch between destination setting and target database
Issue : ORA-16047: DGID mismatch between destination setting and target database Since LOG_ARCHIVE_DEST_3 is getting…
Read moreRecovery Point Objective(RPO) and Recovery Time Objective (RTO)
A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time…
Read moreStep by Step Data Guard Configuration in 19c
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11…
Read moreProtected: 2 node RAC with Dataguard Configuration (DGMGRL)
There is no excerpt because this is a protected post.
Read moreMonitor Standby Database with Lag Time Report
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh To save the script and change its permissions, follow these steps:1. Save the…
Read moreConfigure MRP in Standby
Add the Target Database TNS entry to the Source's tnsnames.ora file(s) (all of them if…
Read moreDe-configure MRP in Standby
On Source, as Oracle user: On Target, as Oracle user: Hope it helped !! 🙂
Read moreRollForward Standby Database using rman service
Overview: As we are already aware that the rolling forward an physical standby database via…
Read moreResync Standby Database Using RMAN Incremental Backups
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose…
Read more