重做日志文件出错，如何打开数据库？
重做日志文件出错，
数据库打不开，
该如何做呢？
没有备份
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00314: log 1 of thread 1, expected sequence# doesn't match
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
方法 我试过了，
依然不行，
请 高手 帮帮忙呀
$ sqlplus sys/123456 as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 9 15:06:24 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup mount;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL>
SQL>
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL>
SQL>
SQL> alter database clear logfile group 1;
Database altered.
SQL>
SQL>
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL>
谢谢～！
使用如下就好用了：
alter database clear logfile group 1;
alter database open ;
shutdown;
startup;
页:
[1]