Printable View
Hi,
I was doing a larger transaction when my instance crashed. The alert log file showed the message:
Instance terminated due to error 470
this error represents error in log buffer process (LGWR)
Why this happened? what can I do?
I use Oracle 8.1.5.0.0 on RedHat Linux 6.2
check select * from v$log from svrmgrl.exe if you sequence# is greater or at 65535
then LGWR is died.
you should issue the following commands,
shutdown abort
startup
>>>it would tell you instance was'nt started
startup mount
recover database until cancel;
alter database open resetlogs;
REM Resetlogs is very important in this case.
Hope this helps