Samuel, tenta informar o caminho completo do logfile ao usar o comando recover , ao inves de digitar auto. Faça isso para todos os logfile do banco.
Alessandro Lúcio Cordeiro da Silva Analista de Sistema þ http://alecordeirosilva.blogspot.com/ Porque esta é a vontade de Deus, a saber, a vossa santificação: que vos abstenhais da prostituição. (1º Tessalonicenses 4:3) Em quinta-feira, 19 de abril de 2018 14:59:11 AMT, Alessandro Lúcio Cordeiro da Silva <alecordeirosi...@yahoo.com.br> escreveu: Olá Samuel, Ao executador "SQL> recover database until cancel;" , digite ao inves de AUTO o caminho completo , com o arquivo, o logfile. Exemplo:SQL> recover database until cancel; /u01/app/oracle/log/log1.log; Você deve tentar com um LOG, tentar abrir, se não der ser vai tentando com os demais. Alessandro Lúcio Cordeiro da Silva Analista de Sistema þ http://alecordeirosilva.blogspot.com/ Porque esta é a vontade de Deus, a saber, a vossa santificação: que vos abstenhais da prostituição. (1º Tessalonicenses 4:3) Em Quinta-feira, 19 de Abril de 2018 9:58, "Samuel Santos samuel.gsan...@gmail.com [oracle_br]" <oracle_br@yahoogrupos.com.br> escreveu: PessoAll; Estou com problema para colocar o BD Oracle XE (sistema operacional: Suse Linux), após uma queda de energia, o banco ao tentar 'subir' automaticamente, ele apenas foca mp status MOUNT, e não abre o banco de dados. Passos seguidos para tentar colocar o ambiente no 'AR', mas o que parece o datafile da tablespace SYSTEM está corrompida. Esta máquina NÃO possui backup. SQL> SQL> select status from v$instance; STATUS ------------ MOUNTED SQL> recover database until cancel; ORA-00279: change 13061423182 generated at needed for thread 1 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO ORA-00266: name of archived log file needed ORA-10879: error signaled in parallel recovery slave ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u01/app/oracle/oradata/XE/system.dbf' SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u01/app/oracle/oradata/XE/system.dbf' Caso não haja como recuperar, seria possível efetuar o EXPORT (expdp/exp) de todos os schemas com a base de dados no status MOUNT Desde já agradeço a todos pela atenção. #yiv2618967838 -- #yiv2618967838ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2618967838 #yiv2618967838ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2618967838 #yiv2618967838ygrp-mkp #yiv2618967838hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2618967838 #yiv2618967838ygrp-mkp #yiv2618967838ads {margin-bottom:10px;}#yiv2618967838 #yiv2618967838ygrp-mkp .yiv2618967838ad {padding:0 0;}#yiv2618967838 #yiv2618967838ygrp-mkp .yiv2618967838ad p {margin:0;}#yiv2618967838 #yiv2618967838ygrp-mkp .yiv2618967838ad a {color:#0000ff;text-decoration:none;}#yiv2618967838 #yiv2618967838ygrp-sponsor #yiv2618967838ygrp-lc {font-family:Arial;}#yiv2618967838 #yiv2618967838ygrp-sponsor #yiv2618967838ygrp-lc #yiv2618967838hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2618967838 #yiv2618967838ygrp-sponsor #yiv2618967838ygrp-lc .yiv2618967838ad {margin-bottom:10px;padding:0 0;}#yiv2618967838 #yiv2618967838actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2618967838 #yiv2618967838activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2618967838 #yiv2618967838activity span {font-weight:700;}#yiv2618967838 #yiv2618967838activity span:first-child {text-transform:uppercase;}#yiv2618967838 #yiv2618967838activity span a {color:#5085b6;text-decoration:none;}#yiv2618967838 #yiv2618967838activity span span {color:#ff7900;}#yiv2618967838 #yiv2618967838activity span .yiv2618967838underline {text-decoration:underline;}#yiv2618967838 .yiv2618967838attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2618967838 .yiv2618967838attach div a {text-decoration:none;}#yiv2618967838 .yiv2618967838attach img {border:none;padding-right:5px;}#yiv2618967838 .yiv2618967838attach label {display:block;margin-bottom:5px;}#yiv2618967838 .yiv2618967838attach label a {text-decoration:none;}#yiv2618967838 blockquote {margin:0 0 0 4px;}#yiv2618967838 .yiv2618967838bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2618967838 .yiv2618967838bold a {text-decoration:none;}#yiv2618967838 dd..yiv2618967838last p a {font-family:Verdana;font-weight:700;}#yiv2618967838 dd.yiv2618967838last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2618967838 dd.yiv2618967838last p span.yiv2618967838yshortcuts {margin-right:0;}#yiv2618967838 div.yiv2618967838attach-table div div a {text-decoration:none;}#yiv2618967838 div.yiv2618967838attach-table {width:400px;}#yiv2618967838 div.yiv2618967838file-title a, #yiv2618967838 div.yiv2618967838file-title a:active, #yiv2618967838 div.yiv2618967838file-title a:hover, #yiv2618967838 div.yiv2618967838file-title a:visited {text-decoration:none;}#yiv2618967838 div.yiv2618967838photo-title a, #yiv2618967838 div.yiv2618967838photo-title a:active, #yiv2618967838 div.yiv2618967838photo-title a:hover, #yiv2618967838 div.yiv2618967838photo-title a:visited {text-decoration:none;}#yiv2618967838 div#yiv2618967838ygrp-mlmsg #yiv2618967838ygrp-msg p a span.yiv2618967838yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2618967838 .yiv2618967838green {color:#628c2a;}#yiv2618967838 .yiv2618967838MsoNormal {margin:0 0 0 0;}#yiv2618967838 o {font-size:0;}#yiv2618967838 #yiv2618967838photos div {float:left;width:72px;}#yiv2618967838 #yiv2618967838photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2618967838 #yiv2618967838photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2618967838 #yiv2618967838reco-category {font-size:77%;}#yiv2618967838 #yiv2618967838reco-desc {font-size:77%;}#yiv2618967838 .yiv2618967838replbq {margin:4px;}#yiv2618967838 #yiv2618967838ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2618967838 #yiv2618967838ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2618967838 #yiv2618967838ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2618967838 #yiv2618967838ygrp-mlmsg select, #yiv2618967838 input, #yiv2618967838 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2618967838 #yiv2618967838ygrp-mlmsg pre, #yiv2618967838 code {font:115% monospace;}#yiv2618967838 #yiv2618967838ygrp-mlmsg * {line-height:1..22em;}#yiv2618967838 #yiv2618967838ygrp-mlmsg #yiv2618967838logo {padding-bottom:10px;}#yiv2618967838 #yiv2618967838ygrp-msg p a {font-family:Verdana;}#yiv2618967838 #yiv2618967838ygrp-msg p#yiv2618967838attach-count span {color:#1E66AE;font-weight:700;}#yiv2618967838 #yiv2618967838ygrp-reco #yiv2618967838reco-head {color:#ff7900;font-weight:700;}#yiv2618967838 #yiv2618967838ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2618967838 #yiv2618967838ygrp-sponsor #yiv2618967838ov li a {font-size:130%;text-decoration:none;}#yiv2618967838 #yiv2618967838ygrp-sponsor #yiv2618967838ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2618967838 #yiv2618967838ygrp-sponsor #yiv2618967838ov ul {margin:0;padding:0 0 0 8px;}#yiv2618967838 #yiv2618967838ygrp-text {font-family:Georgia;}#yiv2618967838 #yiv2618967838ygrp-text p {margin:0 0 1em 0;}#yiv2618967838 #yiv2618967838ygrp-text tt {font-size:120%;}#yiv2618967838 #yiv2618967838ygrp-vital ul li:last-child {border-right:none !important;}#yiv2618967838
