哪位大侠在启数据库时遇到ORA-01589报错的，库打不开。急！

yqxfm

SVRMGR>; startup mount
ORACLE instance started.
Total System Global Area 546205412 bytes
Fixed Size 69348 bytes
Variable Size 341164032 bytes
Database Buffers 204800000 bytes
Redo Buffers 172032 bytes
Database mounted.
SVRMGR>; select * from v$controlfile;
STATUS NAME

------- ------------------------------------------------------------------------
--------
/weboradb/oradata/oradata/ahoradb/control01.ctl

/weboradb/oradata/oradata/ahoradb/control02.ctl

/weboradb/oradata/oradata/ahoradb/control03.ctl

3 rows selected.
SVRMGR>; alter database open;
alter database open
*
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR>; alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/weboradb/oradata/oradata/ahoradb/
system01.dbf'

yqxfm

su oracle
$ sqlplus /nolog

SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jan 16 10:19:14 2004

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

SQL>; conn / as sysdba
Connected to an idle instance.
SQL>; startup mount
ORACLE instance started.

Total System Global Area  546205412 bytes
Fixed Size                    69348 bytes
Variable Size             341164032 bytes
Database Buffers          204800000 bytes
Redo Buffers                 172032 bytes
Database mounted.
SQL>; alter database open resetlogs
  2

pondka

是
SQL>; alter database open resetlogs;
不是
SQL>; alter database open resetlogs
2

记得加";"

txfy

o,终于看明白问什么了！我还说你很幸运resetlogs竟然没有任何错误就过去了呢！

yqxfm

SQL>; conn / as sysdba;
Connected to an idle instance.
SQL>; startup mount;
ORACLE instance started.

Total System Global Area  546205412 bytes
Fixed Size                    69348 bytes
Variable Size             341164032 bytes
Database Buffers          204800000 bytes
Redo Buffers                 172032 bytes
Database mounted.
SQL>; alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/weboradb/oradata/oradata/ahoradb/system01.dbf'


SQL>;

pondka

那就在startup mount 后,
SQL>; recover database until cancel;
然后在出现提示输入文件名时,直接敲回车.
一直回车,直到说文件找不到.
然后敲cancel
再然后
SQL>; alter database open resetlogs;

txfy

呵呵，看来我没说错，果然没那么好的事，你的system表空间数据文件跟控制文件不符，需要recover，根据我的经验，你只能从备份恢复了，如果你有rman备份还好，或者archive log mod也行，都没有的话可能需要逻辑imp了！

pondka

输入:
SQL>; recover database until cancel;
提示文件名的时候,敲回车.一直回车.
提示找不到文件的时候,输入cancel;
然后再:
alter database open resetlogs;

前提是你的归档日志都在,并没有移动到其他地方.

yqxfm

SQL>; recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL>;

yqxfm

[quote]原帖由 "txfy"]呵呵，看来我没说错，果然没那么好的事，你的system表空间数据文件跟控制文件不符，需要recover，根据我的经验，你只能从备份恢复了，如果你有rman备份还好，或者archive log mod也行，都没有的话可能需要逻辑imp了?.........[/quote 发表：


如何imp？