Aqui tem um outro artigo muito interessante do Uhesse
The Data Guard Broker: Why it is recommended
|
|
|
| | |
|
|
|
| |
The Data Guard Broker: Why it is recommended
When it comes to Data Guard on a recent version, I will always use the Data
Guard Broker. Not the Enterprise Man... | |
|
|
VOce nao precisa configurar o parameter LOG_ARCHIVE_DEST_*=SERVICE, o Broker eh
inteligente o suficiente para realizar qualquer tipo de modificacao,
SWITCHOVER, FAILOVER sem vc setar esses parametros.
Em Quarta-feira, 4 de Janeiro de 2017 0:40, "Rafael Mendonca
raffaell.t...@yahoo.com [oracle_br]" <oracle_br@yahoogrupos.com.br> escreveu:
Carlos, tudo joia?
Entao, recentemente implementei 3 DG em 3 clientes diferentes com 12c e passei
pelo mesmo problema.
A oracle deixou a desejar em alguns aspectos na minha opniao nessa nova versao,
por exemplo, o tal do erro:
ORA-16698: O Broker nao deixa mais voce adicionar o primary ou o standby na
configuracao se vc tiver com algum LOG_ARCHIVE_DEST_* =SERVICE setado, voce
deve limpar o parametro para poder adicionar o database na configuracao do
broker.
Como voce pode ver na propria documentacao da Oracle
Scenarios Using the DGMGRL Command-Line Interface
|
| |
Scenarios Using the DGMGRL Command-Line Interface
| |
|
O que faz mudar o parametro LOG_ARCHIVE_DEST_* automaticamente eh o processo
DMON do Broker, veja o que o mestre Uhesse membro da OAKTABLE fala a respeito
do topico aberto por voce:
"When using the Data Guard Broker, you don’t need to set any LOG_ARCHIVE_*
parameter for the databases that are part of your Data Guard configuration. The
broker is doing that for you. Forget about what you may have heard about
VALID_FOR – you don’t need that with the broker. Actually, setting any of the
LOG_ARCHIVE_* parameters with an enabled broker configuration might even
confuse the broker and lead to warning or error messages"
Veja o artigo completo em:
https://uhesse.com/2014/10/14/let-the-data-guard-broker-control-log_archive_-parameters/
Espero ter ajudado.
Em Terça-feira, 3 de Janeiro de 2017 0:49, "carloseduard...@yahoo.com
[oracle_br]" <oracle_br@yahoogrupos.com.br> escreveu:
Senhores, boa noite.
Segue meu problema abaixo:
Oracle 12.1.0.2 EE
Configuração
1 primary1 logical standby1 physical standby
==> CONFIGURAÇÃO:
* Primary database
LOG_ARCHIVE_DEST_1= 'LOCATION=/u01/app/oracle/archive
VALID_FOR=(ONLINE_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=XUXA1';
LOG_ARCHIVE_DEST_2= 'service=XUXA2 ASYNC
valid_for=(online_logfile,primary_role) db_unique_name=XUXA2'
LOG_ARCHIVE_DEST_3= 'SERVICE=XUXA3 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=XUXA3'
LOG_ARCHIVE_DEST_4= 'LOCATION=/u01/app/oracle/archive2
VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=XUXA1';
* Fisico standby database
LOG_ARCHIVE_DEST_1=LOCATION=/u01/app/oracle/archive
LOG_ARCHIVES_DEST_2=service=XUXA1 ASYNC valid_for=(online_logfile,primary_role)
db_unique_name=XUXA1
* Logico standby database
LOG_ARCHIVE_DEST_1=LOCATION=/u01/app/oracle/archive
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=XUXA3
LOG_ARCHIVE_DEST_2=service=XUXA1 LGWR ASYNC
valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=XUXA1
log_archive_dest_3=LOCATION=/u01/app/oracle/archive2
VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=XUXA3
==> CONFIGURACAO IGUAL PARA TODOS OS DATABASES
LOG_ARCHIVE_CONFIG=DG_CONFIG=(XUXA1,XUXA2,XUXA3)
O problema eh que esses parâmetros estão sendo modificados automaticamente pelo
Oracle, em poucos minutos o parâmetro que estava setado com a configuração
acima, passa a estar sempre com os valores abaixo:
* primary database
log_archive_dest_1=location=/u01/app/oracle/archive
valid_for=(ALL_LOGFILES,ALL_ROLES)
log_archive_dest_2=service=XUXA2 ASYNC NOAFFIRM delay=0 optional
compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name=XUXA2 net_timeout=30 valid_for=(online_logfile,all_roles)
log_archive_dest_3=service=XUXA3 ASYNC NOAFFIRM delay=0 optional
compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name=XUXA3 net_timeout=30 valid_for=(online_logfile,all_roles)
log_archive_dest_4=LOCATION=/u01/app/oracle/archive2
valid_for(standby_logfile,standby_role) db_unique_name=XUXA1
Depois que vejo que a configuração foi modificada, o que faço eh alterar
novamente para a configuração incial, mas de nada adianta. Novamente o Oracle
muda essesparametros novamente, isso acontece em todos os databases envolvidos.
obs: Só eu tenho acesso a maquina e aos databases.
Alguém sabe dizer o motivo pelo qual o Oracle está fazendo isso? E como faço
para resolver o problema em questão?
#yiv2495596812 #yiv2495596812 -- #yiv2495596812ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2495596812
#yiv2495596812ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2495596812
#yiv2495596812ygrp-mkp #yiv2495596812hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2495596812 #yiv2495596812ygrp-mkp #yiv2495596812ads
{margin-bottom:10px;}#yiv2495596812 #yiv2495596812ygrp-mkp .yiv2495596812ad
{padding:0 0;}#yiv2495596812 #yiv2495596812ygrp-mkp .yiv2495596812ad p
{margin:0;}#yiv2495596812 #yiv2495596812ygrp-mkp .yiv2495596812ad a
{color:#0000ff;text-decoration:none;}#yiv2495596812 #yiv2495596812ygrp-sponsor
#yiv2495596812ygrp-lc {font-family:Arial;}#yiv2495596812
#yiv2495596812ygrp-sponsor #yiv2495596812ygrp-lc #yiv2495596812hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2495596812
#yiv2495596812ygrp-sponsor #yiv2495596812ygrp-lc .yiv2495596812ad
{margin-bottom:10px;padding:0 0;}#yiv2495596812 #yiv2495596812actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2495596812
#yiv2495596812activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2495596812
#yiv2495596812activity span {font-weight:700;}#yiv2495596812
#yiv2495596812activity span:first-child
{text-transform:uppercase;}#yiv2495596812 #yiv2495596812activity span a
{color:#5085b6;text-decoration:none;}#yiv2495596812 #yiv2495596812activity span
span {color:#ff7900;}#yiv2495596812 #yiv2495596812activity span
.yiv2495596812underline {text-decoration:underline;}#yiv2495596812
.yiv2495596812attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2495596812 .yiv2495596812attach div a
{text-decoration:none;}#yiv2495596812 .yiv2495596812attach img
{border:none;padding-right:5px;}#yiv2495596812 .yiv2495596812attach label
{display:block;margin-bottom:5px;}#yiv2495596812 .yiv2495596812attach label a
{text-decoration:none;}#yiv2495596812 blockquote {margin:0 0 0
4px;}#yiv2495596812 .yiv2495596812bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2495596812
.yiv2495596812bold a {text-decoration:none;}#yiv2495596812 dd.yiv2495596812last
p a {font-family:Verdana;font-weight:700;}#yiv2495596812 dd.yiv2495596812last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2495596812
dd.yiv2495596812last p span.yiv2495596812yshortcuts
{margin-right:0;}#yiv2495596812 div.yiv2495596812attach-table div div a
{text-decoration:none;}#yiv2495596812 div.yiv2495596812attach-table
{width:400px;}#yiv2495596812 div.yiv2495596812file-title a, #yiv2495596812
div.yiv2495596812file-title a:active, #yiv2495596812
div.yiv2495596812file-title a:hover, #yiv2495596812 div.yiv2495596812file-title
a:visited {text-decoration:none;}#yiv2495596812 div.yiv2495596812photo-title a,
#yiv2495596812 div.yiv2495596812photo-title a:active, #yiv2495596812
div.yiv2495596812photo-title a:hover, #yiv2495596812
div.yiv2495596812photo-title a:visited {text-decoration:none;}#yiv2495596812
div#yiv2495596812ygrp-mlmsg #yiv2495596812ygrp-msg p a
span.yiv2495596812yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2495596812
.yiv2495596812green {color:#628c2a;}#yiv2495596812 .yiv2495596812MsoNormal
{margin:0 0 0 0;}#yiv2495596812 o {font-size:0;}#yiv2495596812
#yiv2495596812photos div {float:left;width:72px;}#yiv2495596812
#yiv2495596812photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2495596812
#yiv2495596812photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2495596812
#yiv2495596812reco-category {font-size:77%;}#yiv2495596812
#yiv2495596812reco-desc {font-size:77%;}#yiv2495596812 .yiv2495596812replbq
{margin:4px;}#yiv2495596812 #yiv2495596812ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2495596812 #yiv2495596812ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2495596812
#yiv2495596812ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2495596812
#yiv2495596812ygrp-mlmsg select, #yiv2495596812 input, #yiv2495596812 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2495596812
#yiv2495596812ygrp-mlmsg pre, #yiv2495596812 code {font:115%
monospace;}#yiv2495596812 #yiv2495596812ygrp-mlmsg *
{line-height:1.22em;}#yiv2495596812 #yiv2495596812ygrp-mlmsg #yiv2495596812logo
{padding-bottom:10px;}#yiv2495596812 #yiv2495596812ygrp-msg p a
{font-family:Verdana;}#yiv2495596812 #yiv2495596812ygrp-msg
p#yiv2495596812attach-count span {color:#1E66AE;font-weight:700;}#yiv2495596812
#yiv2495596812ygrp-reco #yiv2495596812reco-head
{color:#ff7900;font-weight:700;}#yiv2495596812 #yiv2495596812ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2495596812 #yiv2495596812ygrp-sponsor
#yiv2495596812ov li a {font-size:130%;text-decoration:none;}#yiv2495596812
#yiv2495596812ygrp-sponsor #yiv2495596812ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2495596812
#yiv2495596812ygrp-sponsor #yiv2495596812ov ul {margin:0;padding:0 0 0
8px;}#yiv2495596812 #yiv2495596812ygrp-text
{font-family:Georgia;}#yiv2495596812 #yiv2495596812ygrp-text p {margin:0 0 1em
0;}#yiv2495596812 #yiv2495596812ygrp-text tt {font-size:120%;}#yiv2495596812
#yiv2495596812ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2495596812
