Tagged articles
Data Guard
18 articles · Page 1 of 1

ITPUBNov 3, 2026 · Databases
A comprehensive reference of 100 production-ready SQL queries for monitoring, troubleshooting, and managing Oracle 19c Active Data Guard environments, covering configuration, synchronization, role transitions, performance, and daily maintenance with risk annotations.
19cActive Data GuardDBA
0 likes · 33 min read


ITPUBSep 26, 2026 · Databases
This comprehensive guide lists 100 essential Oracle DBA commands covering instance management, parameter configuration, session troubleshooting, lock analysis, SQL performance tuning, tablespace and user management, UNDO, temporary tablespace, RMAN backup and recovery, Data Guard, RAC, Data Pump, and OS-level diagnostics, with practical examples and usage notes.
Backup RecoveryDBAData Guard
0 likes · 30 min read

This comprehensive tutorial walks you through configuring Oracle Data Guard for master‑slave replication, covering prerequisites, detailed command‑by‑command steps, common pitfalls, testing procedures, switchover operations, and post‑switch recovery, all illustrated with diagrams and code snippets.
Data GuardDatabase ReplicationOracle
0 likes · 24 min read

This guide walks through setting up a Dameng data‑guard service using a primary, standby, and monitor server, covering data preparation, configuration of dm.ini, dmmal.ini, dmarch.ini, dmwatcher.ini, starting services, OGUID setup, mode switching, and monitoring to achieve high‑availability replication.
DamengData GuardDatabase Configuration
0 likes · 12 min read

This article walks through a real‑world case of an Oracle RAC/ADG deployment on CentOS 7 that suffered severe performance degradation, detailing the root‑cause analysis, OS and listener tuning, patch installation, cache‑reclamation settings, and compatibility fixes to restore stability.
CentOSData GuardLinux
0 likes · 12 min read

This article outlines practical steps DBAs can take to prevent data leakage and loss, covering user and profile management, privilege minimization, audit logging, vulnerability patching, high‑availability solutions like RAC and Data Guard, and effective backup and recovery drills.
DBAData GuardOracle
0 likes · 15 min read

This guide walks through Oracle's Database Configuration Assistant (DBCA), explaining silent creation commands, template types, seed vs. no‑seed databases, step‑by‑step script generation, and how DBCA ties into multitenant architecture and Data Guard features.
DBCAData GuardDatabase Creation
0 likes · 13 min read

This guide walks through upgrading an Oracle MAA environment from 11.2.0.4 to 12.1.0.2 with no front‑end service interruption, covering environment overview, two Data Guard switchover cycles, transient logical standby conversion, rolling patch execution with physru.sh, and post‑upgrade cleanup steps.
DBUAData GuardGrid Infrastructure
0 likes · 21 min read

This article walks through semi‑automated Oracle Data Guard deployment, when and how to use DG Broker, practical failover, switchover and archive‑recovery scenarios, Oracle 12c enhancements like Far Sync and VALIDATE, a real‑world standby query failure case, and using Data Guard for database migration.
12cDG BrokerData Guard
0 likes · 16 min read


ITPUBOct 28, 2016 · Databases
This article provides a detailed, hands‑on walkthrough of Oracle Data Guard switchover in normal operation and the subsequent steps to convert the original primary to a standby, including all necessary SQL commands, instance restarts, and verification queries.
Data GuardFailoverOracle
0 likes · 6 min read


ITPUBSep 19, 2016 · Databases
This article demonstrates how to enable Oracle Data Guard’s Maximum Protection mode, examines the behavior of primary and standby databases when the standby connection is broken, and walks through the resulting errors, forced shutdown, and step‑by‑step recovery back to normal operation.
Data GuardDatabase ReplicationHigh Availability
0 likes · 12 min read


ITPUBSep 16, 2016 · Databases
This article explains Oracle Data Guard's three protection modes—Maximum Performance, Maximum Availability, and Maximum Protection—detailing their underlying redo‑log mechanisms, configuration steps, and test results that illustrate how each mode behaves under various failure scenarios.
Data GuardHAOracle
0 likes · 14 min read


ITPUBAug 29, 2016 · Databases
This guide details how to move an Oracle 11.2.0.3.0 single‑instance database from Windows to a three‑node RAC on Linux using Data Guard, covering compatibility, required patches, configuration steps, parameter settings, and post‑migration tasks to ensure a fast, low‑downtime transition.
ASMData GuardDatabase Migration
0 likes · 10 min read


ITPUBAug 10, 2016 · Databases
This guide walks through preparing the primary and standby Oracle 11g databases on RH Linux, configuring listeners, tnsnames, force logging, adding standby redo logs, editing parameter files, transferring files with RMAN, verifying roles, activating Active Data Guard, using snapshot standby, switching logs, and setting an archive‑log deletion policy.
Active Data GuardData GuardDatabase Replication
0 likes · 20 min read

When an Exadata diskgroup fails to mount, this article walks through using AMDU to extract control, data, and log files, handling OMF and custom formats, advancing SCN, and finally opening the database, while also recommending preventive tools and regular maintenance.
AMDUASMDUL
0 likes · 11 min read

This article provides a comprehensive guide to Oracle Data Guard, covering its disaster‑recovery concepts, RTO/RPO standards, hardware‑to‑application level design considerations, standby design options, sensitive data‑file operations, switchover/failover advice, SQL auditing with Snapshot Standby, and practical tips for building or rebuilding a Data Guard environment.
DG BrokerData GuardOracle
0 likes · 20 min read


ITPUBJul 7, 2016 · Databases
This guide shares a detailed recount of preparing for the Oracle OCM certification, covering exam locations, odd/even machine handling, required software installations, crash scenarios, step‑by‑step skillset tasks, and practical review tips to help candidates succeed.
Data GuardOCMOracle
0 likes · 11 min read

This guide details the complete process of moving a 2‑node Oracle 11gR2 RAC database to new servers and storage using Active Physical Standby Data Guard, covering architecture, pre‑implementation preparation, detailed implementation steps, switchover procedures, impact assessment, rollback measures, and lessons learned.
Data GuardDatabase MigrationHigh Availability
0 likes · 10 min read
