Printable View
Hi,
When I look at my ARC1.trc file it tell me
Instance name: SID
Redo thread mounted by this instance: 1
Oracle process number: 76
What do u mean by
Redo thread mounted by this instance: 1
AND
also on chekcing this file i noticed an error
***
Corrupt block relative dba: 0x00000262 file=0. blocknum=610.
Completely zero block found during controlfile block read
***
this error came long back in july (i m new guy here).
now no error is coming.
what should i need to look into...
Could you please check your alert_SID.log file for this instance normally located under $ORACLE_BASE/admin/SID/bdump and post the exact error from the log. This is due to some block corruption on the control file
Could you also post the oracle and os versions too.
Sam
Oracle 816, Windows NT 4.0 SP6
I am new person over here. I was just going thru the alert logs etc.
I found this error in my ARCH.LOG file. This came long back in July.
The whole details from ARCH.LOG is as below :
Dump file L:\oracle\P62\saptrace\background\p62ARC1.TRC
Thu Jul 19 10:42:04 2001
ORACLE V8.1.6.1.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 6, CPU type 586
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Windows NT Version 4.0 Service Pack 6, CPU type 586
Instance name: p62
Redo thread mounted by this instance: 1
Oracle process number: 42
Windows thread id: 426, image: ORACLE.EXE
*** SESSION ID:(41.2735) 2001-07-19 10:42:04.887
***
Corrupt block relative dba: 0x00000262 file=0. blocknum=610.
Completely zero block found during controlfile block read
*** 2001-07-19 10:42:04.918
WHEN I LOOK AT THE SIDALRT.LOG I C Following :
Thu Jul 19 11:51:43 2001
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 12 Seq 2202 Reading mem 0
Mem# 0 errs 0: K:\ORACLE\P62\ORIGLOGB\LOG_G12M1.DBF
Mem# 1 errs 0: J:\ORACLE\P62\MIRRLOGB\LOG_G12M2.DBF
Thu Jul 19 11:51:43 2001
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
ARCH: Beginning to archive log# 13 seq# 2199
***
Corrupt block relative dba: 0x00000262 file=0. blocknum=610.
Completely zero block found during controlfile block read
ORA-227 signalled during: alter database open...
Thu Jul 19 11:51:45 2001
alter database open
ARCH: Beginning to archive log# 13 seq# 2199
***
Corrupt block relative dba: 0x00000262 file=0. blocknum=610.
Completely zero block found during controlfile block read
ORA-227 signalled during: alter database open...
Thu Jul 19 11:51:48 2001
alter database open
ARCH: Beginning to archive log# 13 seq# 2199
***
Corrupt block relative dba: 0x00000262 file=0. blocknum=610.
Completely zero block found during controlfile block read
ORA-227 signalled during: alter database open...
Thu Jul 19 11:51:52 2001
Please advise.