I have a serveur Windows 2003 with Oracle 10g. Wich is not in production anymore but that we use sometimes to get old data.
The database was initially installed on 3 physical disks C:\ D:\ E:\. But few months ago, we added a phsycal disk H:\ because there was no more space in the other disks.
As in the diusk, on H:\ I have .dbf files (data and index).
The database is in NOARCHIVELOG.
As backup I make an Acronis image disk of C:\ D:\ E\: but not H:\.
I also make a daily datapump of the full database.
The RAID controller of the server crashed and I must reinstall the server on a new machine. I rent a virtual machine to restore the Acronis backup. Disks C:\ D:\ E\: were correctly restored but H:\ was not included oin the image disk.
The H:\ physical disk was in good shape and I connected to the VM.
Now in the restored server, I have all my disks but I cannot start the database because the dbf files on H:\ on more recent than the control files.
I have error message when I start the db:
Is that possible to resynchronize the control files and dbf ?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
Most likely the answer is no.

Your only hope would be if there were copies of the redo logs on H:  If there are and they cover the span of time between the image that was restored and the current files, then you should be able to recover using the redo logs.

Also, if the image was taken while the database was open, the files you just put back are pretty useless.

You best hope is going to be to rebuild using the datapump export.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sbuttyAuthor Commented:
Thanks I will not loose time to try.
johnsoneSenior Oracle DBACommented:
If you were in archive log mode and had archives, you should be able to do it.  But, without that, you cannot force consistency.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.