How to solve Oracle Database Error 1190 (ora-01190)

Oracle Error Code
   ora-01190

Description
   control file or data file string is from before the last RESETLOGS

Cause
   Attempting to use a data file when the log reset information in the file does not match the control file. Either the data file or the control file is a backup that was made before the most recent ALTER DATABASE OPEN RESETLOGS.
How to Solve
   Restore file from a more recent backup.
Posts About Oracle Database Error ORA-01193
Asiq:
Hi,
I have got error, that
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\RRD\SYSTEM01.dbf’
when I tried to do incomplete recovery so please help me to how to solve?
Thanks 
Regards
Asiq


Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-01090    ORA-01091    ORA-01092    ORA-01190    ORA-01191    ORA-01192    ORA-01193  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares