{"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":"buscar-base-de-datos-principal-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/find-primary-database-oracle\/","title":{"rendered":"C\u00f3mo Encontrar la Base de Datos Primaria desde la Standby en Oracle"},"content":{"rendered":"

Si dispone de una guardia de datos Oracle y desea conocer la funci\u00f3n de cada base de datos, puede seguir esta gu\u00eda para obtener m\u00e1s detalles sobre el entorno.<\/p>\n\n\n\n

Puede ejecutar estas consultas en la base de datos primaria o en la base de datos en espera indistintamente.<\/p>\n\n\n\n

Esta primera consulta ofrece una visi\u00f3n general de las bases de datos primarias y secundarias.<\/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 desea conocer el rol de la base de datos a la que est\u00e1 conectado:<\/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 quieres obtener a\u00fan m\u00e1s informaci\u00f3n, muestra este par\u00e1metro:<\/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 tienes data guard broker instalado para tu data guard (lo cual recomiendo), entonces puedes revisar la configuraci\u00f3n as\u00ed.<\/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
Espero que te haya sido \u00fatil.<\/p>","protected":false},"excerpt":{"rendered":"
Si tienes una guardia de datos Oracle y quieres conocer el rol de cada base de datos puedes seguir esta gu\u00eda para obtener m\u00e1s detalles sobre el entorno. Puede ejecutar estas consultas en la base de datos primaria o en la base de datos en espera indistintamente. Esta primera consulta da una visi\u00f3n general tanto de la base de datos primaria como de la base de datos standy ... <\/p>\n
Seguir leyendo \"C\u00f3mo encontrar la base de datos principal a partir de la base de datos en espera en 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\/es\/wp-json\/wp\/v2\/posts\/639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=639"}],"version-history":[{"count":25,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/639\/revisions"}],"predecessor-version":[{"id":1141,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/639\/revisions\/1141"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2897"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}