ORA-00312: online log 6 问题

最新推荐文章于 2022-06-06 14:01:53 发布

csdnhadoop

最新推荐文章于 2022-06-06 14:01:53 发布

阅读量547

点赞数

本文链接：https://blog.csdn.net/csdnhadoop/article/details/51069615

版权

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>