Oracle Database Discussions

Hi All:

I have an issue. I also check the internet for solutions. Please i need an advise. The error is :

ORA 01122 Database file 2 failed verification.

ORA 01110: Datafile 2 : Undo.dbf

ORA 01207 : File is more recent than control file - old control file

Do I back up control file to trace with noresetlog and now use the controfile to recover the database. There is a database software that runs on oracle and i think the database is in NoArchivelog mode. Also i found out from the internet that i will have to recover the database after creating the control file.

For NORESETLOGS – You have to use the following Command
RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE ‘/xxx/xxxx/Temp01.dbf’ REUSE;

I need your help so that i can advise my manager.


Thanks and Kind Regards,
Jude