Site Network: Home | About

ORA-00257: Archiver error. Connect internal only, until freed
something really not good. Usually, perhaps mostly, occurs when database runs in ARCHIVELOG mode and space is running out in archive destination directory. Oracle archives the redo logs timely to a specified archive location (timely/on commit...) so that recovery is guaranteed at later time. But we should keep a check on space utilization in destination directory. If we miss, Oracle may most likely stop new any external connections until DBA clears the space on dest directory.
ORA-00257: archiver error. Connect internal only, until freed. Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file. Action: Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.
Fix to this was briefly explained by Donald Burleson in his pages below ...
We do this problem recently in one of our production environments, after which only i started finding some details about this error. Respective 10g database was recently moved to a new box and so the error as backup maintenance cron scripts from old box were not migrated to new box. As there was not job to backup the archive logs on schedule basis space on file system ran out and finally database hung up. What is surprising me most is why would we still need a cron to manage few of the Oracle jobs. We may likely loose the control when things are scattered. Moment I realized crons were being used for archive back up, I felt Oracle should have already had a better way to handle these tasks. I searched for it and found there is a way...OEM can do this for us. Below link explains that...
It's just that people have to leverage the feature that has been given for what they paid for. At this time I don't have much idea on cons of using OEM, but this is an advantage unless there is not hidden side effects. - Karteek

0 Comments:

Post a Comment