ORA-00257 - not enough space in recovery file
--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;--This script will set the archivelog filesize to 200GB
Alter System set DB_RECOVERY_FILE_DEST_SIZE = 200G SCOPE=BOTH;startup nomount;
Alter System set DB_RECOVERY_FILE_DEST_SIZE = 200G SCOPE=BOTH;
shutdown abort;
startup;Last updated