Chinaunix

标题: 帮忙解决 [打印本页]

作者: highcofe1 时间: 2003-09-27 12:06
标题: 帮忙解决
SQL>; startup mount
ORACLE instance started.

Total System Global Area 2199356496 bytes
Fixed Size                742480 bytes
Variable Size          1140850688 bytes
Database Buffers       1056964608 bytes
Redo Buffers                798720 bytes
Database mounted.
SQL>; alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-16038: log 2 sequence# 199 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '/dev/rRedo_121'
ORA-00312: online log 2 thread 1: '/dev/rRedo_122'
为什么会怎样，怎么解决？谢了

作者: wangshim_ 时间: 2003-09-27 14:09
标题: 帮忙解决
redo log 无法归档．
应该是日志文件已经满，
而且又归档不了，所以造成第三个或第Ｎ个
ＲＥＤＯ日志文件创建不成功．
可以先ＳＴＡＲＴＵＰ　ＭＯＵＮＴ　，然后手工归档．
然后在ＯＰＥＮ　ＤＡＴＡＢＡＳＥ　，应该没问题了．

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)