IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
You can get ORA-19809: limit exceeded for recovery files error during the rman operations or database startup.
ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: The error is accompanied by 19804. See message 19804 for further details.
This problem is related with db_recovery_file_dest and db_recovery_file_dest_size parameter. To solve this problem you can change db_recovery_file_dest parameter with blank like following.
SQL> ALTER SYSTEM SET db_recovery_file_dest = '' SCOPE=BOTH;
Or you can increase db_recovery_file_dest_size parameter to solve this problem like following.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=200G SCOPE=SPILE;
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
