Olá Ederson,
Agora eu consegui acessar:
[oracle@olimpo01 mapper]$ asmcmd
ASMCMD> ls -la
WARNING:option 'a' is deprecated for 'ls'
please use 'absolutepath'
State Type Rebal Name
MOUNTED EXTERN N DATA/
ASMCMD> cd DATA
ASMCMD> ls -la
WARNING:option 'a' is deprecated for 'ls'
please use 'absolutepath'
Type Redund Striped Time Sys Name
Y BDPROD/
ASMCMD> cd BDPROD
ASMCMD> ls -la
WARNING:option 'a' is deprecated for 'ls'
please use 'absolutepath'
Type Redund Striped Time Sys Name
Y CONTROLFILE/
Y DATAFILE/
Y ONLINELOG/
Y TEMPFILE/
N control01.ctl =>
+DATA/BDPROD/CONTROLFILE/current.256.806434845
N control02.ctl =>
+DATA/BDPROD/CONTROLFILE/current.257.806434845
ASMCMD> cd CONTROLFILE/
ASMCMD> ls -la
WARNING:option 'a' is deprecated for 'ls'
please use 'absolutepath'
Type Redund Striped Time Sys Name
CONTROLFILE UNPROT FINE FEB 03 17:00:00 Y
+DATA/BDPROD/control01.ctl => current.256.806434845
CONTROLFILE UNPROT FINE FEB 03 17:00:00 Y
+DATA/BDPROD/control02.ctl => current.257.806434845
Att,
--
Wanderson Barrence
DBA Oracle 10g/11g
Analista de Testes - CBTS
------------------------------------------------------------------
Skype: wbarrence
Facebook:http://www.facebook.com/wbarrence
Linkedin: http://br.linkedin.com/in/wbarrence
Em 18 de abril de 2013 15:00, Wanderson Barrence <wbarre...@gmail.com>escreveu:
> Muito obrigado Vitor você ajudou bastante.
>
> Att,
>
> --
> Wanderson Barrence
> DBA Oracle 10g/11g
> Analista de Testes - CBTS
> ------------------------------------------------------------------
>
> Skype: wbarrence
> Facebook:http://www.facebook.com/wbarrence
> Linkedin: http://br.linkedin.com/in/wbarrence
>
>
> Em 18 de abril de 2013 14:53, Vitor Jr. <vitorj...@gmail.com> escreveu:
>
> **
>>
>>
>> Wanderson... ter configurado ou não o ambiente não quer dizer nada. Tendo
>> o conhecimento tu acha onde está instalado o GRID e exporta as variáveis.
>> O CRS está no ar? Se sim pelo processo já dá pra ter uma idéia de onde
>> está instalado. Executa um os na máquina e procura pelo processo. Também dá
>> pra ter idéia se ele roda com o usuário de s.o. oracle ou um user diferente.
>> Caso seja com o usuário oracle, verifica no home se não tem algum arquivo
>> que contenha variáveis do grid. Aqui na empresa usamos por padrão asm.env
>> ou grid.env, mas pode ser extensão .sh ou qualquer outra. Faz um grep nos
>> arquivos por ORACLE_HOME.
>> Tirando isso, fica difícil de ajudar, sem acesso ao ambiente pra
>> investigar, afinal isso é um pouco de feeling e conceitos básicos,
>> inclusive de s.o.
>> Caso não consiga vai ter que acabar pagando um suporte pra fazer essa
>> análise.
>>
>>
>>
>>
>> Att,/Regards,
>>
>> Vitor Jr.
>> Infraestrutura / Infrastructure Team
>> Oracle 11g DBA Certified Professional - OCP
>> Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid
>> Infrastructure Administrator - OCE
>> Oracle 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: vjunior1981
>>
>> -----Mensagem original-----
>> De: oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br]
>> Em nome de Wanderson Barrence
>> Enviada em: quinta-feira, 18 de abril de 2013 14:48
>> Para: oracle_br@yahoogrupos.com.br
>> Assunto: Re: [oracle_br] Re: ORA-00257: archiver error. Connect internal
>> only, until freed.
>>
>>
>> Então Ederson,
>>
>> Não fui eu quem configurou esse Oracle RAC, qdo cheguei na empresa ele já
>> estava configurado, eu só tentei resolver um problema que estava dando
>> ORA-00257: archiver error. Connect internal only, until freed, então eu
>> baixei o banco, a agora estou tentando colocar ele no estado mount, mas só
>> que está dando esse problema: ORA-00205: error in identifying control file,
>> check alert log for more info.
>>
>> Eu estou um pouco inseguro de alterar os parâmetro do .bash_profile.
>>
>> Att,
>>
>> --
>> Wanderson Barrence
>> DBA Oracle 10g/11g
>> Analista de Testes - CBTS
>> ----------------------------------------------------------
>> Skype: wbarrence
>> Facebook:http://www.facebook.com/wbarrence
>> Linkedin: http://br.linkedin.com/in/wbarrence
>>
>> Em 18 de abril de 2013 14:35, ederson2001br
>> <ederson200...@yahoo.com.br>escreveu:
>>
>> > **
>>
>> >
>> >
>> > Wanderson,
>> >
>> > Voce não setou a variável ORACLE_HOME para o home do GRID.
>> >
>> > Reposta do forum da Oracle:
>> >
>> > https://forums.oracle.com/forums/thread.jspa?threadID=2212053
>> >
>> > Re: When run ASMCMD clsecho: No such file or deirectory
>> > Posted: 23/04/2011 12:34
>> > in response to: Denis Sun in response to: Denis Sun
>> >
>> > Since 11gR2, Oracle ASM is installed as a part of Oracle Grid
>> > Infrastructure. When, you invoke ASMCMD you should set your
>> > ORACLE_HOME and ORACLE_SID for ASM first and then invoke ASMCMD, This
>> > should work for you then.
>> >
>> > In *nux systems:
>> >
>> > For Example:
>> >
>> > $ ORACLE_SID=+ASM
>> > $ export ORACLE_SID
>> > $ ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
>> > $ export ORACLE_HOME
>> >
>> >
>> > http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/oracle
>> > restart.htm
>> >
>> > http://download.oracle.com/docs/cd/E11882_01/server.112/e16102/asm_uti
>> > l001.htm#OSTMG01610
>> >
>> >
>> > Ederson Elias
>> > DBA Oracle
>> > http://br.linkedin.com/pub/ederson-elias/24/8b/8b0
>> > ------------
>> > Labor improbus omnia vincit
>> >
>> > --- Em oracle_br@yahoogrupos.com.br, Wanderson Barrence
>> > <wbarrence@...> escreveu
>> > >
>> > > [oracle@olimpo01 mapper]$ asmcmd
>> > > Connected to an idle instance.
>> > > sh: /u02/app/oracle/product/11.2.0/db_1/bin/clsecho: No such file or
>> > > directory
>> > > ASMCMD> ls -la
>> > > Can't exec "/u02/app/oracle/product/11.2.0/db_1/bin/clsecho": No
>> > > such
>> > file
>> > > or directory at
>> > > /u02/app/oracle/product/11.2.0/db_1/lib/asmcmdshare.pmline
>> > > 493, <STDIN> line 1.
>> > > Use of uninitialized value $buf in string ne at
>> > > /u02/app/oracle/product/11.2.0/db_1/lib/asmcmdshare.pm line 497,
>> > > <STDIN> line 1.
>> > >
>> > >
>> > > --
>> > > Wanderson Barrence
>> > > DBA Oracle 10g/11g
>> > > Analista de Testes - CBTS
>> > > ----------------------------------------------------------
>> > > Skype: wbarrence
>> > > Facebook:http://www.facebook.com/wbarrence
>> > > Linkedin: http://br.linkedin.com/in/wbarrence
>> > >
>> > >
>> > > Em 18 de abril de 2013 14:16, ederson2001br
>> > > <ederson2001br@...>escreveu:
>> > >
>> > > > **
>> >
>> > > >
>> > > >
>> > > > Wanderson,
>> > > >
>> > > > Para "entrar" no +DATA, vc precisa setar a ORACLE_SID para +ASM e
>> > chamar o
>> > > > asmcmd:
>> > > >
>> > > > $ export ORACLE_SID=+ASM
>> > > > $ asmcmd
>> > > > ASMCMD> ls -la
>> > > > ASMCMD> cd data
>> > > > ASMCMD> ls -la
>> > > >
>> > > > No asmcmd, o comando "m" mostra o menu das opções disponíveis,
>> > > > cuidado
>> > com
>> > > > o "rm". O comando "lsdg" mostra o espaço ocupado pelo ASM.
>> > > >
>> > > > Ederson Elias
>> > > > DBA Oracle
>> > > > http://br.linkedin.com/pub/ederson-elias/24/8b/8b0
>> > > > ------------
>> > > > Labor improbus omnia vincit
>> > > >
>> > > > --- Em oracle_br@yahoogrupos.com.br, Wanderson Barrence
>> > > > <wbarrence@> escreveu
>> > > >
>> > > > >
>> > > > > Não estou conseguindo entrar no "+DATA"!!!
>> > > > >
>> > > > > --
>> > > > > Wanderson Barrence
>> > > > > DBA Oracle 10g/11g
>> > > > > Analista de Testes - CBTS
>> > > > > ----------------------------------------------------------
>> > > > > Skype: wbarrence
>> > > > > Facebook:http://www.facebook.com/wbarrence
>> > > > > Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > >
>> > > > >
>> > > > > Em 18 de abril de 2013 13:40, Wanderson Barrence <wbarrence@
>> > > > ...>escreveu:
>> > > >
>> > > > >
>> > > > > > Então Vitor,
>> > > > > >
>> > > > > > É um ambiente RAC de um nó somente!!!
>> > > > > >
>> > > > > > Eu não estou conseguindo encontrar o localização do arquivo no:
>> > > > > > '+DATA/bdprod/control01.ctl'
>> > > > > >
>> > > > > > Att,
>> > > > > >
>> > > > > > --
>> > > > > > Wanderson Barrence
>> > > > > > DBA Oracle 10g/11g
>> > > > > > Analista de Testes - CBTS
>> > > > > > ----------------------------------------------------------
>> > > > > >
>> > > > > > Skype: wbarrence
>> > > > > > Facebook:http://www.facebook.com/wbarrence
>> > > > > > Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > > >
>> > > > > >
>> > > > > > Em 18 de abril de 2013 13:33, Vitor Junior <vitorjr81@>
>> escreveu:
>> >
>> > > > > >
>> > > > > > **
>> > > >
>> > > > > >>
>> > > > > >>
>> > > > > >> pelo fato de usar ASM não obrigatório mas quase certo que se
>> > tratava
>> > > > de um
>> > > > > >> rac. mas isso não responde a minha pergunta anterior. os
>> > > > > >> control
>> > > > estão no
>> > > > > >> local apontado?
>> > > > > >> Em 18/04/2013 13:17, "Wanderson Barrence" <wbarrence@>
>> escreveu:
>> >
>> > > >
>> > > > > >>
>> > > > > >>
>> > > > > >> > Na verdade agora que eu me ative aos detalhes, é um
>> > > > > >> > ambiente
>> > Oracle
>> > > > RAC
>> > > > > >> > com:
>> > > > > >> >
>> > > > > >> > SO: CentOS release 5.8 (Final)
>> > > > > >> >
>> > > > > >> > Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
>> > 64bit
>> > > > > >> > Production
>> > > > > >> > PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0
>> > > > > >> > Production TNS for Linux: Version 11.2.0.3.0 - Production
>> > > > > >> > NLSRTL Version 11.2.0.3.0 - Production
>> > > > > >> >
>> > > > > >> > crs_stat -t
>> > > > > >> >
>> > > > > >> > Name Type Target State Host
>> > > > > >> > ----------------------------------------------------------
>> > > > > >> > ora.DATA.dg ora....up.type ONLINE ONLINE olimpo01
>> > > > > >> > ora.DATA2.dg ora....up.type ONLINE OFFLINE ora....ER.lsnr
>> > > > > >> > ora....er.type ONLINE OFFLINE ora.asm ora.asm.type ONLINE
>> > > > > >> > ONLINE olimpo01 ora.cssd ora.cssd.type ONLINE ONLINE
>> > > > > >> > olimpo01 ora.diskmon ora....on.type OFFLINE OFFLINE
>> > > > > >> > ora.evmd ora.evm.type ONLINE ONLINE olimpo01 ora.ons
>> > > > > >> > ora.ons.type OFFLINE OFFLINE
>> > > > > >> >
>> > > > > >> >
>> > > > > >> >
>> > > > > >> > --
>> > > > > >> > Wanderson Barrence
>> > > > > >> > DBA Oracle 10g/11g
>> > > > > >> > Analista de Testes - CBTS
>> > > > > >> > ----------------------------------------------------------
>> > > > > >> > Skype: wbarrence
>> > > > > >> > Facebook:http://www.facebook.com/wbarrence
>> > > > > >> > Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > > >> >
>> > > > > >> >
>> > > > > >> > Em 18 de abril de 2013 13:01, Vitor Jr. <vitorjr81@>
>> escreveu:
>> >
>> > > >
>> > > > > >> >
>> > > > > >> > > **
>> > > > > >>
>> > > > > >> > >
>> > > > > >> > >
>> > > > > >> > > Estes controlfiles existem no caminho especificado?
>> > > > > >> > >
>> > > > > >> > >
>> > > > > >> > >
>> > > > > >> > >
>> > > > > >> > > Att,/Regards,
>> > > > > >> > >
>> > > > > >> > > Vitor Jr.
>> > > > > >> > > Infraestrutura / Infrastructure Team Oracle 11g DBA
>> > > > > >> > > Certified Professional - OCP Oracle Certified Expert,
>> > > > > >> > > Oracle Real Application Clusters 11g
>> > and
>> > > > Grid
>> > > > > >> > > Infrastructure Administrator - OCE Oracle Database 11g
>> > > > > >> > > Performance Tuning Certified Expert - OCE Oracle Exadata
>> > > > > >> > > 11g Certified Implementation Specialist Oracle Certified
>> > > > > >> > > Associate, MySQL 5 mail, gtalk e msn: vitorjr81@
>> > > >
>> > > > > >> > > http://certificacaobd.com.br/
>> > > > > >> > > skype: vjunior1981
>> > > > > >> > >
>> > > > > >> > > -----Mensagem original-----
>> > > > > >> > > De: oracle_br@yahoogrupos.com.br [mailto:
>> > > > oracle_br@yahoogrupos.com.br
>> > > > > >> ]
>> > > > > >> > Em
>> > > > > >> > > nome de Wanderson Barrence Enviada em: quinta-feira, 18
>> > > > > >> > > de abril de 2013 12:58
>> > > > > >> > >
>> > > > > >> > > Para: oracle_br@yahoogrupos.com.br
>> > > > > >> > > Assunto: Re: [oracle_br] ORA-00257: archiver error.
>> > > > > >> > > Connect
>> > > > internal
>> > > > > >> > only,
>> > > > > >> > > until freed.
>> > > > > >> > >
>> > > > > >> > > SQL> select group_number,name,total_mb,state,type from
>> > > > > >> v$asm_diskgroup;
>> > > > > >> > >
>> > > > > >> > > GROUP_NUMBER NAME TOTAL_MB STATE TYPE
>> > > > > >> > > ------------ ------------------------------ ----------
>> > -----------
>> > > > > >> ------
>> > > > > >> > > 1 DATA 1923681 MOUNTED EXTERN
>> > > > > >> > >
>> > > > > >> > > --
>> > > > > >> > > Wanderson Barrence
>> > > > > >> > > DBA Oracle 10g/11g
>> > > > > >> > > Analista de Testes - CBTS
>> > > > > >> > > ---------------------------------------------------------
>> > > > > >> > > -
>> > > > > >> > > Skype: wbarrence
>> > > > > >> > > Facebook:http://www.facebook.com/wbarrence
>> > > > > >> > > Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > > >> > >
>> > > > > >> > > Em 18 de abril de 2013 12:46, Vitor Jr. <vitorjr81@>
>> > > >
>> > > > > >> escreveu:
>> > > > > >> > >
>> > > > > >> > > > **
>> > > > > >> > >
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > > A mensagem diz que o diskgroup DATA do ASM não existe
>> > > > > >> > > > mais
>> > ou
>> > > > não
>> > > > > >> está
>> > > > > >> > > > montado.
>> > > > > >> > > > O ASM está no ar? Os discos estão montados?
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > > Att,/Regards,
>> > > > > >> > > >
>> > > > > >> > > > Vitor Jr.
>> > > > > >> > > > Infraestrutura / Infrastructure Team Oracle 11g DBA
>> > > > > >> > > > Certified Professional - OCP Oracle Certified
>> > > > Expert,
>> > > > > >> > > > Oracle Real Application Clusters 11g and Grid
>> > > > > >> > > > Infrastructure Administrator - OCE Oracle Database 11g
>> > > > > >> > > > Performance Tuning
>> > > > Certified
>> > > > > >> > > > Expert - OCE Oracle Exadata 11g Certified
>> > > > > >> > > > Implementation
>> > > > Specialist
>> > > > > >> > > > Oracle Certified Associate, MySQL 5 mail, gtalk e msn:
>> > > > > >> > > > vitorjr81@ http://certificacaobd.com.br/
>> >
>> > > >
>> > > > > >> > > > skype: vjunior1981
>> > > > > >> > > >
>> > > > > >> > > > -----Mensagem original-----
>> > > > > >> > > >
>> > > > > >> > > > De: oracle_br@yahoogrupos.com.br [mailto:
>> > > > > >> oracle_br@yahoogrupos.com.br]
>> > > > > >> > > > Em nome de Wanderson Barrence Enviada em: quinta-feira,
>> > > > > >> > > > 18
>> > de
>> > > > abril
>> > > > > >> > > > de 2013 12:45
>> > > > > >> > > > Para: oracle_br@yahoogrupos.com.br
>> > > > > >> > > > Assunto: Re: [oracle_br] ORA-00257: archiver error.
>> > > > > >> > > > Connect
>> > > > internal
>> > > > > >> > > > only, until freed.
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > > No Alert tá dando essa informação:
>> > > > > >> > > >
>> > > > > >> > > > Thu Apr 18 12:20:45 2013 Starting background process
>> > > > > >> > > > ASMB Thu Apr 18 12:20:45 2013 ASMB started with pid=21,
>> > > > > >> > > > OS id=7033 Thu Apr 18 12:25:45 2013 Use ADRCI or
>> > > > > >> > > > Support Workbench to package the incident.
>> > > > > >> > > > See Note 411.1 at My Oracle Support for error and
>> > > > > >> > > > packaging
>> > > > details.
>> > > > > >> > > > Thu Apr 18 12:25:48 2013 Errors in file
>> > > > > >> > > >
>> > > > /u01/app/oracle/diag/rdbms/bdprod/bdprod/trace/bdprod_m001_6973.trc:
>> > > > > >> > > > ORA-12751: cpu time or run time policy violation
>> > > > > >> > > > ORA-00210: cannot open the specified control file
>> > > > > >> > > > ORA-00202: control file: '+DATA/bdprod/control02.ctl'
>> > > > > >> > > > ORA-17503: ksfdopn:2 Failed to open file
>> > > > +DATA/bdprod/control02.ctl
>> > > > > >> > > > ORA-15001: diskgroup "DATA" does not exist or is not
>> > > > > >> > > > mounted
>> > > > > >> > > > ORA-15064: communication failure with ASM instance
>> > > > > >> > > > ORA-00600: internal error code, arguments:
>> > > > > >> > > > [ORA_NPI_ERROR],
>> > > > [600],
>> > > > > >> > > > [ORA-00600: internal error code, arguments:
>> > [kfnsInstanceReg00],
>> > > > > >> > > > [bdprod:bdprod], [30000], [], [], [], [], [], [], [],
>> > > > > >> > > > [],
>> > [] ],
>> > > > [],
>> > > > > >> > > > [], [], [], [], [], [], [], []
>> > > > > >> > > > ORA-00210: cannot open the specified control file
>> > > > > >> > > > ORA-00202: control file: '+DATA/bdprod/control01.ctl'
>> > > > > >> > > > ORA-17503: ksfdopn:2 Failed to open file
>> > > > +DATA/bdprod/control01.ctl
>> > > > > >> > > > ORA-15001: diskgroup "DATA" does not exist or is not
>> > > > > >> > > > mounted
>> > > > > >> > > > ORA-15064: communication failure with ASM instance
>> > > > > >> > > > ORA-00600: internal error code, arguments:
>> > > > > >> > > > [ORA_NPI_ERROR],
>> > > > [600],
>> > > > > >> > > > [ORA-00600: internal error code, arguments:
>> > [kfnsInstanceReg00],
>> > > > > >> > > > [bdprod:bdprod], [30000], [], [], [], [],
>> > > > > >> > > >
>> > > > > >> > > > --
>> > > > > >> > > > Wanderson Barrence
>> > > > > >> > > > DBA Oracle 10g/11g
>> > > > > >> > > > Analista de Testes - CBTS
>> > > > > >> > > > -------------------------------------------------------
>> > > > > >> > > > ---
>> > > > > >> > > > Skype: wbarrence
>> > > > > >> > > > Facebook:http://www.facebook.com/wbarrence
>> > > > > >> > > > Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > > >> > > >
>> > > > > >> > > > Em 18 de abril de 2013 12:31, Wanderson Barrence <
>> > > > > >> wbarrence@
>> > > >
>> > > > > >> > > > >escreveu:
>> > > > > >> > > >
>> > > > > >> > > > > Vitor,
>> > > > > >> > > > >
>> > > > > >> > > > > O negócio aqui está tão feio que o antigo DBA alterou
>> > todos os
>> > > > > >> nomes
>> > > > > >> > > > > dos controlfiles, e ainda por cima ele não seguiu os
>> > padrões
>> > > > da
>> > > > > >> OFA,
>> > > > > >> > > > > estou quebrando a cabeça aqui, nem sei como essa base
>> > estava
>> > > > > >> > > funcionando.
>> > > > > >> > > > >
>> > > > > >> > > > > Att,
>> > > > > >> > > > >
>> > > > > >> > > > > --
>> > > > > >> > > > > Wanderson Barrence
>> > > > > >> > > > > DBA Oracle 10g/11g
>> > > > > >> > > > > Analista de Testes - CBTS
>> > > > > >> > > > > -----------------------------------------------------
>> > > > > >> > > > > -----
>> > > > > >> > > > >
>> > > > > >> > > > > Skype: wbarrence
>> > > > > >> > > > > Facebook:http://www.facebook.com/wbarrence
>> > > > > >> > > > > Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > > >> > > > >
>> > > > > >> > > > >
>> > > > > >> > > > > Em 18 de abril de 2013 12:19, Vitor Jr. <vitorjr81@>
>> > > >
>> > > > > >> > > escreveu:
>> > > > > >> > > > >
>> > > > > >> > > > > **
>> > > > > >> > > >
>> > > > > >> > > > >>
>> > > > > >> > > > >>
>> > > > > >> > > > >> Se a área estava lotada porque baixou o banco? Era
>> > > > > >> > > > >> só
>> > limpar
>> > > > a
>> > > > > >> área
>> > > > > >> > > > >> de archives depois de ter certeza que foram
>> > > > > >> > > > >> backupeados,
>> > ou
>> > > > mover
>> > > > > >> > > > >> para outro local temporariamente.
>> > > > > >> > > > >>
>> > > > > >> > > > >> O erro diz claramente que não consegue identificar
>> > > > > >> > > > >> um dos controlfiles configurados no init/spfile.
>> > > > > >> > > > >> Verifique onde
>> > > > estão e
>> > > > > >> se
>> > > > > >> > > > estão lá no s.o.
>> > > > > >> > > > >>
>> > > > > >> > > > >>
>> > > > > >> > > > >>
>> > > > > >> > > > >> Att,/Regards,
>> > > > > >> > > > >>
>> > > > > >> > > > >> Vitor Jr.
>> > > > > >> > > > >> Infraestrutura / Infrastructure Team Oracle 11g DBA
>> > Certified
>> > > > > >> > > > >> Professional - OCP
>> > > > > >> > > > >>
>> > > > > >> > > > >> Oracle Certified Expert, Oracle Real Application
>> > > > > >> > > > >> Clusters
>> > > > 11g and
>> > > > > >> > > > >> Grid Infrastructure Administrator - OCE Oracle
>> > > > > >> > > > >> Database
>> > 11g
>> > > > > >> > > > >> Performance Tuning Certified Expert - OCE Oracle
>> > > > > >> > > > >> Exadata
>> > 11g
>> > > > > >> > > > >> Certified Implementation Specialist Oracle Certified
>> > > > Associate,
>> > > > > >> > > > >> MySQL
>> > > > > >> > > > >> 5 mail, gtalk e msn: <mailto:vitorjr81@> vitorjr81@
>> > > > > >> > > > >> <http://certificacaobd.com.br/>
>> >
>> > > >
>> > > > > >> > > > >> http://certificacaobd.com.br/
>> > > > > >> > > > >> skype: vjunior1981
>> > > > > >> > > > >>
>> > > > > >> > > > >> De: oracle_br@yahoogrupos.com.br
>> > > > > >> > > > >> [mailto:oracle_br@yahoogrupos.com.br]
>> > > > > >> > > > >> Em nome de Wanderson Barrence Enviada em:
>> > > > > >> > > > >> quinta-feira, 18 de abril de 2013 12:17
>> > > > > >> > > > >> Para: oracle_br@yahoogrupos.com.br
>> > > > > >> > > > >> Assunto: [oracle_br] ORA-00257: archiver error.
>> > > > > >> > > > >> Connect
>> > > > internal
>> > > > > >> > > > >> only, until freed.
>> > > > > >> > > > >>
>> > > > > >> > > > >>
>> > > > > >> > > > >> Olá Pessoal,
>> > > > > >> > > > >>
>> > > > > >> > > > >> Estava tentando resolver o erro ORA-00257: archiver
>> > error.
>> > > > > >> Connect
>> > > > > >> > > > >> internal only, until freed, busquei algumas
>> > > > > >> > > > >> informações
>> > > > sobre o
>> > > > > >> > > > >> erro e descobri que a area onde está armazenado os
>> > archives
>> > > > está
>> > > > > >> > > > >> lotada, então eu baixei o banco e tentei montar ele,
>> > > > > >> > > > >> e
>> > agora
>> > > > está
>> > > > > >> > > > >> ocorrendo outro erro: ORA-00205:
>> > > > > >> > > > >> error in identifying control file, check alert log
>> > > > > >> > > > >> for
>> > more
>> > > > info
>> > > > > >> > > > >>
>> > > > > >> > > > >> Alguém já passou por isso?
>> > > > > >> > > > >>
>> > > > > >> > > > >> At,
>> > > > > >> > > > >> --
>> > > > > >> > > > >> Wanderson Barrence
>> > > > > >> > > > >> DBA Oracle 10g/11g
>> > > > > >> > > > >> Analista de Testes - CBTS
>> > > > > >> > > > >>
>> > ----------------------------------------------------------
>> > > > > >> > > > >> Skype: wbarrence
>> > > > > >> > > > >> Facebook:http://www.facebook.com/wbarrence
>> > > > > >> > > > >> Linkedin: http://br.linkedin.com/in/wbarrence
>> > > > > >> > > > >>
>> > > > > >> > > > >> [As partes desta mensagem que não continham texto
>> > > > > >> > > > >> foram
>> > > > > >> removidas]
>> > > > > >> > > > >>
>> > > > > >> > > > >> [As partes desta mensagem que não continham texto
>> > > > > >> > > > >> foram
>> > > > > >> removidas]
>> > > > > >> > > > >>
>> > > > > >> > > > >>
>> > > > > >> > > > >>
>> > > > > >> > > > >
>> > > > > >> > > > >
>> > > > > >> > > >
>> > > > > >> > > > [As partes desta mensagem que não continham texto foram
>> > > > removidas]
>> > > > > >> > > >
>> > > > > >> > > > ------------------------------------
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > > -------------------------------------------------------
>> > > > > >> > > > ---
>> > > > > >> > > > >Atenção! As mensagens do grupo ORACLE_BR são de acesso
>> > público
>> > > > e de
>> > > > > >> > > > inteira responsabilidade de seus remetentes.
>> > > > > >> > > > Acesse:
>> > > > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
>> > > > > >> > > > -------------------------------------------------------
>> > > > > >> > > > ---
>> > > > > >> > > > >Apostilas » Dicas e Exemplos » Função » Mundo Oracle »
>> > Package
>> > > > »
>> > > > > >> > > > >Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR
>> > > > > >> > > > >TEM SEU
>> > > > PROPRIO
>> > > > > >> > > > >ESPAÇO! VISITE: http://www.oraclebr.com.br/
>> > > > > >> > > > -------------------------------------------------------
>> > > > > >> > > > ---
>> > > > Links do
>> > > > > >> > > Yahoo!
>> > > > > >> > > > Grupos
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > > >
>> > > > > >> > >
>> > > > > >> > > [As partes desta mensagem que não continham texto foram
>> > removidas]
>> > > > > >> > >
>> > > > > >> > > ------------------------------------
>> > > > > >> > >
>> > > > > >> > > ---------------------------------------------------------
>> > > > > >> > > -
>> > > > > >> > > >Atenção! As mensagens do grupo ORACLE_BR são de acesso
>> > público e
>> > > > de
>> > > > > >> > > inteira responsabilidade de seus remetentes.
>> > > > > >> > > Acesse:
>> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
>> > > > > >> > > ---------------------------------------------------------
>> > > > > >> > > -
>> > > > > >> > > >Apostilas » Dicas e Exemplos » Função » Mundo Oracle »
>> > Package »
>> > > > > >> > > >Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM
>> > > > > >> > > >SEU
>> > > > PROPRIO
>> > > > > >> > > >ESPAÇO! VISITE: http://www.oraclebr.com.br/
>> > > > > >> > > ---------------------------------------------------------
>> > > > > >> > > -
>> > Links
>> > > > do
>> > > > > >> > Yahoo!
>> > > > > >> > > Grupos
>> > > > > >> > >
>> > > > > >> > >
>> > > > > >> > >
>> > > > > >> >
>> > > > > >> >
>> > > > > >> > [As partes desta mensagem que não continham texto foram
>> > removidas]
>> > > > > >> >
>> > > > > >> >
>> > > > > >> >
>> > > > > >> > ------------------------------------
>> > > > > >> >
>> > > > > >> >
>> > > > > >> > ----------------------------------------------------------
>> > > > > >> > >Atenção! As mensagens do grupo ORACLE_BR são de acesso
>> > > > > >> > >público
>> > e de
>> > > > > >> > inteira responsabilidade de seus remetentes.
>> > > > > >> > Acesse:
>> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
>> > > > > >> >
>> > > > > >> > ----------------------------------------------------------
>> > > > > >> > >Apostilas » Dicas e Exemplos » Função » Mundo Oracle »
>> > > > > >> > >Package
>> > »
>> > > > > >> > Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU
>> > PROPRIO
>> > > > > >> ESPAÇO!
>> > > > > >> > VISITE: http://www.oraclebr.com.br/
>> > > > > >> > ----------------------------------------------------------
>> > > > > >> > Links do Yahoo! Grupos
>> > > > > >> >
>> > > > > >> >
>> > > > > >> >
>> > > > > >>
>> > > > > >> [As partes desta mensagem que não continham texto foram
>> > > > > >> removidas]
>> > > > > >>
>> > > > > >>
>> > > > > >>
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > > > [As partes desta mensagem que não continham texto foram
>> > > > > removidas]
>> > > > >
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> > > [As partes desta mensagem que não continham texto foram removidas]
>> > >
>> >
>> >
>> >
>>
>> [As partes desta mensagem que não continham texto foram removidas]
>>
>> ------------------------------------
>>
>> ----------------------------------------------------------
>> >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de
>> inteira responsabilidade de seus remetentes.
>> Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
>> ----------------------------------------------------------
>> >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package »
>> >Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO
>> >ESPAÇO! VISITE: http://www.oraclebr.com.br/
>> ---------------------------------------------------------- Links do
>> Yahoo! Grupos
>>
>>
>>
>
>
[As partes desta mensagem que não continham texto foram removidas]
------------------------------------
--------------------------------------------------------------------------------------------------------------------------
>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira
>responsabilidade de seus remetentes.
Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
--------------------------------------------------------------------------------------------------------------------------
>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure »
>Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE:
>http://www.oraclebr.com.br/
------------------------------------------------------------------------------------------------------------------------
Links do Yahoo! Grupos
<*> Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
<*> Para sair deste grupo, envie um e-mail para:
oracle_br-unsubscr...@yahoogrupos.com.br
<*> O uso que você faz do Yahoo! Grupos está sujeito aos:
http://br.yahoo.com/info/utos.html
