Obrigado pelas dicas, Chiappa e Marcelo.
Aproveitando o embalo, tenho uma outra dúvida:
"If you use Oracle ASM and OMF in a data guard configuration, you shold use ASM
and OMF symmetrically on the primary and standby database. If any database in
your data guard configuration uses ASM, OMF, or both, them every database in
the configuration should use the same combination (that is, ASM, OMF, or both).
Esse trecho foi retirado do curso DataGuard que a oracle possui em pdf.
Um procedimento parecido (duplicate) é totalmente possível e que a maioria de
todos nós sabemos que de ASM para file system e de file system para ASM é
totalmente possível.
Se o dataguard não é permite realizar essa operação, gostaria de saber o motivo
da arquitetura não suportar essa combinação.
Em Terça-feira, 2 de Junho de 2015 13:31, "jlchia...@yahoo.com.br
[oracle_br]" <oracle_br@yahoogrupos.com.br> escreveu:
Opa : então, note que ALÉM de disponibilizar os archived redo logs
faltantes (e PLURAL, ** os ** archiveds, pois podem haver mais de um
faltantes), é ** comum ** vc ter que restartar o processo de recover & apply
(digamos, ele já tentou aplicar várias vezes sempre com falha, aí ele pára
mesmo) - veja
http://www.idevelopment.info/data/Oracle/DBA_tips/Data_Guard/DG_5.shtml e
http://asnsblues.blogspot.com.br/2013/12/manually-resolving-gaps-oracle-data.html
para refs... Evidentemente, nos exemplo os Autores pedem alter database
recover managed standby database cancel; , sem especificar paralelismo nem nada
mais, pode ser Tranquilamente que no seu ambiente talvez seja adequado vc o
especificar... E realmente o melhor meio de vc confirmar que os redos estão
sendo enviados é mesmo pedir um switch e consultar alert.logs , E pra ver o
progresso do apply/recover são as v$ citadas (trocando para GV$ em caso de
RAC)... E não é para acontecer, mas ** CASO ** por qquer motivo vc não tenha
sucesso com o procedimento, aí ao invés de recriar o dataguard (o que até pode
ser fácil via DUPLICATE ONLINE) vc pode ao invés fazer um backup incremental +
restore , veja
http://arup.blogspot.com.br/2009/12/resolving-gaps-in-data-guard-apply.html ...
[]s Chiappa #yiv0935430799 #yiv0935430799 -- #yiv0935430799ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv0935430799 #yiv0935430799ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv0935430799 #yiv0935430799ygrp-mkp #yiv0935430799hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0935430799 #yiv0935430799ygrp-mkp #yiv0935430799ads
{margin-bottom:10px;}#yiv0935430799 #yiv0935430799ygrp-mkp .yiv0935430799ad
{padding:0 0;}#yiv0935430799 #yiv0935430799ygrp-mkp .yiv0935430799ad p
{margin:0;}#yiv0935430799 #yiv0935430799ygrp-mkp .yiv0935430799ad a
{color:#0000ff;text-decoration:none;}#yiv0935430799 #yiv0935430799ygrp-sponsor
#yiv0935430799ygrp-lc {font-family:Arial;}#yiv0935430799
#yiv0935430799ygrp-sponsor #yiv0935430799ygrp-lc #yiv0935430799hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0935430799
#yiv0935430799ygrp-sponsor #yiv0935430799ygrp-lc .yiv0935430799ad
{margin-bottom:10px;padding:0 0;}#yiv0935430799 #yiv0935430799actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0935430799
#yiv0935430799activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0935430799
#yiv0935430799activity span {font-weight:700;}#yiv0935430799
#yiv0935430799activity span:first-child
{text-transform:uppercase;}#yiv0935430799 #yiv0935430799activity span a
{color:#5085b6;text-decoration:none;}#yiv0935430799 #yiv0935430799activity span
span {color:#ff7900;}#yiv0935430799 #yiv0935430799activity span
.yiv0935430799underline {text-decoration:underline;}#yiv0935430799
.yiv0935430799attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0935430799 .yiv0935430799attach div a
{text-decoration:none;}#yiv0935430799 .yiv0935430799attach img
{border:none;padding-right:5px;}#yiv0935430799 .yiv0935430799attach label
{display:block;margin-bottom:5px;}#yiv0935430799 .yiv0935430799attach label a
{text-decoration:none;}#yiv0935430799 blockquote {margin:0 0 0
4px;}#yiv0935430799 .yiv0935430799bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0935430799
.yiv0935430799bold a {text-decoration:none;}#yiv0935430799 dd.yiv0935430799last
p a {font-family:Verdana;font-weight:700;}#yiv0935430799 dd.yiv0935430799last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0935430799
dd.yiv0935430799last p span.yiv0935430799yshortcuts
{margin-right:0;}#yiv0935430799 div.yiv0935430799attach-table div div a
{text-decoration:none;}#yiv0935430799 div.yiv0935430799attach-table
{width:400px;}#yiv0935430799 div.yiv0935430799file-title a, #yiv0935430799
div.yiv0935430799file-title a:active, #yiv0935430799
div.yiv0935430799file-title a:hover, #yiv0935430799 div.yiv0935430799file-title
a:visited {text-decoration:none;}#yiv0935430799 div.yiv0935430799photo-title a,
#yiv0935430799 div.yiv0935430799photo-title a:active, #yiv0935430799
div.yiv0935430799photo-title a:hover, #yiv0935430799
div.yiv0935430799photo-title a:visited {text-decoration:none;}#yiv0935430799
div#yiv0935430799ygrp-mlmsg #yiv0935430799ygrp-msg p a
span.yiv0935430799yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0935430799
.yiv0935430799green {color:#628c2a;}#yiv0935430799 .yiv0935430799MsoNormal
{margin:0 0 0 0;}#yiv0935430799 o {font-size:0;}#yiv0935430799
#yiv0935430799photos div {float:left;width:72px;}#yiv0935430799
#yiv0935430799photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0935430799
#yiv0935430799photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0935430799
#yiv0935430799reco-category {font-size:77%;}#yiv0935430799
#yiv0935430799reco-desc {font-size:77%;}#yiv0935430799 .yiv0935430799replbq
{margin:4px;}#yiv0935430799 #yiv0935430799ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0935430799 #yiv0935430799ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0935430799
#yiv0935430799ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0935430799
#yiv0935430799ygrp-mlmsg select, #yiv0935430799 input, #yiv0935430799 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0935430799
#yiv0935430799ygrp-mlmsg pre, #yiv0935430799 code {font:115%
monospace;}#yiv0935430799 #yiv0935430799ygrp-mlmsg *
{line-height:1.22em;}#yiv0935430799 #yiv0935430799ygrp-mlmsg #yiv0935430799logo
{padding-bottom:10px;}#yiv0935430799 #yiv0935430799ygrp-msg p a
{font-family:Verdana;}#yiv0935430799 #yiv0935430799ygrp-msg
p#yiv0935430799attach-count span {color:#1E66AE;font-weight:700;}#yiv0935430799
#yiv0935430799ygrp-reco #yiv0935430799reco-head
{color:#ff7900;font-weight:700;}#yiv0935430799 #yiv0935430799ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0935430799 #yiv0935430799ygrp-sponsor
#yiv0935430799ov li a {font-size:130%;text-decoration:none;}#yiv0935430799
#yiv0935430799ygrp-sponsor #yiv0935430799ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0935430799
#yiv0935430799ygrp-sponsor #yiv0935430799ov ul {margin:0;padding:0 0 0
8px;}#yiv0935430799 #yiv0935430799ygrp-text
{font-family:Georgia;}#yiv0935430799 #yiv0935430799ygrp-text p {margin:0 0 1em
0;}#yiv0935430799 #yiv0935430799ygrp-text tt {font-size:120%;}#yiv0935430799
#yiv0935430799ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0935430799
