ORA-00312 online log string thread string: 'string'
Cause: This message reports the file name for details of another message.
Action: Other messages will accompany this message. See the associated
messages for the appropriate action to take.
ORA-00313 open failed for members of log group string of thread string
Cause: The online log cannot be opened. The file may not be in the expected
location.
Action: Specify the correct redo log file or make the log available, if necessary.
Also, see the accompanying messages.
Cause: This message reports the file name for details of another message.
Action: Other messages will accompany this message. See the associated
messages for the appropriate action to take.
ORA-00313 open failed for members of log group string of thread string
Cause: The online log cannot be opened. The file may not be in the expected
location.
Action: Specify the correct redo log file or make the log available, if necessary.
Also, see the accompanying messages.
解决方案 »
- pl/sql连不上本机10g数据库,sqlplus可以,请问是怎么回事?
- ORACLE FORALL IN的一个错误,郁闷中
- 00942 table or view does not exist
- 这里有人熟悉oracle补丁方面的信息么?
- 分析一下此SQL该如何写才高效?
- 请问从ACCESS导出表到ORACLE,出现记录过大的错误无法导入,但是该表中才280条记录,怎么回事呢,谢谢
- oracle没有临时表的吗
- 如何获得当前机器上所有配置的TNS别名?
- 怎样在sql plus中终止一个查询语句。
- svrmgrl下怎么退出窗口?
- 为什么说我的OEM的服务器找不到???
- 删除用户出现一个错误,VBO-5530:无法删除用户。ORA-00604:递归SQL层1出现错误
我该如何去恢复它?
那日志文件我只不过打开了一下
怎么就坏了啊?
sqlplus / as sysdba 或 sqlplus "/ as sysdba"
startup mount(如果已经是mounted状态就不用了)
column member format a40
select *
from v$logfile;
看看哪个日志文件坏了,记住它的group#
alter database clear logfile group group#的值;
如果报错就
alter database clear unarchived logfile group group#的值;
alter database open;
应该可以了