Oracle Database Discussions

Oracle 10g 10.2.0.1.0 on win 2003 server both(32 bit)



Problem:
=======
1. select*from v$log;


GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
--------- --------- --------- --------- --------- --- ---------------- ------------- ---------
1 1 1892 52428800 1 NO INACTIVE 62251690 23-JAN-12
2 1 1893 52428800 1 NO CURRENT 62260537 23-JAN-12
3 1 1891 52428800 1 NO INACTIVE 62231557 23-JAN-12


2.
select*from v$logfile;


GROUP# STATUS TYPE MEMBER
--------- ------- ------- -----------------------------------------------
3 STALE ONLINE D:\ORACLE\ORADATA\OLRLFG3\REDO03.LOG
2 ONLINE D:\ORACLE\ORADATA\OLRLFG2\REDO02.LOG
1 ONLINE D:\ORACLE\ORADATA\OLRLFG1\REDO01.LOG
4 STANDBY D:\ORACLE\ORADATA\STANDBY_OLRLFG1\SB_REDO01.LOG

3.
Mon Jan 23 10:53:55 2012
Beginning log switch checkpoint up to RBA [0x765.2.10], SCN: 62260537
Thread 1 advanced to log sequence 1893
Current log# 2 seq# 1893 mem# 0: D:\ORACLE\ORADATA\OLRLFG2\REDO02.LOG
Mon Jan 23 10:59:16 2012
Completed checkpoint up to RBA [0x765.2.10], SCN: 62260537
Mon Jan 23 11:01:00 2012
Hex dump of (file 3, block 29417) in trace file d:\oracle\product\10.2.0\admin\cwo\bdump\cwo_j000_6084.trc
Corrupt block relative dba: 0x00c072e9 (file 3, block 29417)
Fractured block found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x00c072e9
last change scn: 0x0000.03b33d6b seq: 0x2 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x6b390603
check value in block header: 0x6188
computed block checksum: 0xb0c5
Reread of rdba: 0x00c072e9 (file 3, block 29417) found same corrupted data
Mon Jan 23 11:01:16 2012
Errors in file d:\oracle\product\10.2.0\admin\cwo\bdump\cwo_m000_5884.trc:
ORA-00600: internal error code, arguments: [6002], [6], [6], [5], [0], [], [], []

Mon Jan 23 11:01:20 2012
Hex dump of (file 3, block 37080) in trace file d:\oracle\product\10.2.0\admin\cwo\bdump\cwo_j000_6084.trc
Corrupt block relative dba: 0x00c090d8 (file 3, block 37080)
Fractured block found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x00c090d8
last change scn: 0x0000.037f9b2e seq: 0x2 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xacb70602
check value in block header: 0xe1cb
computed block checksum: 0x9d1
Reread of rdba: 0x00c090d8 (file 3, block 37080) found same corrupted data
Mon Jan 23 11:01:39 2012
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 29417, RDBA = 12612329
OBJN = 49890, OBJD = 49890, OBJECT = MGMT_METRICS_1HOUR_PK, SUBOBJECT =
SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment
Mon Jan 23 11:02:59 2012
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 37080, RDBA = 12619992
OBJN = 49890, OBJD = 49890, OBJECT = MGMT_METRICS_1HOUR_PK, SUBOBJECT =
SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment
Mon Jan 23 11:12:58 2012
Incremental checkpoint up to RBA [0x765.aba9.0], current log tail at RBA [0x765.ad03.0]
=======================================

This frectured block is causing problem in RMAN backup.

Please help.