NT4 / Ora 7.3.4 data corruption ??

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Tue, 31 Aug 1999 12:03:30 GMT
Message-ID: <7qggae$fes$1@nnrp1.deja.com>

 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 - 07:03:30 CDT