My Oracle Support Banner

Troubleshooting Guide for ORA-00470 - LGWR Process Terminated With Error (Doc ID 1557768.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.Purpose

 This article will discuss most of the reasons where an ora-00470 error will appear and how those should be solved.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
  What is the ora-00470 error?
 Known Issues:
 ora-470 accompanied with ora-447 error:
 Pmon terminated instance due to LGWR
 ORA-470 and ORA-204
 Alter System Switch Logfile errors with ora-470
 ora-447, ora-00313, ora-00312
 Further Diagnostics:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.