-
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
Best Regards,
Harsh Shah
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
|