{"id":1677,"date":"2021-10-20T22:08:20","date_gmt":"2021-10-20T20:08:20","guid":{"rendered":"http:\/\/rootfan.com\/?p=1677"},"modified":"2024-06-09T21:52:10","modified_gmt":"2024-06-09T19:52:10","slug":"configuration-du-courtier-data-guard-oracle-19c","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/data-guard-broker-configuration-oracle-19c\/","title":{"rendered":"Configuration pas \u00e0 pas du Data Guard Broker dans Oracle 19c"},"content":{"rendered":"<p>Si vous souhaitez g\u00e9rer facilement une garde de donn\u00e9es Oracle, vous devez utiliser un courtier de garde de donn\u00e9es.<\/p>\n\n\n\n<p>Le broker Oracle Data Guard est un cadre de gestion distribu\u00e9 qui automatise et centralise la cr\u00e9ation, la maintenance et la surveillance des configurations Data Guard.<\/p>\n\n\n\n<p>Dans ma configuration, j'ai d\u00e9j\u00e0 cr\u00e9\u00e9 un Data Guard. Vous pouvez v\u00e9rifier <a href=\"http:\/\/rootfan.com\/fr\/oracle-19c-data-guard-configuration-pas-a-pas\/\" data-type=\"post\" data-id=\"1675\">ce poste<\/a> pour voir comment je l'ai cr\u00e9\u00e9.<\/p>\n\n\n\n<p>BCN est la base de donn\u00e9es primaire et PARIS est la base de donn\u00e9es de secours.<\/p>\n\n\n\n<p>Dans les commandes ci-dessous, vous pouvez supprimer le sid='*' si vous n'avez pas de base de donn\u00e9es RAC et vous devriez \u00eatre en mesure de le faire.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2><strong>Table des mati\u00e8res<\/strong><\/h2><nav><div><div class=\"\"><a href=\"#1-reset-log-archive-dest-2\">1. R\u00e9initialisation de LOG_ARCHIVE_DEST_2 <\/a><\/div><div class=\"\"><a href=\"#2-set-dg-broker-config-file\">2. D\u00e9finir le fichier dg_broker_config_file<\/a><\/div><div class=\"\"><a href=\"#3-enable-the-broker\">3. Activer le courtier<\/a><\/div><div class=\"\"><a href=\"#4-create-the-configuration\">4. Cr\u00e9er la configuration<\/a><\/div><div class=\"\"><a href=\"#5-configure-the-listeners\">5. Configurer les auditeurs<\/a><\/div><div class=\"\"><a href=\"#6-enable-the-configuration\">6. Activer la configuration<\/a><\/div><\/div><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-reset-log-archive-dest-2\">1. R\u00e9initialisation de LOG_ARCHIVE_DEST_2 <\/h2>\n\n\n\n<p>Vous devez d'abord effacer la valeur de LOG_ARCHIVE_DEST_2 sur la base de donn\u00e9es primaire et sur la base de donn\u00e9es de secours.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow parameter LOG_ARCHIVE_DEST_2\n\nSQL&gt; alter system set LOG_ARCHIVE_DEST_2=&#039;&#039; SCOPE=BOTH sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<p>Une fois cela fait, vous pouvez continuer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2-set-dg-broker-config-file\">2. D\u00e9finir le fichier dg_broker_config_file<\/h2>\n\n\n\n<p>D\u00e9finissez les param\u00e8tres dg_broker_config_file1 et dg_broker_config_file2 sur toutes les instances primaires et de secours.<\/p>\n\n\n\n<p>L'emplacement par d\u00e9faut du fichier de configuration du courtier est $ORACLE_HOME\/dbs ou $ORACLE_HOME\/database.<\/p>\n\n\n\n<p>Si vous souhaitez que les fichiers de configuration du courtier se trouvent \u00e0 un emplacement autre que celui par d\u00e9faut, d\u00e9finissez ces param\u00e8tres.<\/p>\n\n\n\n<p>Dans le cas d'une base de donn\u00e9es RAC, d\u00e9finissez l'emplacement du fichier de configuration du courtier sur un emplacement partag\u00e9 et la m\u00eame valeur sur toutes les instances.<\/p>\n\n\n\n<p>Si vous n'avez pas de base de donn\u00e9es RAC, il n'est pas n\u00e9cessaire d'utiliser sid='*'.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET dg_broker_config_file1 = &#039;&lt;path\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;; \nALTER SYSTEM SET dg_broker_config_file2 = &#039;&lt;path\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<p>OU en cas d'utilisation du syst\u00e8me de fichiers ASM :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET dg_broker_config_file1 = &#039;&lt;+disk group\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;; \nALTER SYSTEM SET dg_broker_config_file2 = &#039;&lt;+disk group\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<p>Si vous souhaitez que les fichiers de configuration du courtier se trouvent \u00e0 l'emplacement par d\u00e9faut, vous pouvez ignorer cette \u00e9tape.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3-enable-the-broker\">3. Activer le courtier<\/h2>\n\n\n\n<p>Activez le courtier sur les bases de donn\u00e9es primaires et de secours.<\/p>\n\n\n\n<p>Si vous n'avez pas de base de donn\u00e9es RAC, il n'est pas n\u00e9cessaire d'utiliser sid='*'.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"4-create-the-configuration\">4. Cr\u00e9er la configuration<\/h2>\n\n\n\n<p>Se connecter au DGMGRL sur le primaire :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ dgmgrl\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Oct 19 17:47:37 2021\nVersion 19.8.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nWelcome to DGMGRL, type &quot;help&quot; for information.\nDGMGRL&gt; CONNECT sys\/password;\nConnected.\n<\/pre><\/div>\n\n\n<p>Cr\u00e9er une configuration sur le primaire :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; CREATE CONFIGURATION &#039;MYCONF&#039; AS PRIMARY DATABASE IS &#039;BCN&#039; CONNECT IDENTIFIER IS BCN;\nConfiguration &quot;MYCONF&quot; created with primary database &quot;BCN&quot;\n<\/pre><\/div>\n\n\n<p>Ajouter le standby \u00e0 la configuration :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt;  ADD DATABASE &#039;PARIS&#039; AS CONNECT IDENTIFIER IS PARIS MAINTAINED AS PHYSICAL;\nDatabase &quot; PARIS &quot; added\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"5-configure-the-listeners\">5. Configurer les auditeurs<\/h2>\n\n\n\n<p>Configurer l'\u00e9couteur sur le serveur primaire.<\/p>\n\n\n\n<p>Veillez \u00e0 ajouter l'entr\u00e9e du courtier comme suit<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nvi $ORACLE_HOME\/network\/admin\/listener.ora\n\n# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/listener.ora\n# Generated by Oracle configuration tools.\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = srv1.localdomain)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER=\n   (SID_LIST=\n        (SID_DESC=\n          (GLOBAL_DBNAME=BCN.localdomain)\n          (SID_NAME=BCN)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n        (SID_DESC=\n          (GLOBAL_DBNAME=BCN_DGMGRL.localdomain)\n          (SID_NAME=BCN)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n      )\n<\/pre><\/div>\n\n\n<p>Et rechargez l'\u00e9couteur<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nlsnrctl reload\n<\/pre><\/div>\n\n\n<p>Configurez l'auditeur sur le serveur en attente.<\/p>\n\n\n\n<p>Veillez \u00e0 ajouter l'entr\u00e9e pour _DGMGRL.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nvi $ORACLE_HOME\/network\/admin\/listener.ora\n\n# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/listener.ora\n# Generated by Oracle configuration tools.\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = srv2.localdomain)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER=\n   (SID_LIST=\n        (SID_DESC=\n          (GLOBAL_DBNAME=PARIS.localdomain)\n          (SID_NAME=PARIS)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n        (SID_DESC=\n          (GLOBAL_DBNAME=PARIS_DGMGRL.localdomain)\n          (SID_NAME=PARIS)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n      )\n<\/pre><\/div>\n\n\n<p>Il faut \u00e9galement recharger l'auditeur en attente<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nlsnrctl reload\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"6-enable-the-configuration\">6. Activer la configuration<\/h2>\n\n\n\n<p>Il ne vous reste plus qu'\u00e0 activer la configuration que vous venez de cr\u00e9er.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; ENABLE CONFIGURATION;\nEnabled.\n<\/pre><\/div>\n\n\n<p>Utilisez la commande SHOW pour v\u00e9rifier que la configuration et ses bases de donn\u00e9es ont \u00e9t\u00e9 activ\u00e9es et mises en ligne avec succ\u00e8s :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; SHOW CONFIGURATION;\n\nConfiguration\nName: MYCONF\nEnabled: YES\nProtection Mode: MaxPerformance\nFast-Start Failover: DISABLED\n\nDatabases:\nBCN - Primary database\nPARIS - Physical standby database\n\nCurrent status for &quot;MYCONF&quot;\nSUCCESS\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Si vous souhaitez g\u00e9rer facilement un syst\u00e8me de garde de donn\u00e9es Oracle, vous devez utiliser un courtier de garde de donn\u00e9es. Le courtier Oracle Data Guard est un cadre de gestion distribu\u00e9 qui automatise et centralise la cr\u00e9ation, la maintenance et la surveillance des configurations Data Guard. Dans ma configuration, j'ai d\u00e9j\u00e0 cr\u00e9\u00e9 un Data Guard. Vous pouvez consulter cet article pour ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/data-guard-broker-configuration-oracle-19c\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Configuration pas \u00e0 pas du Data Guard Broker dans Oracle 19c \"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2934,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"Data Guard Broker Configuration","rank_math_title":"","rank_math_description":"Configure Data Guard Broker in Oracle 19c with this step-by-step guide. #DataGuard #BrokerConfiguration #Oracle19c","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[34,32],"class_list":["post-1677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-broker","tag-data-guard"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-2166711.jpeg?fit=1880%2C1254&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=1677"}],"version-history":[{"count":26,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1677\/revisions"}],"predecessor-version":[{"id":6161,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1677\/revisions\/6161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2934"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=1677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=1677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=1677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}