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!

ORA-01190: controlfile or data file 1 is from before the last RESETLOGS

694352Jul 27 2009 — edited Jul 27 2009

Hello

I just manuelly restored all the datafiles.However I cant open the database.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS

What should I do?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2009

Added on Jul 27 2009

#general-database-discussions

5 comments

5,108 views