Differences

This shows you the differences between two versions of the page.

--- oracledataguardbroker [2015/07/08 15:04] – created 131.111.27.50
+++ oracledataguardbroker [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 Example below ...
-Primary Database: DUBETECH01 on DBOR01\\
+Primary Database: DUBEPRD on DBOR01\\
-Standby Database: DUBETECH02 on DBOR02\\
+Standby Database: DUBESDBY on DBOR02\\
 On the Physical and Standby database set the following initialisation parameters:
-<code>SQL> alter system set dg_broker_config_file1 = ‘D:\oracle\product\11.2.0\dbhome_1\database\DR1LIBSOUAT.DAT’;
+<code>SQL> alter system set dg_broker_config_file1 = ‘D:\oracle\product\11.2.0\dbhome_1\database\DR1DUBEPRD01.DAT’;
-SQL> alter system set dg_broker_config_file2 = ‘D:\oracle\product\11.2.0\dbhome_1\database\DR2LIBSOUAT.DAT’;
+SQL> alter system set dg_broker_config_file2 = ‘D:\oracle\product\11.2.0\dbhome_1\database\DR2DUBEPRD02.DAT’;
 SQL> alter system set dg_broker_start = TRUE;</code>
@@ Line 16: / Line 16: @@
 For example ... \\
-SID_LIST_LISTENER =
+<code>SID_LIST_LISTENER =
   (SID_LIST =
     (SID_DESC =
-      (GLOBAL_DBNAME = LIBSOUAT_DGMGRL)
+      (GLOBAL_DBNAME = DUBEPRD_DGMGRL)
       (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
-      (SID_NAME = LIBSOUAT)
+      (SID_NAME = DUBEPRD)
     )
-  )
+  )</code>
 Now use DGMGRL to create the configuration: \\
-<code>DGMGRL> CREATE CONFIGURATION 'DG_LIBSOUAT' as PRIMARY DATABASE is LIBSOUAT CONNECT IDENTIFIER is libsouat;
+<code>DGMGRL> CREATE CONFIGURATION 'DG_DUBEPRD' as PRIMARY DATABASE is DUBEPRD CONNECT IDENTIFIER is dubeprd;
-DGMGRL> ADD DATABASE libsouat2 as CONNECT IDENTIFIER is libsouat2 MAINTAINED AS PHYSICAL;
+DGMGRL> ADD DATABASE dubesdby as CONNECT IDENTIFIER is dubesdby MAINTAINED AS PHYSICAL;
 DGMGRL> ENABLE CONFIGURATION;
 DGMGRL> SHOW CONFIGURATION;</code>
@@ Line 43: / Line 43: @@
 Connect to DGMGRL
 When connecting to DGMGRL always connect using the password.
-Otherwise errors can occur when performing switchovers and failovers. D:\>dgmgrl
+Otherwise errors can occur when performing switchovers and failovers.
+<code>D:\>dgmgrl
 DGMGRL for 64-bit Windows: Version 11.2.0.4.0 - 64bit Production
@@ Line 49: / Line 50: @@
 Welcome to DGMGRL, type "help" for information.
-DGMGRL> connect sys/<password>@libsouat
+DGMGRL> connect sys/<password>@dubeprd
 Connected.
-DGMGRL>Show Current Configuration DGMGRL> show configuration;
+DGMGRL></code>
+Show Current Configuration
+<code>DGMGRL> show configuration;
-Configuration - DG_LIBSOUAT
+Configuration - DG_DUBEPRD
   Protection Mode: MaxPerformance
   Databases:
-    libsouat  - Primary database
+    dubeprd   - Primary database
-    libsouat2 - Physical standby database
+    dubesdby  - Physical standby database
 Fast-Start Failover: DISABLED
 Configuration Status:
-SUCCESSShow Summary of Database Information DGMGRL> show database libsouat2;
+SUCCESS</code>
+Show Summary of Database Information
+<code>DGMGRL> show database dubesdby;
-Database - libsouat2
+Database - dubesdby
   Role:            PHYSICAL STANDBY
@@ Line 74: / Line 79: @@
   Real Time Query: OFF
   Instance(s):
-    libsouat2
+    dubesdby
 Database Status:
-SUCCESS
+SUCCESS</code>
 ==== Switchover and Failover ====
@@ Line 87: / Line 92: @@
 ==== Licensing ====
-The broker is included for use in Enterprise editions of the Oracle Database. \\
+The broker is included for use in Enterprise editions of the Oracle Database, therefore there are no additional licensing concerns. \\
-Therefore there are no additional licensing concerns. \\
 The following information is from Oracle's Documentation on the Broker ... \\
-The broker's interfaces improve usability and centralize management and monitoring of the Data Guard configuration. Available as a feature of the Enterprise Edition and Personal Edition of the Oracle database, the broker is also integrated with the Oracle database and Oracle Enterprise Manager.
+//The broker's interfaces improve usability and centralize management and monitoring of the Data Guard configuration. Available as a feature of the Enterprise Edition and Personal Edition of the Oracle database, the broker is also integrated with the Oracle database and Oracle Enterprise Manager.//
 ==== Benefits ====
 The full list of benefits can be seen here: http://docs.oracle.com/cd/E11882_01/server.112/e41134/concepts.htm#SBYDB4709
-A summary of these benefits are ...
+A summary of these benefits are ... \\
-Use of Oracle Enterprise Manager to monitor Standby configurations.
+  * Use of Oracle Enterprise Manager to monitor Standby configurations.
-Use of DGMGRL command line program to quickly view/configure settings
+  * Use of DGMGRL command line program to quickly view/configure settings
-Easier to view errors associated with the Standby databases.
+  * Easier to view errors associated with the Standby databases.
-Simplify switchovers and failovers
+  * Simplify switchovers and failovers
-No need to put standby database into recovery mode, the broker does this automatically when database is mounted
+  * No need to put standby database into recovery mode, the broker does this automatically when database is mounted