Hi,

I'm facing some problems with oracle 9i on my test machine. It seems the database has badly crashed. While using 'startup mount;' command I was receiving some error for REDO03.LOG file, which I solved somehow by using 'alter database rename file 'old path' to 'new path';' command.

On using 'alter database open resetlogs;' command, I receive error message as below:

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: 'C:\ORACLE\ECC\SYSTEM01.DBF'

Please advice how to resolve this error. Secondly, please post your replies with commands as I'm not too used to Oracle.