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/