help!! oracle8.1.5.0 has been crash down!

help!! oracle8.1.5.0 has been crash down!

when i truncate a table ,suddenly ,the power has down . when i turn on the server and i could not startup the database. and then i tail alert.log and found
ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []
Mon Nov 8 13:25:47 2004
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 4220

I use google to search above message and found that was oracle's bug
this bug would appear in oracle8i to oracle9i when use truncate a table and truncate's process suddenly abort .

The sticking point was system has dirty information. i had been used
_corrupted_rollback_segments(system) to drop the system table,when i startup the database ,it indicate that it was not the correct parameter to oracle.

how can i do ? plesase help me!

Hi,

Probably you need to reinstall the database.

But before that please checkout the process with pis=4220 is running or not if it is running kill that process and try again.

Hope this helps

Regards,

Quote:

---

Originally posted by jigarpota
Hi,

Probably you need to reinstall the database.

But before that please checkout the process with pis=4220 is running or not if it is running kill that process and try again.

Hope this helps

Regards,

---

It clearly indicates that the process 4220 was of PMON which killed the instance. And when the instance went down PMON will go down by itself.

As to handle the main question. Better log a priority 1 iTAR. If possible try recovering the database using archived log files if in archived mode, if not then only way to recover would be to restore the cold backup.

This has happened to me before. All you need to do is to perform an incomplete recovery up to the time before you issue the 'truncate' command.

Goodluck.

Ed

Quote:

---

Originally posted by kevinkan
help!! oracle8.1.5.0 has been crash down!

when i truncate a table ,suddenly ,the power has down . when i turn on the server and i could not startup the database. and then i tail alert.log and found
ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []
Mon Nov 8 13:25:47 2004
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 4220

I use google to search above message and found that was oracle's bug
this bug would appear in oracle8i to oracle9i when use truncate a table and truncate's process suddenly abort .

The sticking point was system has dirty information. i had been used
_corrupted_rollback_segments(system) to drop the system table,when i startup the database ,it indicate that it was not the correct parameter to oracle.

how can i do ? plesase help me!

---

drop the system table?