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