My Oracle Support Banner

How to make database open when FRA is full (Doc ID 2980929.1)

Last updated on NOVEMBER 26, 2023

Applies to:

Oracle Database - Standard Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

 The purpose of this note is to provide a method, to resolve the scenario of that the database cannot be opened because of full FRA(ORA-19815):

After DB instance restarted, it cannot startup, even "startup nomount" failed with ORA-03114. In our case, ORA-19815 error occurred because of FRA is full of archived logs, we can consider changing db_recovery_file_dest_size value and removing archived logs to resolve this issue.

Solution

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
Goal
Solution


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