Tenta um recover datafile 9;
e depois disso o alter database open resetlogs; ________________________________ De: Tânia <tanias...@yahoo.com.br> Para: oracle_br@yahoogrupos.com.br Enviadas: Quinta-feira, 17 de Dezembro de 2009 9:10:01 Assunto: Res: [oracle_br] Re: Erro ao conectar ao oracle Eu fiz o backup do controlfile, executei shutdown immediate, um startup nomount, um restore controlfile from 'C:\ORACLEXE\ backup', um alter database mount a´te até aí tudo ok, mas quando fui executar alter database open resetlogs, emitiu o erro: ORA-01194: o arquivo 9 necessita de mais recuperaþÒo para ser consistente ORA-01110: 9 do arquivo de dados: 'C:\ORACLEXE\ ORADATA\XE\ TBSGENERICA_ DATA' Será que ainda tem como recuperar este banco? Agradeço desde já Tânia --- Em oracle...@yahoogrup os.com.br, Caio Spadafora <caiospadafora@ ...> escreveu > > Tânia, > > Gere o backup do controlfile após deixar sua instância montada: > > STARTUP MOUNT; > > Pelo trecho do alert.log que você enviou a instância monta corretamente o > problema é durante a abertura do banco. > > Atenciosamente, > > Caio Spadafora, > Database Administrator, > http://0011brothers .blogspot. com/ > > > > > ____________ _________ _________ __ > De: Tânia Salgado <tanias...@. ..> > Para: oracle...@yahoogrup os.com.br > Enviadas: Quarta-feira, 16 de Dezembro de 2009 15:31:24 > Assunto: Re: [oracle_br] Re: Erro ao conectar ao oracle > > > Tentei executar o comando e me emitiu a mensagem ORA-01034 - Oracle not > available > > Vc havia me pedido pra enviar o arquivo.. xe_lgwr_2212. trc > > Agradeço desde já... > > --- Em qua, 16/12/09, Erick Guimaraes <guimaraes.erick@ gmail.com> escreveu: > > De: Erick Guimaraes <guimaraes.erick@ gmail.com> > Assunto: Re: [oracle_br] Re: Erro ao conectar ao oracle > Para: oracle...@yahoogrup os.com.br > Data: Quarta-feira, 16 de Dezembro de 2009, 15:24 > > Problem Description > ============ ======== > You are trying to startup the database. It mounts but will not open. > When it opens the following errors are reported: > > ORA 00449 > 00449, 00000, "background process '%s' unexpectedly terminated with error > %s" > // *Cause: A foreground process needing service from a background > // process has discovered the process died. > // *Action: Consult the error code, and the trace file for the process. > > ORA 00470 > 00470, 00000, "LGWR process terminated with error" > // *Cause: The log writer process died > // *Action: Warm start instance > > ORA 01092 > 01092, 00000, "ORACLE instance terminated. Disconnection forced" > // *Cause: The instance this process was connected to was terminated > // abnormally, probably via a shutdown abort. This process > // was forced to disconnect from the instance. > // *Action: When instance has been restarted, retry action. > > The Alert log shows ORA-600[3705] > > Solution Description > ============ ======== > 1. Issue the command 'Alter Database Backup Controlfile to Trace;' > > 2. Edit the subsequent trace file. > > a. Remove everything above the 'STARTUP NOMOUNT' line. > b. Change 'STARTUP NOMOUNT' to > 'STARTUP NOMOUNT PFILE=<path to initSID.ora> '. > > 3. Run the create controlfile script. > > Solution Explanation: > ============ ========= > Normally if a database will successfully mount we do not suspect problems > with > the controlfile. However, in this case, the corruption is not found until we > > open the database. > > When we open the database we check a flag in the current online redo log and > if > that flag does not match the flag for that thread in the controlfile then we > signal the ora-600 [3705].. > > In this particular situation an import was causing excessive redo log > switches > because the Redo Logs were only 200k. This caused corruption in the > controlfile. Rebuilding the controlfile alleviated part of the problem. > However, it took several minutes for the database to open because we were > waiting for SMON to complete cache recovery. Once the database opened and > the checkpoint was completed, a subsequent shutdown and restart was > completed > within seconds. > > 2009/12/16 Tânia <tanias...@yahoo. com.br> > > > > > > > Pessoal este é parte do alert log.... > > > > > > > > Instance terminated by LGWR, pid = 1936 > > Wed Dec 16 14:02:12 2009 > > Starting ORACLE instance (normal) > > LICENSE_MAX_ SESSION = 0 > > LICENSE_SESSIONS_ WARNING = 0 > > Picked latch-free SCN scheme 2 > > Using LOG_ARCHIVE_ DEST_10 parameter default value as > > USE_DB_RECOVERY_ FILE_DEST > > Autotune of undo retention is turned on. > > IMODE=BR > > ILAT =10 > > LICENSE_MAX_ USERS = 0 > > SYS auditing is disabled > > ksdpec: called for event 13740 prior to event group initialization > > Starting up ORACLE RDBMS Version: 10.2.0.1.0. > > System parameters with non-default values: > > sessions = 49 > > __shared_pool_ size = 71303168 > > __large_pool_ size = 4194304 > > __java_pool_ size = 4194304 > > __streams_pool_ size = 0 > > spfile = C:\ORACLEXE\ APP\ORACLE\ PRODUCT\10. 2.0\SERVER\ DBS\SPFILEXE. ORA > > sga_target = 146800640 > > control_files = C:\ORACLEXE\ ORADATA\XE\ CONTROL.DBF > > __db_cache_size = 62914560 > > compatible = 10.2.0.1.0 > > db_recovery_ file_dest = C:\oraclexe\ app\oracle\ flash_recovery_ area > > db_recovery_ file_dest_ size= 10737418240 > > undo_management = AUTO > > undo_tablespace = UNDO > > remote_login_ passwordfile= EXCLUSIVE > > dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB) > > shared_servers = 4 > > job_queue_processes = 4 > > audit_file_dest = C:\ORACLEXE\ APP\ORACLE\ ADMIN\XE\ ADUMP > > background_dump_ dest = C:\ORACLEXE\ APP\ORACLE\ ADMIN\XE\ BDUMP > > user_dump_dest = C:\ORACLEXE\ APP\ORACLE\ ADMIN\XE\ UDUMP > > core_dump_dest = C:\ORACLEXE\ APP\ORACLE\ ADMIN\XE\ CDUMP > > db_name = XE > > open_cursors = 300 > > os_authent_prefix = > > pga_aggregate_ target = 20971520 > > PMON started with pid=2, OS id=1740 > > PSP0 started with pid=3, OS id=3876 > > MMAN started with pid=4, OS id=208 > > DBW0 started with pid=5, OS id=3356 > > LGWR started with pid=6, OS id=2212 > > CKPT started with pid=7, OS id=2724 > > SMON started with pid=8, OS id=3972 > > RECO started with pid=9, OS id=4032 > > CJQ0 started with pid=10, OS id=3492 > > MMON started with pid=11, OS id=2604 > > Wed Dec 16 14:02:14 2009 > > starting up 1 dispatcher(s) for network address > > '(ADDRESS=(PARTIAL= YES)(PROTOCOL= TCP))'... > > MMNL started with pid=12, OS id=3604 > > Wed Dec 16 14:02:14 2009 > > starting up 4 shared server(s) ... > > Oracle Data Guard is not available in this edition of Oracle. > > Wed Dec 16 14:02:15 2009 > > alter database mount exclusive > > Wed Dec 16 14:02:19 2009 > > Setting recovery target incarnation to 2 > > Wed Dec 16 14:02:20 2009 > > Successful mount of redo thread 1, with mount id 2586930215 > > Wed Dec 16 14:02:20 2009 > > Database mounted in Exclusive Mode > > Completed: alter database mount exclusive > > Wed Dec 16 14:02:20 2009 > > alter database open > > Wed Dec 16 14:02:21 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ lgwr_2212. trc: > > ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [0], [], > > [], [] > > Wed Dec 16 14:02:26 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ lgwr_2212. trc: > > ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [0], [], > > [], [] > > Wed Dec 16 14:02:26 2009 > > LGWR: terminating instance due to error 470 > > Wed Dec 16 14:02:26 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ dbw0_3356. trc: > > ORA-00470: LGWR process terminated with error > > Wed Dec 16 14:02:27 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ pmon_1740. trc: > > ORA-00470: LGWR process terminated with error > > Wed Dec 16 14:02:28 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ reco_4032. trc: > > ORA-00470: LGWR process terminated with error > > Wed Dec 16 14:02:28 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ smon_3972. trc: > > ORA-00470: LGWR process terminated with error > > Wed Dec 16 14:02:28 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ ckpt_2724. trc: > > ORA-00470: LGWR process terminated with error > > Wed Dec 16 14:02:29 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ mman_208. trc: > > ORA-00470: LGWR process terminated with error > > Wed Dec 16 14:02:29 2009 > > Errors in file c:\oraclexe\ app\oracle\ admin\xe\ bdump\xe_ psp0_3876. trc: > > ORA-00470: LGWR process terminated with error > > Instance terminated by LGWR, pid = 2212 > > > > --- Em oracle...@yahoogrup os.com.br <oracle_br%40yahoog rupos.com. br>, > > "thiago986" <thiago986@ ..> escreveu > > > > > > Tania, > > > > > > O que está retornando no alert log? > > > > > > Att, > > > > > > Thiago Hyppolito > > > > > > > > > > > [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 > > ____________ _________ _________ _________ _________ _________ _ > Veja quais são os assuntos do momento no Yahoo! +Buscados > http://br.maisbusca dos.yahoo. com > > [As partes desta mensagem que não continham texto foram removidas] > > > > > > ____________ _________ _________ _________ _________ _________ _ > Veja quais são os assuntos do momento no Yahoo! +Buscados > http://br.maisbusca dos.yahoo. com > > [As partes desta mensagem que não continham texto foram removidas] > ____________________________________________________________________________________ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com [As partes desta mensagem que não continham texto foram removidas]