Error:
On checking the alert log we found the following error in alert log:
ORA-00257: archiver error. Connect internal only, until freed.
OR
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 904507904 bytes disk space from 6442450944 bytes limit
Cause:
The archiver process received an error while trying to archive a redo log and storage is out of space for the redo log file
If the problem is not resolved, the database will stop.
Solution
1. Check the archive is enabled.
Archive log list
2. Check the db_recovery_file parameter.
show parameter db_recovery_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:oraclefast_recovery_area
db_recovery_file_dest_size big integer 10G
3. Check the space left at destination from SQLPLUS.
select (space_limit)/1024/1024/1024 "Totalspace",(space_used)/1024/1024/1024 "USED",(space_reclaimable)/1024/1024/1024 "RECLAIMABLE", NUMBER_OF_FILES "NOOFFILES", NAME "LOCATION" from v$recovery_file_dest;
4. If you have space then increased the value of parameter otherwise next step.
ALTER SYSTEM SET db_recovery_file_dest_size=15G SCOPE=BOTH SID='*';
5. For solve, empty the location or move the archives to another location.
alter system archive log all;
6. If 5 step not worked, then switch the destination to new location with following command.
ALTER SYSTEM SET log_archive_dest_1='location=D:oraclexe reopen';
7. You can also fixed it with RMAN.
RMAN>crosscheck archivelog all;
RMAN>delete noprompt expired archivelog all;
--For clear all archivelog
RMAN> delete archivelog all;
