How to re-create controlfile
431408May 29 2005 — edited May 24 2012
Hello all,
I get the following errors when I attempt to start the database instance(this was after a power failure which shutdown the machine uncleanly):
SQL>startup
ora-01122: database file 3 failed verification check
ora-01110: database file 3 'C:\oracle\oradata\psdb\CWMIT01.DBF'
ORA-01207: file is more recent than controlfle - old controlfile
How do I create a new controlfile to replace the one which got corrupted?
OS: Windows XP
Database: Oracle 10g
Regards,
Hussam Galal