ORA-01114
729201Dec 29 2009 — edited Dec 29 2009Hi,
I have this error many times on file 202 and file 3.
File 3 is the datafile for SYSAUX and 202 the tempfile
I have check my backup rman and i have not corrupted blocs.
I have dropped my tempfile and recreate but the problem is not solved.
My database is on AIX 5L in oracle version 10.2.0.4
Alert.log
Mon Dec 28 21:30:43 2009
Thread 2 advanced to log sequence 27429 (LGWR switch)
Current log# 3 seq# 27429 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27429 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Mon Dec 28 21:31:22 2009
Thread 2 cannot allocate new log, sequence 27430
Checkpoint not complete
Current log# 3 seq# 27429 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27429 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Mon Dec 28 21:31:25 2009
Thread 2 advanced to log sequence 27430 (LGWR switch)
Current log# 4 seq# 27430 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_4.266.667479421
Current log# 4 seq# 27430 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_4.260.667479421
Mon Dec 28 22:01:30 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:30 2009
GATHER_STATS_JOB encountered errors. Check the trace file.
Mon Dec 28 22:01:30 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:43 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:46 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:53 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:54 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:55 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:02:16 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112032)
ORA-29701: unable to connect to Cluster Manager
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:02:19 2009
Trace dumping is performing id=cdmp_20091228220219
Mon Dec 28 22:11:35 2009
Thread 2 advanced to log sequence 27431 (LGWR switch)
Current log# 3 seq# 27431 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27431 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Mon Dec 28 22:26:10 2009
Thread 2 advanced to log sequence 27432 (LGWR switch)
Current log# 4 seq# 27432 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_4.266.667479421
Current log# 4 seq# 27432 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_4.260.667479421
Mon Dec 28 22:26:49 2009
Thread 2 cannot allocate new log, sequence 27433
Checkpoint not complete
Current log# 4 seq# 27432 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_4.266.667479421
Current log# 4 seq# 27432 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_4.260.667479421
Mon Dec 28 22:26:52 2009
Thread 2 advanced to log sequence 27433 (LGWR switch)
Current log# 3 seq# 27433 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27433 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Trc
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
*** 2009-12-28 22:01:30.575
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SIEBEL"','"EIM_PROD_INT"','""', ...)
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
clsc_connect: (113390e30) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_saxfrndc01sipr2_crsSIEBELPR))
2009-12-28 22:01:33.816: CSSCLNTclsssInitNative: connect failed, rc 9
kgxgncin: CLSS init failed with status 3
kjfmsgr: unable to connect to NM for reg in shared group
*** 2009-12-28 22:01:43.854
clsc_connect: (113390e30) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_saxfrndc01sipr2_crsSIEBELPR))
2009-12-28 22:01:43.854: CSSCLNTclsssInitNative: connect failed, rc 9
kgxgncin: CLSS init failed with status 3
kjfmsgr: unable to connect to NM for reg in shared group
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
I don't know where is the problem.
Thanks for your help