[Fix]-ORA-00257archiver error
ORA-00257:archiver error
Scenario:
- When connecting to the database, the following error occurs:
- ORA-00257:archiver error. Connect internal only until freed.
- But the same worked well till the previous day.
Reason for this issue:
Space issue or log pointer issue.
Fix 1:
Type the command in SQL*Plus as
SQL> show parameter log_archive
If LOG_ARCHIVE_START is FALSE, set it to TRUE.
If LOG_ARCHIVE_DEST points to an invalid directory, change it to point to a valid directory.
Note: Access to SQL*PLUS is possible only as sysdba.
Fix 2:
This can also be a space quota issue for archiving. The space allotted for log may have reached its max limit. So the best way is to clear the logs after making backup of the same in a removable disk.