Maravilha Shariff, que bom. Abraço. Sucesso sempre!!!
Em 6 de julho de 2010 17:37, Sharif - Yahoo <sharif_rad...@yahoo.com.br>escreveu: > > > Oi David... > > Não é utilizado o RMAN nessa máquina, porem o pessoal encontrou um backup > de alguns dias e como esse banco é de homologação foi reinstalado e voltou o > backup. > > Valeu pela atenção... > > Abraços, > > Sharif > > De: oracle_br@yahoogrupos.com.br <oracle_br%40yahoogrupos.com.br> [mailto: > oracle_br@yahoogrupos.com.br <oracle_br%40yahoogrupos.com.br>] Em nome de > David Ricardo > Enviada em: terça-feira, 6 de julho de 2010 17:05 > Para: oracle_br@yahoogrupos.com.br <oracle_br%40yahoogrupos.com.br> > Assunto: Re: [oracle_br] Re: Corrupt block - Oracle 10.2.0.2 e Windows > > > Vc usa RMAN? > Se usar faça via BMR ( Block Media Recover), já fiz e é 100%. > > veja abaixo : > http://databaseguard.blogspot.com/2009/08/rman-bmr-block-media-recover.html > > Abraço e boa sorte!!! > > 2010/7/6 thiago986 <thiago...@yahoo.com.br <thiago986%40yahoo.com.br><mailto: > thiago986%40yahoo.com.br <thiago986%2540yahoo.com.br>> > > > > > > > > > De uma olhada sobre blockrecover no utilitário do RMAN. Pode ser útil. > > > > att, > > --- Em oracle_br@yahoogrupos.com.br <oracle_br%40yahoogrupos.com.br><mailto: > oracle_br%40yahoogrupos.com.br <oracle_br%2540yahoogrupos.com.br>> > <oracle_br%40yahoogrupos.com.br>, > > > "Sharif - Yahoo" <sharif_rad...@...> escreveu > > > > > > > > Pessoal, > > > > > > > > > > > > Não consigo subir essa base... alguem sabe de alguma saída para > conseguir > > > subir e descobrir onde está o problema ? > > > > > > > > > > > > Pelo que andei pesquisando para rodar o DBMS_REPAIR a base precisaria > > estar > > > aberta, certo ? > > > > > > > > > > > > Mon Jul 05 17:41:26 2010 > > > > > > Starting ORACLE instance (normal) > > > > > > LICENSE_MAX_SESSION = 0 > > > > > > LICENSE_SESSIONS_WARNING = 0 > > > > > > Picked latch-free SCN scheme 2 > > > > > > Using LOG_ARCHIVE_DEST_1 parameter default value as > > > E:\oracle\product\10.2.0\db_1\RDBMS > > > > > > Autotune of undo retention is turned on. > > > > > > IMODE=BR > > > > > > ILAT =18 > > > > > > 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.2.0. > > > > > > System parameters with non-default values: > > > > > > processes = 150 > > > > > > __shared_pool_size = 197132288 > > > > > > __large_pool_size = 4194304 > > > > > > __java_pool_size = 4194304 > > > > > > __streams_pool_size = 0 > > > > > > spfile = > > > E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEDB10G.ORA > > > > > > sga_target = 612368384 > > > > > > control_files = > > > E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB10G\CONTROL01.CTL, > > > E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB10G\CONTROL02.CTL, > > > E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB10G\CONTROL03.CTL > > > > > > db_block_size = 8192 > > > > > > __db_cache_size = 398458880 > > > > > > compatible = 10.2.0.2.0 > > > > > > db_file_multiblock_read_count= 16 > > > > > > undo_management = AUTO > > > > > > undo_tablespace = UNDOTBS1 > > > > > > remote_login_passwordfile= EXCLUSIVE > > > > > > db_domain = > > > > > > dispatchers = (PROTOCOL=TCP) (SERVICE=DB10GXDB) > > > > > > job_queue_processes = 10 > > > > > > audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\DB10G\ADUMP > > > > > > background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\DB10G\BDUMP > > > > > > user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\DB10G\UDUMP > > > > > > core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\DB10G\CDUMP > > > > > > db_name = DB10G > > > > > > open_cursors = 300 > > > > > > pga_aggregate_target = 203423744 > > > > > > PMON started with pid=2, OS id=2560 > > > > > > PSP0 started with pid=3, OS id=2940 > > > > > > MMAN started with pid=4, OS id=2688 > > > > > > DBW0 started with pid=5, OS id=1832 > > > > > > LGWR started with pid=6, OS id=2624 > > > > > > CKPT started with pid=7, OS id=2060 > > > > > > SMON started with pid=8, OS id=768 > > > > > > RECO started with pid=9, OS id=576 > > > > > > CJQ0 started with pid=10, OS id=2584 > > > > > > MMON started with pid=11, OS id=452 > > > > > > MMNL started with pid=12, OS id=2440 > > > > > > Mon Jul 05 17:41:27 2010 > > > > > > starting up 1 dispatcher(s) for network address > > > '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... > > > > > > starting up 1 shared server(s) ... > > > > > > Mon Jul 05 17:41:27 2010 > > > > > > ALTER DATABASE MOUNT > > > > > > Mon Jul 05 17:41:31 2010 > > > > > > Setting recovery target incarnation to 2 > > > > > > Mon Jul 05 17:41:31 2010 > > > > > > Successful mount of redo thread 1, with mount id 115884039 > > > > > > Mon Jul 05 17:41:31 2010 > > > > > > Database mounted in Exclusive Mode > > > > > > Completed: ALTER DATABASE MOUNT > > > > > > Mon Jul 05 17:41:31 2010 > > > > > > ALTER DATABASE OPEN > > > > > > Mon Jul 05 17:41:32 2010 > > > > > > Beginning crash recovery of 1 threads > > > > > > parallel recovery started with 2 processes > > > > > > Mon Jul 05 17:41:33 2010 > > > > > > Started redo scan > > > > > > Mon Jul 05 17:41:33 2010 > > > > > > Completed redo scan > > > > > > 1 redo blocks read, 0 data blocks need recovery > > > > > > Mon Jul 05 17:41:33 2010 > > > > > > Started redo application at > > > > > > Thread 1: logseq 277, block 2, scn 9571201 > > > > > > Mon Jul 05 17:41:34 2010 > > > > > > Recovery of Online Redo Log: Thread 1 Group 3 Seq 277 Reading mem 0 > > > > > > Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB10G\REDO03.LOG > > > > > > Mon Jul 05 17:41:34 2010 > > > > > > Completed redo application > > > > > > Mon Jul 05 17:41:34 2010 > > > > > > Completed crash recovery at > > > > > > Thread 1: logseq 277, block 3, scn 9591203 > > > > > > 0 data blocks read, 0 data blocks written, 1 redo blocks read > > > > > > Mon Jul 05 17:41:34 2010 > > > > > > Thread 1 advanced to log sequence 278 > > > > > > Thread 1 opened at log sequence 278 > > > > > > Current log# 1 seq# 278 mem# 0: > > > E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB10G\REDO01.LOG > > > > > > Successful open of redo thread 1 > > > > > > Mon Jul 05 17:41:34 2010 > > > > > > MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set > > > > > > Mon Jul 05 17:41:34 2010 > > > > > > SMON: enabling cache recovery > > > > > > Mon Jul 05 17:41:35 2010 > > > > > > Hex dump of (file 2, block 57) in trace file > > > e:\oracle\product\10.2.0\admin\db10g\udump\db10g_ora_660.trc > > > > > > Corrupt block relative dba: 0x00800039 (file 2, block 57) > > > > > > Fractured block found during buffer read > > > > > > Data in bad block: > > > > > > type: 38 format: 2 rdba: 0x00800039 > > > > > > last change scn: 0x0000.008eaf7a seq: 0x2 flg: 0x04 > > > > > > spare1: 0x0 spare2: 0x0 spare3: 0x0 > > > > > > consistency value in tail: 0xae542601 > > > > > > check value in block header: 0x3ba5 > > > > > > computed block checksum: 0x8b42 > > > > > > Reread of rdba: 0x00800039 (file 2, block 57) found same corrupted data > > > > > > Mon Jul 05 17:41:35 2010 > > > > > > Errors in file > > e:\oracle\product\10.2.0\admin\db10g\udump\db10g_ora_660.trc: > > > > > > ORA-01578: bloco de dados ORACLE danificado (arquivo núm. 2, bloco núm. > > 57) > > > > > > ORA-01110: 2 do arquivo de dados: > > > 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB10G\UNDOTBS01.DBF' > > > > > > > > > > > > Error 1578 happened during db open, shutting down database > > > > > > USER: terminating instance due to error 1578 > > > > > > Mon Jul 05 17:41:35 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_psp0_2940.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:35 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_mman_2688.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:35 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_lgwr_2624.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:35 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_pmon_2560.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:36 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_reco_576.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:36 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_ckpt_2060.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:36 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_smon_768.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Mon Jul 05 17:41:36 2010 > > > > > > Errors in file > > > e:\oracle\product\10.2.0\admin\db10g\bdump\db10g_dbw0_1832.trc: > > > > > > ORA-01578: ORACLE data block corrupted (file # , block # ) > > > > > > > > > > > > Instance terminated by USER, pid = 660 > > > > > > ORA-1092 signalled during: ALTER DATABASE OPEN... > > > > > > > > > > > > > > > > > > > > > > > > [As partes desta mensagem que não continham texto foram removidas] > > > > > > > > > > > -- > ---------------------------------------------------------- > David Ricardo B. de Siqueira > IT Brazil - Database Administrator > Discover Technology > BLOG .: http://databaseguard.blogspot.com > > "O mistério da vida me causa a mais forte emoção. É o sentimento que > suscita > a beleza e a verdade, cria a arte e a ciência. Se alguém não conhece essa > sensação ou não pode mais exprimir espanto ou surpresa, já é um morto-vivo > e > seus olhos se cegaram.".(Albert Einstein - 1879 - 1955)" > > [As partes desta mensagem que não continham texto foram removidas] > > [As partes desta mensagem que não continham texto foram removidas] > > > -- ------------------------------------------------------------ David Ricardo B. de Siqueira IT Brazil - Database Administrator Discover Technology BLOG .: http://databaseguard.blogspot.com "O mistério da vida me causa a mais forte emoção. É o sentimento que suscita a beleza e a verdade, cria a arte e a ciência. Se alguém não conhece essa sensação ou não pode mais exprimir espanto ou surpresa, já é um morto-vivo e seus olhos se cegaram.".(Albert Einstein - 1879 - 1955)" [As partes desta mensagem que não continham texto foram removidas]