Faça o seguinte: Use o seu script até o switch que o Vitor pediu para vc
colocar e não utilize o recover ainda.
Após isso, vc entra no sqlplus e faz a seguinte consulta:SELECT MEMBER FROM
V$LOGFILE;
Pegue todos os nomes que estão setados no diretório do ASM e renomeie pro file
system no próprio sqlplusdepois disso vc volta pro RMAN e manda o RECOVER, caso
nesse database vc tenha algum arquivo de rastreamento que seja utilizado em
backups incrementais, antes do recover vc tb deve desativar. Depois é só abrir
com resetlogs.
Em Sexta-feira, 18 de Março de 2016 8:04, "'Ednilson Silva'
ednilson.si...@jbs.com.br [oracle_br]" <oracle_br@yahoogrupos.com.br> escreveu:
Vitor,Antes de recriar eu tentei fazer o rename. SQL> ALTER DATABASE
RENAME FILE '+DATA/prod/onlinelog/group_4.395.858264785' TO
'/d01/oradata/prod/redolog4a.log';ALTER DATABASE RENAME FILE
'+DATA/prod/onlinelog/group_4.395.858264785' TO
'/d01/oradata/prod/redolog4a.log'*ERROR at line 1:ORA-01511: error in renaming
log/data filesORA-01516: nonexistent log file, data file, or temporary
file"+DATA/prod/onlinelog/group_4.395.858264785" Grato,Ednilson De:
oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br]
Enviada em: quinta-feira, 17 de março de 2016 22:45
Para: oracle_br@yahoogrupos.com.br
Assunto: Re: [oracle_br] Restore DB Era só fazer rename dos redos antes de
abrir. Não precisa dropar e criar nada. :)
https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files#logfiles
Em qui, 17 de mar de 2016 às 18:51, 'Ednilson Silva'
ednilson.si...@jbs.com.br [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu:
Vitor,Funcionou, faltava SWITCH TEMPFILE ALL e SWITCH DATAFILE ALL. Só que
agora deparei com a seguinte situação para abrir o banco. SQL> alter database
open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-00349: failure
obtaining block size for '+dat SQL> select * from v$logfile; GROUP# STATUS
TYPE MEMBER
IS_---------- ------- -------
---------------------------------------------------------------------- ---
1 INVALID ONLINE +data
NO 1 INVALID ONLINE +data
NO 2 INVALID ONLINE +data
NO 2 INVALID ONLINE
+data NO
3 INVALID ONLINE +data
NO 3 INVALID ONLINE +data
NO 4 INVALID ONLINE +data
NO 4 INVALID ONLINE
+data NO Não
sei se fiz certo, mas exclui todos os grupos e recriei novamente SQL> ALTER
DATABASE DROP LOGFILE GROUP 1; Database altered. SQL> ALTER DATABASE ADD
logfile group
1('/d01/oradata/prod05/redo1a.log','/d01/oradata/prod05/redo1b.log') size
300m; Com exceção do grupo 4 SQL> ALTER DATABASE DROP LOGFILE GROUP 4;ALTER
DATABASE DROP LOGFILE GROUP 4*ERROR at line 1:ORA-01623: log 4 is current log
for instance prod05 (thread 1) - cannot dropORA-00312: online log 4 thread 1:
'+data'ORA-00312: online log 4 thread 1: '+data' SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
IS_---------- ------- -------
---------------------------------------------------------------------- ---
1 ONLINE /d01/oradata/prod05/redo1a.log
NO 1 ONLINE /d01/oradata/prod05/redo1b.log
NO 2 ONLINE
/d01/oradata/prod05/redo2a.log NO
2 ONLINE /d01/oradata/prod05/redo2b.log
NO 3 ONLINE /d01/oradata/prod05/redo3a.log
NO 3 ONLINE
/d01/oradata/prod05/redo3b.log NO
4 INVALID ONLINE +data
NO 4 INVALID ONLINE +data
NO SQL> select group#,thread#,status from v$log;
GROUP# THREAD# STATUS---------- ---------- ---------------- 1
1 UNUSED 4 1 CLEARING_CURRENT 3 1
UNUSED 2 1 UNUSED SQL> alter database clear logfile group
4;alter database clear logfile group 4*ERROR at line 1:ORA-00349: failure
obtaining block size for '+dat SQL> alter database clear unarchived logfile
group 4;alter database clear unarchived logfile group 4*ERROR at line
1:ORA-00349: failure obtaining block size for '+dat Grato,Ednilson De:
oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br]
Enviada em: quinta-feira, 17 de março de 2016 17:16
Para: oracle_br@yahoogrupos.com.br
Assunto: Re: [oracle_br] Restore DBLembrou de colocar o swtich datafile all no
final? Em qui, 17 de mar de 2016 às 17:02, 'Ednilson Silva'
ednilson.si...@jbs.com.br [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu:
Rodrigo,Eu usei o comando abaixo, para todos os datafiles. SET NEWNAME FOR
DATAFILE 1 TO '/d01/oradata/prod05/system.387.858264791'; Grato,Ednilson De:
oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br]
Enviada em: quinta-feira, 17 de março de 2016 16:51
Para: oracle_br@yahoogrupos.com.br
Assunto: Re: [oracle_br] Restore DB Boa tarde, No controlfile deste BD ele
espera uma instance ASM. Você tem 3 opções: 1) use o parametro
db_file_name_convert2) use o comando set newname do rman para cada datafile
(pré 11g)3) use o comando set newname for database to '/path/%U'; Acredito
que o mais simples seja a opção 3, no seu script rman. [ ]'s#mufalani
Desculpe por erros! Este e-mail foi escrito do meu smartphone! Sorry for
typos! This mail was written from my smartphone!!!
Em 17 de mar de 2016, às 16:40, 'Ednilson Silva' ednilson.si...@jbs.com.br
[oracle_br] <oracle_br@yahoogrupos.com.br> escreveu:
Pessoal,Estou tentando realizar um restore de um banco 11g (11.2.0.4) que
esta em ASM para File System.O restore ocorre sem problemas, mas no momento do
recover ocorre os erros abaixo, alguém tem alguma ideia de como resolver?
Starting recover at 17-MAR-16 starting media recoverymedia recovery
failedreleased channel: dev_0released channel: dev_1released channel:
dev_2released channel: dev_3released channel: dev_4released channel:
dev_5released channel: dev_6released channel: dev_7released channel:
dev_8released channel: dev_9released channel: dev_10released channel:
dev_11RMAN-00571:
===========================================================RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571:
===========================================================RMAN-03002: failure
of recover command at 03/17/2016 16:08:12ORA-00283: recovery session canceled
due to errorsRMAN-11003: failure during parse/execution of SQL statement: alter
database recover if neededstart until cancel using backup controlfileORA-00283:
recovery session canceled due to errorsORA-01110: data file 1:
'+DATA/prod/datafile/system.387.858264791'ORA-01157: cannot identify/lock data
file 1 - see DBWR trace fileORA-01110: data file 1:
'+DATA/prod/datafile/system.387.858264791' RMAN>RMAN> **end-of-file**
GratoEdnilson
-- Att,/Regards,
Vitor Jr.
Infraestrutura / Infrastructure Team Oracle 12c DBA Certified Professional -
OCP 12cOracle 11g DBA Certified Professional - OCP 11g
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid
Infrastructure Administrator - OCEOracle Database 11g Performance Tuning
Certified Expert - OCE
Oracle Exadata 11g Certified Implementation Specialist
Oracle Certified Associate, MySQL 5
mail, gtalk e msn: vitorj...@gmail.com
http://certificacaobd.com.br/
skype: vjunior1981https://mybizcard.co/vitor.jr.385628
-- Att,/Regards,
Vitor Jr.
Infraestrutura / Infrastructure Team Oracle 12c DBA Certified Professional -
OCP 12cOracle 11g DBA Certified Professional - OCP 11g
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid
Infrastructure Administrator - OCEOracle Database 11g Performance Tuning
Certified Expert - OCE
Oracle Exadata 11g Certified Implementation Specialist
Oracle Certified Associate, MySQL 5
mail, gtalk e msn: vitorj...@gmail.com
http://certificacaobd.com.br/
skype: vjunior1981https://mybizcard.co/vitor.jr.385628 #yiv7967960023
#yiv7967960023 -- #yiv7967960023ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7967960023
#yiv7967960023ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7967960023
#yiv7967960023ygrp-mkp #yiv7967960023hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7967960023 #yiv7967960023ygrp-mkp #yiv7967960023ads
{margin-bottom:10px;}#yiv7967960023 #yiv7967960023ygrp-mkp .yiv7967960023ad
{padding:0 0;}#yiv7967960023 #yiv7967960023ygrp-mkp .yiv7967960023ad p
{margin:0;}#yiv7967960023 #yiv7967960023ygrp-mkp .yiv7967960023ad a
{color:#0000ff;text-decoration:none;}#yiv7967960023 #yiv7967960023ygrp-sponsor
#yiv7967960023ygrp-lc {font-family:Arial;}#yiv7967960023
#yiv7967960023ygrp-sponsor #yiv7967960023ygrp-lc #yiv7967960023hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7967960023
#yiv7967960023ygrp-sponsor #yiv7967960023ygrp-lc .yiv7967960023ad
{margin-bottom:10px;padding:0 0;}#yiv7967960023 #yiv7967960023actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7967960023
#yiv7967960023activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7967960023
#yiv7967960023activity span {font-weight:700;}#yiv7967960023
#yiv7967960023activity span:first-child
{text-transform:uppercase;}#yiv7967960023 #yiv7967960023activity span a
{color:#5085b6;text-decoration:none;}#yiv7967960023 #yiv7967960023activity span
span {color:#ff7900;}#yiv7967960023 #yiv7967960023activity span
.yiv7967960023underline {text-decoration:underline;}#yiv7967960023
.yiv7967960023attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7967960023 .yiv7967960023attach div a
{text-decoration:none;}#yiv7967960023 .yiv7967960023attach img
{border:none;padding-right:5px;}#yiv7967960023 .yiv7967960023attach label
{display:block;margin-bottom:5px;}#yiv7967960023 .yiv7967960023attach label a
{text-decoration:none;}#yiv7967960023 blockquote {margin:0 0 0
4px;}#yiv7967960023 .yiv7967960023bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7967960023
.yiv7967960023bold a {text-decoration:none;}#yiv7967960023 dd.yiv7967960023last
p a {font-family:Verdana;font-weight:700;}#yiv7967960023 dd.yiv7967960023last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7967960023
dd.yiv7967960023last p span.yiv7967960023yshortcuts
{margin-right:0;}#yiv7967960023 div.yiv7967960023attach-table div div a
{text-decoration:none;}#yiv7967960023 div.yiv7967960023attach-table
{width:400px;}#yiv7967960023 div.yiv7967960023file-title a, #yiv7967960023
div.yiv7967960023file-title a:active, #yiv7967960023
div.yiv7967960023file-title a:hover, #yiv7967960023 div.yiv7967960023file-title
a:visited {text-decoration:none;}#yiv7967960023 div.yiv7967960023photo-title a,
#yiv7967960023 div.yiv7967960023photo-title a:active, #yiv7967960023
div.yiv7967960023photo-title a:hover, #yiv7967960023
div.yiv7967960023photo-title a:visited {text-decoration:none;}#yiv7967960023
div#yiv7967960023ygrp-mlmsg #yiv7967960023ygrp-msg p a
span.yiv7967960023yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7967960023
.yiv7967960023green {color:#628c2a;}#yiv7967960023 .yiv7967960023MsoNormal
{margin:0 0 0 0;}#yiv7967960023 o {font-size:0;}#yiv7967960023
#yiv7967960023photos div {float:left;width:72px;}#yiv7967960023
#yiv7967960023photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7967960023
#yiv7967960023photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7967960023
#yiv7967960023reco-category {font-size:77%;}#yiv7967960023
#yiv7967960023reco-desc {font-size:77%;}#yiv7967960023 .yiv7967960023replbq
{margin:4px;}#yiv7967960023 #yiv7967960023ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7967960023 #yiv7967960023ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7967960023
#yiv7967960023ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7967960023
#yiv7967960023ygrp-mlmsg select, #yiv7967960023 input, #yiv7967960023 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7967960023
#yiv7967960023ygrp-mlmsg pre, #yiv7967960023 code {font:115%
monospace;}#yiv7967960023 #yiv7967960023ygrp-mlmsg *
{line-height:1.22em;}#yiv7967960023 #yiv7967960023ygrp-mlmsg #yiv7967960023logo
{padding-bottom:10px;}#yiv7967960023 #yiv7967960023ygrp-msg p a
{font-family:Verdana;}#yiv7967960023 #yiv7967960023ygrp-msg
p#yiv7967960023attach-count span {color:#1E66AE;font-weight:700;}#yiv7967960023
#yiv7967960023ygrp-reco #yiv7967960023reco-head
{color:#ff7900;font-weight:700;}#yiv7967960023 #yiv7967960023ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7967960023 #yiv7967960023ygrp-sponsor
#yiv7967960023ov li a {font-size:130%;text-decoration:none;}#yiv7967960023
#yiv7967960023ygrp-sponsor #yiv7967960023ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7967960023
#yiv7967960023ygrp-sponsor #yiv7967960023ov ul {margin:0;padding:0 0 0
8px;}#yiv7967960023 #yiv7967960023ygrp-text
{font-family:Georgia;}#yiv7967960023 #yiv7967960023ygrp-text p {margin:0 0 1em
0;}#yiv7967960023 #yiv7967960023ygrp-text tt {font-size:120%;}#yiv7967960023
#yiv7967960023ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7967960023
