environment - oracle 8.1.7
os - windows NT
database mode - Noarchivelog mode
i was testing backup and recovery so i had a setup in one machine made. so i took a offline backup of all the datafiles, logfiles, redologs ,control files.
I deleted one tablespace with including contnets option.
Then i went to the OS level and deleted the datafile.
Then restored the whole offline backup in order to get the database in sync.
when i started the database i got this error message.
ORA-00338: log 1 of thread 1 is more recent than controlfile
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORACLE\REDO03.LOG'
Advise. what is to be done.
Thanks in advance
Did you restore all backup files including redo logs and control files. It seems that you didn't restore redo log files.
I think you are using the wrong control file. Did you restore the right control file?