Posted by martijnl on February 13, 2007
I shouldn’t be writing that all is well on the Oracle front.
Just now two of the Oracle servers froze with database problems. The DBA tells me that they have block corrupts which he hasn’t seen in five years of running the things.
Both instances were terminated by PMON due to unreadable
logfile or spfile. The errors look like this;
ORA-00471: DBWR process terminated with error
PMON: terminating instance due to error 471
Instance terminated by PMON, pid = 26973
ORA-00470: LGWR process terminated with error
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 25260
One instance is a 126.96.36.199 database, the other a 10.2.0.1 database, on separate virtual machines.
For Oracle 9i: Restore from backup.…
For Oracle 10g: Resetlogs by:
recover database until cancel;
recover database until cancel; (a message ‘media recovery complete’ will appear)
alter database open resetlogs;
We are viewing this as an unfortunate incident at the moment but will keep monitoring this closely.