[Fix]-ORA-00257archiver error

Wikitechy | 691 Views | oracle | 28 May 2016

 

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.





Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise