{"id":639,"date":"2020-05-06T16:01:41","date_gmt":"2020-05-06T14:01:41","guid":{"rendered":"http:\/\/rootfan.com\/?p=639"},"modified":"2022-04-03T23:46:54","modified_gmt":"2022-04-03T21:46:54","slug":"recherche-de-la-base-de-donnees-primaire-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/find-primary-database-oracle\/","title":{"rendered":"Comment trouver une base de donn\u00e9es primaire \u00e0 partir d'une base de donn\u00e9es en attente dans Oracle ?"},"content":{"rendered":"

Si vous disposez d'un data guard Oracle et que vous souhaitez conna\u00eetre le r\u00f4le de chaque base de donn\u00e9es, vous pouvez suivre ce guide pour obtenir plus de d\u00e9tails sur l'environnement.<\/p>\n\n\n\n

Vous pouvez ex\u00e9cuter ces requ\u00eates dans la base de donn\u00e9es principale ou dans la base de donn\u00e9es de secours, de mani\u00e8re distincte.<\/p>\n\n\n\n

Cette premi\u00e8re requ\u00eate donne une vue d'ensemble des bases de donn\u00e9es primaires et permanentes.<\/p>\n\n\n

\nset lines 132\ncolumn current_scn format 99999999999999999999\n\nselect * from v$dataguard_config;\n\nDB_UNIQUE_NAME                 PARENT_DBUN                    DEST_ROLE                   CURRENT_SCN     CON_ID\n------------------------------ ------------------------------ ----------------- --------------------- ----------\nXT001NFB                       NONE                           PRIMARY DATABASE          4686633244816          0\nXT001NSB                       XT001NFB                       PHYSICAL STANDBY          4686633244861          0\n<\/pre><\/div>\n\n\n
Si vous souhaitez conna\u00eetre le r\u00f4le de la base de donn\u00e9es \u00e0 laquelle vous \u00eates connect\u00e9 :<\/p>\n\n\n
\nselect name, open_mode, database_role from v$database;\n\nNAME      OPEN_MODE            DATABASE_ROLE\n--------- -------------------- ----------------\nXT001NFB  READ WRITE           PRIMARY\n<\/pre><\/div>\n\n\n
Si vous souhaitez obtenir encore plus d'informations, affichez ce param\u00e8tre :<\/p>\n\n\n
\nshow parameter log_archive_config\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_config                   string      dg_config=(XT001NSB,XT001NFB)\n\n<\/pre><\/div>\n\n\n
Si vous avez install\u00e9 le courtier de garde de donn\u00e9es pour votre garde de donn\u00e9es (ce que je recommande), vous pouvez alors v\u00e9rifier la configuration de cette mani\u00e8re.<\/p>\n\n\n
\ndgmgrl \/\n\nDGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production\n\nCopyright (c) 2000, 2013, Oracle. All rights reserved.\n\nWelcome to DGMGRL, type "help" for information.\nConnected as SYSDG.\nDGMGRL> show configuration;\n\nConfiguration - DG_XT001\n\n  Protection Mode: MaxAvailability\n  Members:\n  XT001NFB - Primary database\n    XT001NSB - Physical standby database\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS   (status updated 55 seconds ago)\n<\/pre><\/div>\n\n\n
J'esp\u00e8re que cela vous a \u00e9t\u00e9 utile.<\/p>","protected":false},"excerpt":{"rendered":"
Si vous disposez d'une base de donn\u00e9es Oracle et que vous souhaitez conna\u00eetre le r\u00f4le de chaque base de donn\u00e9es, vous pouvez suivre ce guide pour obtenir plus de d\u00e9tails sur l'environnement. Vous pouvez ex\u00e9cuter ces requ\u00eates dans la base de donn\u00e9es primaire ou dans la base de donn\u00e9es en attente, de mani\u00e8re distincte. Cette premi\u00e8re requ\u00eate donne un aper\u00e7u g\u00e9n\u00e9ral de la base de donn\u00e9es primaire et de la base de donn\u00e9es ... <\/p>\n
Continuer la lecture de \" Comment trouver une base de donn\u00e9es primaire \u00e0 partir d'une base de donn\u00e9es en attente dans Oracle \"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Learn how to find the primary database from standby in Oracle and ensure seamless database operations.","rank_math_robots":null,"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,33],"class_list":["post-639","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-broker","tag-data-guard","tag-dgmgrl"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-1227513.jpeg?fit=1880%2C1251&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/639","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=639"}],"version-history":[{"count":25,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/639\/revisions"}],"predecessor-version":[{"id":1141,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/639\/revisions\/1141"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2897"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}