Site icon IT Tutorial

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Hi,

Sometimes You can get “ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE ” error.

 

Details of error are as follows.

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Cause: There are two possible cause for this error:

1) The DB_RECOVERY_FILE_DEST parameter was in use when no DB_RECOVERY_FILE_DEST_SIZE parameter was encountered while fetching initialization parameter.

2) An attempt was made to set DB_RECOVERY_FILE_DEST with the ALTER SYSTEM command when no DB_RECOVERY_FILE_DEST_SIZE was in use.

Action: Correct the dependency parameter definitions and retry the command.

SQL> alter system set db_recovery_file_dest='+DATA' scope=both sid='*';
alter system set db_recovery_file_dest='+DATA' scope=both sid='*'
*
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

 

 

To solve this error , you need to firstly set the db_recovery_file_dest_size parameter, then set db_recovery_file_dest parameter.

 

SQL> alter system set db_recovery_file_dest_size=50G scope=both sid='*';

System altered.

SQL> alter system set db_recovery_file_dest='+DATA' scope=both sid='*';

System altered.


 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

Exit mobile version