Nesse exemplo, temos um banco de dados prim\u00e1rio testdb2 e dois bancos de dados standby testdb1 e testdb3. Removeremos um banco de dados Standby da configura\u00e7\u00e3o do data guard (Sem configura\u00e7\u00e3o de RAC)<\/p>\n\n\n\n
Etapas para remover um \u00fanico modo de espera da configura\u00e7\u00e3o do Multi-Standby Data Guard:<\/p>\n\n\n\n
Se voc\u00ea est\u00e1 usando o Data Guard Broker, voc\u00ea precisa remov\u00ea-lo do Broker usando as etapas abaixo:<\/p>\n\n\n\n
A) Para remover do Broker:<\/p>\n\n\n\n
-- No Banco Prim\u00e1rio testdb2\n\n[oracle@testdb2 ~]$ dgmgrl\nDGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production\nCopyright (c) 2000, 2009, Oracle. All rights reserved.\nWelcome to DGMGRL, type "help" for information.\n\nDGMGRL> connect sys\nPassword:\nConnected.\n\nDGMGRL> show configuration;\n\nConfiguration - testdb\n\nProtection Mode: MaxPerformance\n Databases:\n testdb2 - Primary database\n testdb1 - Physical standby database\n testdb3 - Physical standby database\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS\n\nDGMGRL> disable database testdb3;\nDisabled.\n\nDGMGRL> remove database testdb3;\nRemoved database "testdb3" from the configuration\n\nDGMGRL> show configuration verbose;\n\nConfiguration - testdb\n Protection Mode: MaxPerformance\n\n Databases:\n testdb2 - Primary database\n testdb1 - Physical standby database\n\n Properties:\n FastStartFailoverThreshold = '30'\n OperationTimeout = '30'\n FastStartFailoverLagLimit = '30'\n CommunicationTimeout = '180'\n FastStartFailoverAutoReinstate = 'TRUE'\n FastStartFailoverPmyShutdown = 'TRUE'\n BystandersFollowRoleChange = 'ALL'\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS<\/pre><\/div>\n\n\n\nB) No banco de dados principal:<\/p>\n\n\n\n
-- No testdb2 remover o destino do banco de dados standby testdb3 de log_archive_dest_n\n\nSQL> show parameter log_archive_dest_4;\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_4 string service="testdb3", LGWR ASYNC\n NOAFFIRM delay=0 optional comp\n ression=disable max_failure=0\n max_connections=1 reopen=300 d\n b_unique_name="testdb3" net_ti\n meout=30, valid_for=(all_logfi\n les,primary_role)\n\nSQL> alter system set log_archive_dest_4='' scope=both;\nSystem altered.\n\n\n-- Remova o banco de dados standby testdb3 do par\u00e2metro log_archive_config\n\nSQL> show parameter log_archive_config;\n\nNAME TYPE VALUE\n--------------------------- --------- ----------- ------------------------------\nlog_archive_config string dg_config=(testdb1,testdb2,testdb3)\n\nSQL> alter system set log_archive_config='dg_config=(testdb1,testdb2)' scope=both;\nSystem altered.\n<\/pre><\/div>\n\n\n\nC) Remova os arquivos de configura\u00e7\u00e3o dr.dat do broker (ou seja, mostre o par\u00e2metro dg_broker_config) da m\u00e1quina de banco de dados em espera que voc\u00ea est\u00e1 removendo apenas e se for a \u00fanica espera na configura\u00e7\u00e3o do Data Guard nessa m\u00e1quina.<\/p>\n\n\n\n
-- TESTDB3 Standby\n\nSQL> show parameter dg_broker_config_file\n\n\nNAME TYPE VALUE\n---------------------- ------ -----------------------------------------------------\ndg_broker_config_file1 string \/opt\/oracle\/product\/11.2.0.3\/dbs\/dr1testdb3.dat\ndg_broker_config_file2 string \/opt\/oracle\/product\/11.2.0.3\/dbs\/dr2testdb3.dat<\/pre><\/div>\n\n\n\n# rm -r \/opt\/oracle\/product\/11.2.0.3\/dbs\/dr1testdb3.dat\n# rm -r \/opt\/oracle\/product\/11.2.0.3\/dbs\/dr2testdb3.dat<\/pre><\/div>\n\n\n\n
\n\n\n\nInforma\u00e7\u00f5es retiradas do Doc ID 2196935.1 (Necess\u00e1rio acesso ao MOS para verifica\u00e7\u00e3o)<\/p>\n","protected":false},"excerpt":{"rendered":"
Nesse exemplo, temos um banco de dados prim\u00e1rio testdb2 e dois bancos de dados standby testdb1 e testdb3. Removeremos um banco de dados Standby da configura\u00e7\u00e3o do data guard (Sem configura\u00e7\u00e3o de RAC) Etapas para remover um \u00fanico modo de espera da configura\u00e7\u00e3o do Multi-Standby Data Guard: Se voc\u00ea est\u00e1 usando o Data Guard Broker, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-oracle"],"_links":{"self":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/comments?post=38"}],"version-history":[{"count":3,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":51,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/38\/revisions\/51"}],"wp:attachment":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/media?parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/categories?post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/tags?post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}