linuxoracle-databaseora-00257

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

I am using Oracle 10g database server. It will not allow me to connect to my user showing this error:

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

I found that this is the issue of space on database machine. How can I free space to get my database working?

Solution

  • I suggest you speak to your DBA or whoever is the sysadmin for the machine.

    The database has "frozen" operations that require redo until more space is available to write archived redo-log files to.