oracle RA-00257：存档错误。仅连接内部，直到释放
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5203367/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
RA-00257: archiver error. Connect internal only, until freed
提问by Zeeshan
I am using Oracle 10g database server. It is not allow me to connect to my user and says "RA-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 ? Please guide.
我正在使用 Oracle 10g 数据库服务器。它不允许我连接到我的用户并说“RA-00257：存档程序错误。仅在内部连接，直到被释放”。我发现这是数据库机器上的空间问题。我怎样才能释放空间让我的数据库工作？请指导。
回答by cagcowboy
I suggest you speak to your DBA or whoever is the sysadmin for the machine.
我建议您与您的 DBA 或机器的系统管理员联系。
The database has "frozen" operations that require redo until more space is available to write archivedredo-log files to.
数据库具有需要重做的“冻结”操作，直到有更多空间可用于将归档重做日志文件写入其中。
回答by Sadeq Aramideh
I have encountered this error couple of times, it simply tells that archivelog space has exhausted and need to be freed.
我遇到过几次这个错误，它只是告诉我们归档日志空间已经用完，需要释放。
> set oracled_sid=write_oracle_sid_here
> rman target sys/put_sys_password_here
> crosscheck archivelog all;
> delete noprompt expired archivelog all;
>exit;
