i m getting an error while restoring datafile that
file is more recent then control file --- older control file
pls. help me to sort out this problem as soon as possible
this is too urgent
thanks in advance
recreate the controlfile
recover database using backup controlfile;
I hope your current redo logs arent lost?
but that control file contain all information
about my datafiles
can i create a new control file and add into my database
i will tell u the exact problem
actually we forgot the password of nt
so we install it again
at that time i was not able to take hot backup
that's why i acess that mechine from its clients
and copy al the files
but when I m going to restore it agian
after installing oracle
but it is giving error that i mentioned earlier
so pls. resolved my problem
when you say you copy all the files you mean the datafiles of database without shutting it down???
Do you have any backup of your controlfile at all, if you have then you dont need to recreate one simply copy it to the directory where the controlfiles are then using the command recover database using backup controlfile.
Click Here to Expand Forum to Full Width