Gab.Loves.Oracle

Hello Everyone! I hope everyone is doing great! This next article discusses how to setup Oracle Dataguard Broker for Oracle Database 11.2. Please visit my previous posts which shows how to setup Oracle Dataguard 11.2. If you have questions and clarifications, please let me know and I will provide my feedback as soon as I can. Thanks. Let's share and make others love Oracle, too. ======================================================================== As stated in the Oracle Official Documentation, Oracle® Data Guard Broker 11g Release 2 (11.2)             Part Number E17023-08: The Oracle Data Guard broker is a distributed management framework that automates and centralizes the creation, maintenance, and monitoring of Data Guard configurations. The following list describes some of the operations the broker automates and simplifies: 1.     Creating Data Guard configurations that incorporate a primary database, a new or existing (physical,

Converting Physical Standby database to an Active Dataguard This is a continuation of my previous articles on Oracle Dataguard 11.2. If you have inquiries, please let me know and I will be happy to answer them as soon as I can. Thanks. Let's share and make others love Oracle, too. ======================================================================== Introduction: Active Dataguard provides the capability to have read-only access to a physical standby database. The standby database can be used for queries, sorting, and reporting. For RMAN, it allows fast incremental backups when offloading backups to a standby database. Converting a physical standby database to an active Dataguard incurs additional licensing fees. Steps in converting Physical Standby database to Active Dataguard 1.     Follow the steps presented in the section: Check the redo transport and redo apply 2.     Convert the physical standby database to active dataguard If co

Hello Everyone! From my previous article, I have shared how to setup Oracle Dataguard 11.2 from scratch. The next thing that a DBA will do is to be familiar with the environment, to explore its functionality and to observe its behavior. With these, you will have a familiarization with Oracle Dataguard. Let me know if you have some questions, clarifications and additional information so we can discuss them as soon as we can. Thanks. Let's share and make others love Oracle, too. ======================================================================== Familiarization with Oracle DataGuard 11.2 With our Data Guard configuration running in maximum performance mode, the validation tasks will involve: 1.         Switching redo log files from the primary. 2.         Verifying those log files are being shipped. 3.         Checking that the redo logs are applied to the physical standby database. Redo log switch and transport On the prim