Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while starting the database

dba88Apr 10 2013 — edited Apr 10 2013

Hi

I have Oracle database 11g on windows XP SP3 professional edition.It is my test database.
Whenever I startup my database by giving command
startup

it gives following error:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

then I give following command:

alter database open resetlogs;

and it give the error:

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '%Path%\SYSTEM.DBF'

Clearly I need recovery of file SYSTEM.DBF. But I don't have backup for system.dbf

How can I get rid of this error, please suggest.

Thanks,
Charan

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2013

Added on Apr 10 2013

#11g, #database, #error, #general-database-discussions, #oracle, #windows

6 comments

1,201 views