ORA-600=File iTar.
those error codes look like RBS corruption.
Metalink is the way to go on this one.
"Charly" <SomeOne_at_SomeWhere.on.the.net> wrote in message
news:3E7AE9A0.565F9991_at_SomeWhere.on.the.net...
>
> 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 bytes
> Database mounted.
> Database opened.
>
> [[[ 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
> db_file_multiblock_read_count= 8
> 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
> oracle_trace_collection_name=
> 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:34:55 2003
> alter database mount
> Fri Mar 21 10:34:59 2003
> Successful mount of redo thread 1, with mount id 3236846355.
> Fri Mar 21 10:34:59 2003
> Database mounted in Exclusive Mode.
> Completed: alter database mount
> Fri Mar 21 10:35:00 2003
> alter database open
> Beginning crash recovery of 1 threads
> Fri Mar 21 10:35:01 2003
> Thread recovery: start rolling forward thread 1
> Recovery of Online Redo Log: Thread 1 Group 2 Seq 7 Reading mem 0
> Mem# 0 errs 0: D:\ORACLE\ORADATA\MyDB\REDO02.LOG
> Fri Mar 21 10:35:01 2003
> Thread recovery: finish rolling forward thread 1
> Thread recovery: 3 blocks read, 3 blocks written
> Crash recovery completed successfully
> Picked broadcast on commit scheme to generate SCNs
> Fri Mar 21 10:35:04 2003
> Thread 1 advanced to log sequence 8
> Thread 1 opened at log sequence 8
> Current log# 1 seq# 8 mem# 0: C:\ORACLE\ORADATA\MyDB\REDO01.LOG
> Successful open of redo thread 1.
> Fri Mar 21 10:35:06 2003
> SMON: enabling cache recovery
> SMON: enabling tx recovery
> Fri Mar 21 10:35:09 2003
> Errors in file D:\Oracle\admin\MyDB\bdump\MyDBSMON.TRC:
> ORA-00600: internal error code, arguments: [4193], [1710], [2250], [],
> [], [], [], []
>
> 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
>
>
> *** SESSION ID:(5.1) 2003.03.21.10.35.09.098
> *** 2003.03.21.10.35.09.098
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [4193], [1710], [2250], [],
> [], [], [], []
> Current SQL statement for this session:
> delete from seg$ where ts#=:1 and file#=:2 and block#=:3
> ----- Call Stack Trace -----
> calling call
> entry argument values in hex
> location type
> point (? means dubious value)
> -------------------- --------
> -------------------- ----------------------------
> _ksedmp+a5 CALLrel _ksedst+0
>
> 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.com
>
>
Received on Fri Mar 21 2003 - 06:06:12 CST
