{"id":880,"date":"2020-09-22T10:44:37","date_gmt":"2020-09-22T08:44:37","guid":{"rendered":"http:\/\/rootfan.com\/?p=880"},"modified":"2022-04-04T00:06:37","modified_gmt":"2022-04-03T22:06:37","slug":"comprobar-pdb-estado-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/check-pdb-status-oracle\/","title":{"rendered":"C\u00f3mo comprobar el estado de la PDB en Oracle"},"content":{"rendered":"<p>A veces una PDB est\u00e1 en un estado incorrecto, como el estado MIGRAR si acabas de hacer una actualizaci\u00f3n.<\/p>\n\n\n\n<p>La mejor forma de comprobar el estado es ejecutar esta consulta desde el CDB<\/p>\n\n\n\n<!--more-->\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nset lines 200\ncolumn HOST_NAME format a50\n\nselect INST_ID, INSTANCE_NUMBER, INSTANCE_NAME, \nHOST_NAME, DATABASE_STATUS, con_id  \nfrom gv$instance;\n\n   INST_ID INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                          DATABASE_STATUS       CON_ID\n---------- --------------- ---------------- -------------------------------------------------- ----------------- ----------\n         1               1 YD001NFR1        con01db01.mydomain.com                             ACTIVE                     0\n         2               2 YD001NFR2        con01db02.mydomain.com                             ACTIVE                     0\n\nset lines 200\ncolumn name format a30\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED \nfrom gv$pdbs;\n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  READ WRITE NO\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n\nalter pluggable database CLML01NFRPLUG close instances=('YD001NFR1');\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED\nfrom gv$pdbs;  \n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  MOUNTED\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n\nalter pluggable database CLML01NFRPLUG open instances=('YD001NFR1');\n\nset lines 200\ncolumn name format a30\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED \nfrom gv$pdbs;\n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  READ WRITE NO\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n<\/pre><\/div>\n\n\n<p>Haz algunas pruebas m\u00e1s cerrando una instancia y volviendo a abrir todas las instancias.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter pluggable database CLML01NFRPLUG close instances=('YD001NFR1');\n\nalter pluggable database CLML01NFRPLUG open instances=all;\n\nset lines 200\ncolumn name format a30\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED \nfrom gv$pdbs;\n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  READ WRITE NO\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n<\/pre><\/div>\n\n\n<p>Espero que te haya sido \u00fatil.<\/p>","protected":false},"excerpt":{"rendered":"<p>A veces una PDB se encuentra en un estado incorrecto, como el estado MIGRATE si acaba de realizar una actualizaci\u00f3n. La mejor forma de comprobar el estado es ejecutar esta consulta desde la CDB<\/p>","protected":false},"author":1,"featured_media":2917,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"How to Check PDB Status in Oracle","rank_math_title":"","rank_math_description":"Find out how to check the status of PDBs in Oracle and ensure the stability and availability of your databases.","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":[53,54],"class_list":["post-880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-pdb","tag-rac"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-540518.jpeg?fit=1880%2C1033&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/880","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=880"}],"version-history":[{"count":17,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/880\/revisions"}],"predecessor-version":[{"id":2919,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/880\/revisions\/2919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2917"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}