Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 8.1.5 and ORA-00600 with [4193], [1544], [1778], [], []
Hello World,
I cannot restart my database after a crash occured....
Config is : Windows 2000 server, Oracle 8.1.5 server running on an old Pentium 500 MHz / 400 Mb RAM computer. This database is a little big (around 40 Gb) and this computer and DB instance is used only for development and testing. Archive log is not enabled.
I can rebuild all this from a previous dump + some additional changes, but whish to get the reason why this happened and how to rebuild it, unless it takes days...
Thanks in advance for your help,
Charly
____________ Description of problem below __________________
My database crashed yesterday while running some PL/SQL proc. I don't feel the proc. is the origin bacause it run before without problem. Of course I cannot prove it so far since my DB is stoped.
I cannot re-open the database now without getting the following behavior :
SVRMGR> startup pfile='C:\Oracle\ADMIN\MyDB\pfile\init.ora' ORACLE instance started.
Total System Global Area 23158732 bytes Fixed Size 65484 bytes Variable Size 6242304 bytes Database Buffers 16777216 bytes Redo Buffers 73728 bytesDatabase mounted.
[[[ Note : at this point, the CPU usage of the server reaches 100%, [[[ all used by Oracle service. [[[ Every action I try to do in the database get stucked...
SVRMGR> alter database recover;
alter database recover
*
ORA-00283: recovery session canceled due to errors ORA-01124: cannot recover data file 1 - file is in use or recovery ORA-01110: data file 1: 'D:\ORACLE\ORADATA\MyDB\SYSTEM_01.DBF'SVRMGR> Here is the ALERT file of the server :
________ Beginninig of ALRT.LOG ___________
Dump file D:\Oracle\admin\MyDB\bdump\MyDBALRT.LOG
Fri Mar 21 10:34:50 2003
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
System parameters with non-default values:
processes = 50 shared_pool_size = 4194304 control_files = D:\Oracle\oradata\MyDB\control01.ctl, D:\Oracle\oradata\MyDB\control02.ctl db_block_buffers = 2048 db_block_size = 8192 compatible = 8.1.0 log_buffer = 32768 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 db_files = 1024
remote_login_passwordfile= EXCLUSIVE global_names = TRUE distributed_transactions = 10 service_names = MyDB instance_name = MyDB sort_area_size = 66560 db_name = MyDB open_cursors = 300 os_authent_prefix = utl_file_dir = * job_queue_processes = 0 parallel_max_servers = 5 background_dump_dest = D:\Oracle\admin\MyDB\bdump user_dump_dest = D:\Oracle\admin\MyDB\udump max_dump_file_size = 10240
PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7
Fri Mar 21 10:35:10 2003
Completed: alter database open
Fri Mar 21 10:40:46 2003
alter database recover
Fri Mar 21 10:40:46 2003
Media Recovery Start
Media Recovery failed with error 1124
ORA-283 signalled during: alter database recover...
Fri Mar 21 10:43:33 2003
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\ORADATA\MyDB\REDO01.LOG
SMON: terminating instance due to error 600
Instance terminated by SMON, pid = 1492
________ End of ALRT.LOG ___________
So I checked the TRC file mentioned :
________ Beginning of TRC file ____________
Dump file D:\Oracle\admin\MyDB\bdump\MyDBSMON.TRC
Fri Mar 21 10:35:09 2003
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
Windows NT V5.0, OS V8.147, CPU type 586
Instance name: MyDB
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 1492, image: ORACLE.EXE
D8BCC8
_ksfdmp+e CALLrel _ksedmp+0 3 _kgeriv+95 CALLreg 00000000
738A0
3
_kgeasi+67 CALLrel _kgeriv+0
1E440
6DEAA04 1061
2
6D8BE40
_kturdb+5d CALLrel _kgeasi+0
738A0
6DEAA04 1061
2 2 0
6AE 0
8CA
_kcoapl+484 CALLreg 00000000 _kcbapl+7a CALLrel _kcoapl+0 _kcrfwr+bfd CALLrel _kcbapl+0
E09084
3AC7274
6D8BFB8
_kcbchg1+15b1 CALLrel _kcrfwr+0 _ktuchg+b57 CALLrel _kcbchg1+0 _ktbchg2+59 CALLrel _ktuchg+0 _kddchg+155 CALLrel _ktbchg2+0 0
3EE00C4
6E08EE0
6E08EE8
6E09084
6E0888C
6E0900C
0 0
_kdddrp+2d9 CALLrel _kddchg+0
E0885C
6E08EE0
6E08EE8
6E09084
6E0900C
0
FFFFFFD0
_kdddel+34b CALLrel _kdddrp+0 E0900C _kaudel+4d CALLrel _kdddel+0
E08A94
0
_delrow+afb CALLrel _kaudel+0
E08A90
0
6E0885C
3EDFE40 4 E
_qerdlFetch+df CALLrel _delrow+0
EE15E8
7FFF
_delexe+46d CALL??? 00000000 _opiexe+18d3 CALLrel _delexe+0 EE15E8 _opiodr+4ce CALLreg 00000000 4 3 6D8E720 _rpidrus+82 CALLrel _opiodr+0 4 3
6D8E720
2
_skgmstack+72 CALLreg 00000000 D8E390 _rpidru+7f CALLrel _skgmstack+0
D8E3A8
173730
F618
5A3A20
6D8E390
_rpiswu2+1e2 CALLreg 00000000 D8E6C4 _rpidrv+5d5 CALLrel _rpiswu2+0
9EAB68 0
6D8E670
2
6D8E690
0
6D8E670
0
5A3910
5A3B40
6D8E6C4
8
_rpiexe+2c CALLrel _rpidrv+0 _ktsscu+388 CALLrel _rpiexe+0 2 _kqrcmt+230 CALLreg 00000000
F09750
2
_ktcrcm+2c1 CALLrel _kqrcmt+0
B89F38
1 0
_ktssdro_segment+688 CALLrel _ktcrcm+0
B89F38
0 0 0
0 1 0
0
_ktssdt_segs+18b CALLrel _ktssdro_segment+0 1 3F09750 _ktmmon+d4a CALLrel _ktssdt_segs+0 0
7FFFFFFF 7FFFFFFF 0
_ksbrdp+1d7 CALLreg 00000000 1CC408 _opirip+22c CALLrel _ksbrdp+0 _opidrv+365 CALLrel _opirip+0 32 0 0 _sou2o+19 CALLrel _opidrv+0 _opimai+156 CALLrel _sou2o+0
D8FE28
32 0
0
_BackgroundThreadStart_at_4+12a CALLrel _opimai+0 3 6D8FF78 77E7B2D5 CALLreg 00000000----- Argument/Register Address Dump -----
________ End of TRC file ____________
The "Current SQL statement for this session" is not always this one, so I suspect some random errors somewhere. Perhaps a bad blok in one on the datafile ???
I was thinking to put offline some datafile but this is not possible unless the DB is open. So I have to manage all things from the MOUNT stage.
Anyone can give a hints please ?
-- Charly Email : calebrun-No-Spam-I-Said!-_at_yahoo.comReceived on Fri Mar 21 2003 - 04:29:53 CST