ORA-02097: parameter cannot be modified because specified value is invalid-ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Cause:

When try setting up FRA, the below error is triggered due to size not specified

SQL> alter system set db_recovery_file_dest='/data01';
alter system set db_recovery_file_dest='/data01'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Workaround:

Specify the FRA size and set FRA location then

SQL> alter system set db_recovery_file_dest_size=5G;

System altered.


SQL> alter system set db_recovery_file_dest='/data01';

System altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s