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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
