十万火急！Oracle数据库导入出现的问题！

[waterson]

我们自己做了一张数据表，然后导入到数据库相应表中。在导入过程中，发现表空间不足，然后导入停止在那里。然后，整个Oracle就趴下了，无法进行一切工作。

用Shutdown命令关闭时报了下面的错误：
SQL> shutdown immediate;
ORA-01109: database not open

恢复时又报了下面的错误：
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 332628 generated at 01/08/2004 16:16:31 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf
ORA-00280: change 332628 for thread 1 is in sequence #25


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'


望高手指点迷津，感激不已！

[waterson]

使用你所说命令也是报错：
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'

[waterson]

既然上述两处都提到了Data File1，即system01.dbf文件，那么，又如何恢复data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'

[welyngj]

由于你丢失了归档日志。
重新来一遍：
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 332628 generated at 01/08/2004 16:16:31 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf
ORA-00280: change 332628 for thread 1 is in sequence #25


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

到了这里的时候你输入cancel，回车。
最后是alter database open resetlogs

[jimhou]

在导入时让其自己建立tablespace

[waterson]

使用Recover命令恢复时还是报了个错误：
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 332628 generated at 01/08/2004 16:16:31 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf
ORA-00280: change 332628 for thread 1 is in sequence #25


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'


ORA-01112: media recovery not started


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: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'

[jimhou]

有没有物理备份文件？

[welyngj]

不能恢复数据了，除非你有原来的数据库的完整物理备份。不完整物理备分也不可以

[waterson]

当时我不在场，他们只把保存数据的DBF文件存到了另外的地方。其它文件都没有动。

[welyngj]

/home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf'找不到归档日志，你可能移动到别的地方了

[waterson]

可是我在整个Oracle目录下根本就没有找到该日志文件啊。

[welyngj]

看看别的目录。如果丢了归档日志那你就不能恢复数据了。

[waterson]

我已经找遍整个机器了，但是还是没有找到这个文件。请问，如果真是没了这个文件，那又该怎么办呢？

[welyngj]

无法恢复归档日志上所有的数据。

试一下。
alter database open RESETLOGS
看能不能打开数据库。