Sunday, July 3, 2011

ORA-19809: limit exceeded for recovery files

RMAN-03002: failure of backup plus archivelog command at 07/04/2011 10:58:39
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 1530219520 bytes disk space from 4039114752 limit

Got this error.

You need to increase your flashback recovery area by

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=4G scope=both;

Also you can delete old backup from recovery area.


Cheers!!!

No comments:

Post a Comment