Você pode adicionar mais log members ao grupo de logs e excluir definitivamente o log member que está dando erro. Em relação ao erro ora-0600, sugiro chamar o suporte oracle.
Reginaldo Ribeiro Administrador de Bancos de Dados Oracle Certified Associate 10g _________________________________ DBcom IT Experts skype: rflribeiro msn: [EMAIL PROTECTED] mobile: 551192344290 fone: 551162165375 e-mail: [EMAIL PROTECTED] site: www.dbcom.com.br Elaine wrote: > > Apos tentar consultar um registro em uma determinada tabela, verifiquei > o alert log e estas sao as ultimas mensagens, > o que preciso fazer para recuperar o redo log block que diz está > corrompido? > > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21089.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 09:50:17 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21199.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 09:54:46 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21311.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:03:02 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21431.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:11:52 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21761.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:13:04 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21885.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:13:22 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21885.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:13:42 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_21885.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:21:32 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:21:51 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:23:29 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:24:24 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:26:48 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22303.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:27:02 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:27:55 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:28:01 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:28:06 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:28:11 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22181.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:28:26 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22331.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:28:28 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22303.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:35:19 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22331.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:37:05 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22303.trc: > ORA-00368: checksum error in redo log block > ORA-00353: log corruption near block 7027 change 78626840 time > 10/29/2007 22:13:04 > ORA-00334: archived log: > '/u01/app/oracle/product/10.2.0/oradata/ficha/redo03.log' > Tue Oct 30 10:37:05 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22303.trc: > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > Tue Oct 30 10:37:06 2007 > Errors in file > /u01/app/oracle/product/10.2.0/db_1/admin/ficha/udump/ficha_ora_22303.trc: > ORA-00368: checksum error in redo log block > ORA-00353: log corruption near block 7027 change 78626840 time > 10/29/2007 22:13:04 > ORA-00334: archived log: > '/u01/app/oracle/product/10.2.0/oradata/ficha/redo03.log' > ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], > [0], [1], [], [], [], [] > > Att, > > -- > Elaine C Bastos Silva > [EMAIL PROTECTED] <mailto:elaine%40cinbesa.com.br> > Equipe de Suporte - DBA > CINBESA > Tel: 3084 0704 > > "O pessimista se queixa do vento. > O otimista espera que ele mude. > O realista ajusta as velas " > > William George Ward > >
