A common problem related to the Flash Recovery Area is "ORA-19809: limit exceeded for recovery files~ORA-19804: cannot reclaim 44040192 bytes disk space from 429496729600 limit". If you can confirm that that error is coming from the flash recovery area, you can simply issue the following:
SQL> show parameter db_recovery_file_dest_size
NAME TYPE VALUE
------------------------------ ------------- -------
db_recovery_file_dest_size big integer 400G
SQL> alter system set db_recovery_file_dest_size=200G
SQL> alter system set db_recovery_file_dest_size=400G
Simply setting the recovery dest file size to a smaller value temporarily will remove the oldest files...of course you will lose some of the history you can flashback to, so be aware of this.
Tips and wisdom from 15 years of DBA experience
Wednesday, February 10, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment