Skip to Main Content

Database Software

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: control file or data file 1 is from before the last RESETLOGS

User_87JK9Sep 14 2014 — edited Sep 15 2014

Hello Experts,

I was restoring my database through cold backup and I had my control file backup of 17th aug and backupset of 21st aug. I have restore my contold file from 17th and retstored the database from 21st backup sets. now I am getting error while opening the database with resetlogs option.

SYS@pqoff1>alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

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

ORA-01110: data file 1: '+DATA/pqoff/datafile/system01.dbf'


Could you please help me out here?


Thanks,

Himanshu

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2014
Added on Sep 14 2014
5 comments
10,871 views