| Oracle Internal Error [message #57538] |
Fri, 20 June 2003 23:31  |
vasanth
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
Hello
Im vasanth, studying oracle dba , I have some problems , It would really be pleasure if u can help me
My mail id kmgvasanth@yahoo.com
thanking u in advance.
When I connected as scott/tiger it gives error
oracle not available,
I have checked the alert logfile
the following is the alert log file content
And i have no datafile backup. im in need to use the existing datafile for recovery. THe recovery also gives error
such as ,
recovery successfully completed,but OPEN RESETLOGS give erorr,
what would be the solution,
Mon May 05 20:32:07 2003
PMON started with pid=2
Mon May 05 20:32:07 2003
DBW0 started with pid=3
Mon May 05 20:32:07 2003
LGWR started with pid=4
Mon May 05 20:32:07 2003
CKPT started with pid=5
Mon May 05 20:32:07 2003
SMON started with pid=6
Mon May 05 20:32:07 2003
RECO started with pid=7
Mon May 05 20:32:07 2003
SNP0 started with pid=8
Mon May 05 20:32:07 2003
SNP1 started with pid=9
Mon May 05 20:32:08 2003
alter database "orcl" mount exclusive
Mon May 05 20:32:08 2003
Successful mount of redo thread 1.
Mon May 05 20:32:08 2003
Completed: alter database "orcl" mount exclusive
Mon May 05 20:32:08 2003
alter database "orcl" open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 1 Seq 417 Reading mem 0
Mem# 0 errs 0: D:ORANTDATABASELOG4ORCL.ORA
Crash recovery completed successfully
Mon May 05 20:32:10 2003
Thread 1 advanced to log sequence 418
Thread 1 opened at log sequence 418
Current log# 2 seq# 418 mem# 0: D:ORANTDATABASELOG3ORCL.ORA
Successful open of redo thread 1.
Mon May 05 20:32:10 2003
SMON: enabling cache recovery
SMON: enabling tx recovery
ORACLE Instance orcl (pid = 6) - Error 1578 encountered while recovering transaction (6, 1).
Mon May 05 20:32:11 2003
Errors in file D:orantRDBMS80traceorclSMON.TRC:
ORA-01578: ORACLE data block corrupted (file # 3, block # 296)
ORA-01110: data file 3: 'D:ORANTDATABASERBS1ORCL.ORA'
Mon May 05 20:32:11 2003
Completed: alter database "orcl" open
Mon May 05 20:32:11 2003
Errors in file D:orantRDBMS80traceorclSMON.TRC:
ORA-00600: internal error code, arguments: [[ktsxfinsert1]], [[5]], [[4002]], [[]], [[]], [[]], [[]], [[]]
Mon May 05 20:32:11 2003
Instance terminating due to error 600
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
