文件被删除之后"/>
oracle redo01. log,redo01.log文件被删除之后
,哎,一失足,成千古恨那,
各位大哥帮帮看看怎么办。
昨天,小弟不慎将redo*.log删除,
oracle即无法startup,
之后用"startup mount" 启动起来,
查看logfile
sql> select group#,member from v$logfile;
GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
1
/oracle/ora8i/redo01.log
2
/oracle/ora8i/redo02.log
3
/oracle/ora8i/redo03.log
sql>
首先想drop 掉原来的logfile
sql> alter database drop logfile member '/oracle/ora8i/redo01.log';
提示错误:
ERROR at line 1:
ORA-00361: cannot remove last log member /oracle/ora8i/redo01.log for group 1
更多推荐
oracle redo01. log,redo01.log文件被删除之后
发布评论