Home » RDBMS Server » Server Administration » ora-01194 after creating control file (10.2.0.1,RHEL 4)
ora-01194 after creating control file [message #307182] Tue, 18 March 2008 01:45 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I had to change the mount points of oracle home.
AFter that i modified all the files to reflect the new mount point.

But during startup,it throws the error

ora-01157-cannot identify/lock datafile 1 /u/app/oracle/oradata/orcl/system01.dbf
Now the location is /u1/app/oracle/oradata/orcl/...

Obviuosly this due to control file still poiting to old location.

So i recreated the modified controlfile but now i got
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u1/app/oracle/oradata/orcl/system01.dbf'

Why i got this error?
now how to bring back the database?
Re: ora-01194 after creating control file [message #307195 is a reply to message #307182] Tue, 18 March 2008 02:11 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Ok done
Previous Topic: How to check the status of database
Next Topic: Explain High water mark level in depth??
Goto Forum:
  


Current Time: Fri Dec 02 12:08:02 CST 2016

Total time taken to generate the page: 0.09625 seconds