ORA-00312: online log 6 问题

最新推荐文章于 2024-07-30 08:30:00 发布

csdnhadoop

最新推荐文章于 2024-07-30 08:30:00 发布

阅读量603

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/csdnhadoop/article/details/51069615

本文详细介绍了如何解决Oracle数据库中遇到的特定错误，即ORA-00313错误，该错误涉及到无法打开日志组6中的成员。通过执行SQL命令ALTER DATABASE CLEAR LOGFILE GROUP 6，可以成功修复该问题并停止归档进程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Errors in file /oracle/app/oracle/diag/rdbms/pdunq/xxx/trace/xxx_arck_21828.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/home/oradata/xxx/redo_dg_03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Apr 06 01:14:25 2016
Shutting down archive processes
Wed Apr 06 01:14:25 2016
ARCH shutting down

ARCk: Archival stopped

解决办法就是：clear它

SQL> alter database clear logfile group 6;

Database altered.

SQL>