Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Muhammad Riyaz
Occasional Visitor

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

I am using Oracle 9i and Window XP:

I day before yesterday successfully Incompletely recovered the same database, which I tried again to recover incompletely because I wanted to learn more.

I was trying to recover a table I lost accidently. I used the following command:

C:\> STARTUP MOUNT PFILE=c:\oracle\Test_Machine\ordb9i04\pfile\init.ora

The connection was successful and I typed:

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL TIME '2005-01-18:21:26:00';

And then all hell loose broke on me:

I got the following:

SQL> recover database using backup controlfile until time '2005-01-18:21:26:00';
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORDB9I04\SYSTEM01.DBF'

I tried to copy back old backup copies to the target files, I tried the backup copies of the files I backed up after RESETLOGS, but in vain, NOTHING WORKS. PLEASE REPLY.

Thanks:

MR
7 REPLIES
Kent Ostby
Honored Contributor

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

Muhammad -- Please check this ITRC thread to see if it helps answer your issue:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=774701

Best regards,

Oz
"Well, actually, she is a rocket scientist" -- Steve Martin in "Roxanne"
Kent Ostby
Honored Contributor

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

Also, take a look at google for the ORA-01190 error messages and you'll find some forum posts on Oracle's side of things.
"Well, actually, she is a rocket scientist" -- Steve Martin in "Roxanne"
Indira Aramandla
Honored Contributor

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

Hi Muhammad,

When you say you had performed a incomplete recovery successfully. Now the same database, when you try again to recover it fails.

When you tried the second time did you do the following.

Shutdown the database that you recovered earlier, restore the datafiles, redologs and controlfiles from the backup into their respective directories. And then tried to recover.

If you did so you should be able to recover it and open the database.

The error â ORA-01190: controlfile or data file 1 is from before the last RESETLOGS â occurs when you are attempting to use a data file when the log reset information in the file does not match the control file. This could be because either the data file or the control file is a backup that was made
before the most recent ALTER DATABASE OPEN RESETLOGS.

Restore files from a more recent backup and then try to recover.

In
Never give up, Keep Trying
Indira Aramandla
Honored Contributor

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

Hi,

I forgot one more thing.

You mentioned that you tried the backup copies of the files that you backed up after RESETLOGS.

Please try to copy form a previous successfull backup.

Indira A
Never give up, Keep Trying
Muhammad Riyaz
Occasional Visitor

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

Hello Kent Ostby. Indira Aramandla:

Thanks for your messages:

It help me a lot to understand and resolve the problem. I recovered my Database.

If you or any one of your friend know one or more books where I can learn and practice the techniques of resolving the Backup_Recovery and Tune up issues, I will appreciate it a lot.

Thanks again for your help.

Truly Yours

Muhammad Riyaz
11673 Sandalwood Lane
Manassas, VA 20112
riyazm@gmail.com
blf2vkr@gmail.com
703.680.7566
Indira Aramandla
Honored Contributor

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

Hi Muhammad,

Nice to know that you could recover your database.

Books where you can learn and practice the techniques of resolving the Backup_Recovery
and Tune up issues:- Here they are.

1. 1.Backup and Recovery Book by

Ramavelpuri---Oracle Press is very good.

2. OCP Backup and RecoveryOracle Training material.

3. download model software from www.Boson.com http://www.Boson.com

4. Oracle Documentation CD.

5. A good reference book â Architecture and Backup Recovery
by Sybex series.

Here are 2 more links to book references:
http://www.oraclebooks.com/
http://www.oracle-books.com/dba/

Some Oracle tips & tricks
http://www.uaex.edu/srea/


Indira
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

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

hi,

one very important "MUST KNOW" document is found at:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/toc.htm

hope this helps!

regards
Yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)