| ora-01194 after creating control file [message #307182] |
Tue, 18 March 2008 01:45  |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
