ORA-00257 - not enough space in recovery file
There are not enough space in the recovery file. Therefore the file size need to be increased.
Check the existing file location and size
--Log into SQLPLUS by using CMD in ADMIN mode
Sqlplus sys/<password>@<instance> AS sysdba
--check the size and location of the fast_recovery file
Show parameter recovery;
Ensure that there is enough free disk space before increasing the recovery file!
If there are not enough free disk space on the server, the customer need to increase it before taking any actions.
--This script will set the archivelog filesize to 200GB
Alter System set DB_RECOVERY_FILE_DEST_SIZE = 200G SCOPE=BOTH;
CalWin will be available instantly.
If Oracle do not start after the increase of recovery file size, additional steps are needed.
startup nomount;
Alter System set DB_RECOVERY_FILE_DEST_SIZE = 200G SCOPE=BOTH;
shutdown abort;
startup;
Last updated
Was this helpful?