oracle ORA-00257:归档错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5785933/
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
ORA-00257:archiver error
提问by MAlex
When I try connecting to my database, I get the following error.
当我尝试连接到我的数据库时，出现以下错误。
ORA-00257:archiver error. Connect internal only until freed.
ORA-00257:归档错误。仅在内部连接直到被释放。
Till yesterday, the database was pretty functional.
直到昨天，该数据库还非常实用。
Any workaround?
任何解决方法？
采纳答案by Justin Cave
In SQL*Plus, can you
在 SQL*Plus 中，您可以
SQL> show parameter log_archive
- If
LOG_ARCHIVE_STARTis FALSE, you'll want to set it to TRUE. - If
LOG_ARCHIVE_DESTpoints to an invalid directory, you'll want to change it to point to a valid directory.
- 如果
LOG_ARCHIVE_START是 FALSE，您需要将其设置为 TRUE。 - 如果
LOG_ARCHIVE_DEST指向无效目录，您需要将其更改为指向有效目录。
回答by Joe Joy Valiyaveettil
ORA-00257:archiver erroris occured when your archivelog reached the FRA limit. So you have to clear the archivelogs or you may increase the FRA limit.
ORA-00257:归档日志达到 FRA 限制时发生归档错误。因此，您必须清除存档日志，否则您可能会增加 FRA 限制。
To clear the archivelogs, connect to the command prompt and follow steps below:
要清除存档日志，请连接到命令提示符并按照以下步骤操作：
rman target /
RMAN> delete archivelog all;
It will ask for confirmation and you have to give 'yes'.
它将要求确认，您必须给出“是”。
回答by nikunj jain
please note that you can only access SQL*PLUS if you login as sqlplus / as sysdba
请注意，如果您以 sqlplus / sysdba 身份登录，您只能访问 SQL*PLUS
Plus, I think the problem here is space quota for archiving reaching its max limit.
另外，我认为这里的问题是归档达到最大限制的空间配额。
So its best to clear the logs after making backup on a flash or something
所以最好在闪存或其他东西上备份后清除日志
回答by Ghayel
ORA-00257: archiver error. Connect internal only, until freed. problem can be solved as following: copy archivelog folder to a new destination and empty this directory.
ORA-00257: 归档程序错误。仅在内部连接，直到被释放。问题可以解决如下：将archivelog文件夹复制到一个新的目的地并清空这个目录。
The real problem is that online-backup limit increased what was set as n GB and that become full when you empty this archivelog folder then it will start working fine
真正的问题是，在线备份限制增加了设置为 n GB 的内容，并且当您清空此存档日志文件夹时会变满，然后它将开始正常工作
回答by Sadeq Aramideh
I have encountered this error couple of times, it simply tells that archivelog space has exhausted and need to be freed.
我遇到过几次这个错误，它只是告诉我们归档日志空间已经用完，需要释放。
run cmd as administrator
以管理员身份运行cmd
> set oracled_sid=write_oracle_sid_here
> rman target sys/put_sys_password_here
> crosscheck archivelog all;
> delete noprompt expired archivelog all;
>exit;
