-
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!
-
Reply
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,
Jigar D Pota
Oracle Certified DBA
India
98791 88534
(The Final Frontier !!)
-
Re: Reply
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.
Amar
"There is a difference between knowing the path and walking the path."
-
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
-
Re: help!! oracle8.1.5.0 has been crash down!
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?
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|