ORA-00257: archiver error. Connect internal only, until freed.

ORA-00257: archiver error. Connect internal only, until freed.

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:\oracle\fast_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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.