File is more recent than controlfile - old controlfile
RDBMS Version: 9.2.0.4
Operating System and Version: Red Hat Linux 7.3
Error Number (if applicable): ORA-01207
Product (i.e. SQL*Loader, Import, etc.):
Product Version: Oracle 9i
Couldn't start the database: file is more recent than controlfile - old controlfile
Hi friends
I would like some advice what are the step to taken to solve the below problem.
Everytime I startup the database I got this error :-
Total System Global Area 95122692 bytes
Fixed Size 451844 bytes
Variable Size 92274688 bytes
Database Buffers 2252800 bytes
Redo Buffers 143360 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/data/oradata1/DATA1/system01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
The database can not be open as normal.
For your information, this database used for development and testing. So the ARCHIVELOG has not been utilize.
Is there away to at least save all the schema inside it.
Thanks
abemie