ORA-19809: limit exceeded for recovery files

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit

Cause : backup size exceed the size limit of backup destination (set to db_recovery_file_dest  )

Solution :

• Delete or move old backups and make space in db_recovery_file_dest   folder
• Increase the size of  db_recovery_file_dest_size          

How to increase the size of db_recovery_file_dest_size          

Sqlplus / as sysdba

SQL> show parameter recovery

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      /home/oracle/10.2.0/product/fl

                                                 ash_recovery_area

db_recovery_file_dest_size           big integer 2G

recovery_parallelism                 integer     0

SQL> alter system set db_recovery_file_dest_size=10g scope=both;

System altered.

Now take backup it will complete successfully