Visit Counter

Sunday, January 1, 2017

ORA-19809: limit exceeded for recovery files tips





SQL> alter database open resetlogs;



ERROR at line 1
ORA-19809: Limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10 limit




SQL> show parameter db_recovery



NAME                                            TYPE            VALUE
---------------------------------------------------------------------------------------------------------------------

db_recovery_file_dest                     string               /ora/oracle/oracle12/fast_recovery_file_dest_size
db_recovery_file_dest_Size             big integer         10


SQL> alter system set db_recovery_file_dest_size=8000m scope=both



SQL> alter database open resetlogs;

database altered.

No comments:

Post a Comment