ORA-19802 Error: "Cannot Use Db_recovery_file_dest Without DB_RECOVERY_FILE_DEST_SIZE"

(Doc ID 749595.1)

Last updated on DECEMBER 22, 2016

Applies to:

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


Symptoms

You encounter this error:
ORA-19802 error: "cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE."

Changes

You may see this while trying to start a DB, especially if it is a new DB or if there have been recent changes.

You may be unable to see the current setting for DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE due to ORA-01034 error: "ORACLE not available"


 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms