Re: NT4 / Ora 7.3.4 data corruption ??

Tony

Contact Support and tell them the arguments to the ORA-00600 errors. They're the only ones who can tell you what the problem is.

HTH. Pete

Tony Adolph wrote:

> Hello All,
>
> Last week I created a database from a image backup of another (Ora
> 7.3.4)
>
> All seemed to work well until today:
>
> SQL> select count(*) from pin.item_t;
> ERROR:
> ORA-00600: internal error code, arguments: [4146], [10143], [9943], [],
> [], [], [], []
>
> SQL> select count(*) from pin.service_t;
> ERROR:
> ORA-00600: internal error code, arguments: [4146], [65183], [64983],
> [], [], [], [], []
>
> The trace files produced by these errors are large and start like:
>
> Dump file d:\logfiles\ORA00283.TRC
> Tue Aug 31 14:13:24 1999
> ORACLE V7.3.4.0.0 - Production vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Oracle7 Workgroup Server Release 7.3.4.0.0 - Production
> With the distributed option
> PL/SQL Release 2.3.4.0.0 - Production
> Windows NT V4.0, OS V5.101, CPU type 586
> Instance name: pinp
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 9
>
> pid: 11b
>
> *** 1999.08.31.14.13.24.859
>
> *** SESSION ID:(8.3) 1999.08.31.14.13.24.859
>
> Dump of buffer cache at level 3
>
> BH #99738 (0x102d6f88) dba: 0x03004275 (3/17013) class 26 ba: 0xde4d000
> hash: [115941b0,111dac38], lru: [102d7030,115ee21c]
> st: XCURRENT, md: NULL, rsop: 0x0, temp: 979
> cr:[[scn: 0xffff.ffffffff],[xid: 0x0000.000.00000000],[uba:
> 0x00000000.0000.00], sfl: 0x0]
>
> L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
> buffer dba: 0x03004275 inc: 0x00091dbe seq: 0x00000017
> ver: 1 type: 2=KTU UNDO BLOCK
>
> ************************************************************************
> ********
> UNDO BLK:
> xid: 0x0009.01e.0001752d seq: 0xfdd7 cnt: 0x16 irb: 0x16 icl: 0x0
> flg: 0x0000
>
> Rec Offset Rec Offset Rec Offset Rec Offset Rec
> Offset
> ------------------------------------------------------------------------
> ---
> 0x01 0x0764 0x02 0x0706 0x03 0x06a1 0x04 0x066a 0x05
> 0x0626
> 0x06 0x05c8 0x07 0x0569 0x08 0x050a 0x09 0x04b8 0x0a
> 0x0459
> 0x0b 0x0417 0x0c 0x03c8 0x0d 0x0388 0x0e 0x0339 0x0f
> 0x02ea
> 0x10 0x02a8 0x11 0x0259 0x12 0x01e3 0x13 0x0194 0x14
> 0x0125
> 0x15 0x00bb 0x16 0x0088
>
> Do I have a fatal data corruption and have to rebuild the database, or
> is there something else I can do?
>
> Any help would be very appreciated,
> Cheers
> Tony Adolph
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Tue Aug 31 1999 - 13:17:22 CDT