ORA-00350: log string of instance string (thread string) needs to be archived

文档解释

ORA-00350: log string of instance string (thread string) needs to be archived

Cause: The command cannot be done because the log has not been archived, and media recovery has been enabled.

Action: Archive the log or disable media recovery. If the command supports an UNARCHIVED option then it can be used. However this may result in making backups unuseable, and forcing the drop of some offline files.

官方解释

ORA-00350: log string of instance string (thread string) needs to be archived

Cause: The database has detected a problem in an online redo log file. Action: Archive the redo log file indicated.

常见案例

正常处理方法及步骤

1、确保每个日志组中的归档日志文件都具有足够的空间；

2、确保活动日志组中的文件也具有足够的空间；

3、确保在归档日志组文件索引中列出的文件均有足够的空间；

4、你的归档预警阈值可能得到回收；

5、检查你的归档目录是否 hibernate 被满。

如果上述没有解决你的问题，请考虑增加更多的归档文件空间或创建新的归档日志组来增加可用空间。