how do i restore a database to a new server

the database files and binaries were copied from one server to another and when i try to start up the database on the new server i get an error that a datafile is newer than the info on the controlfile. When i try to query the datafiles it returns no results. All the files were copied to the identical file structure from the former database server. what do I need to do in order to restore the database on the new server
sikyalaSenior Database AdministratorAsked:
Who is Participating?

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

x
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.

omarfaridCommented:
How the copy was done?
slightwv (䄆 Netminder) Commented:
>>the database files and binaries were copied from one server to another

Did you copy the original control files, init/spfile file, etc...?

Are you trying to change the databsae name as well?
sikyalaSenior Database AdministratorAuthor Commented:
not trying to change database name. yes the original control files were copied and spfile. a bare metal filesystem was used to restore database server onto a new server.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

omarfaridCommented:
again please mention how files were copied since it is is important to see how files time stamps were changed.
sikyalaSenior Database AdministratorAuthor Commented:
the backup of the files are performed using data protector
slightwv (䄆 Netminder) Commented:
>>see how files time stamps were changed.

I do not believe Oracle bases that error on timestamps of files.  It uses the SCN that is in the header of each file.

>>yes the original control files were copied and spfile

My unix days are behind me but I cannot remember doing anything special to clone a database in this manner.

The only thing I can think of is you did a live copy of the files.  You cannot copy Oracle files 'live'.  They Either need to be in backup mode or a cold backup.
sikyalaSenior Database AdministratorAuthor Commented:
if the database was live during the backup is there a way to restore it on the new machine or is restore impossible?
slightwv (䄆 Netminder) Commented:
If you did not put the database in backup mode it will just be dumb luck.  What you have is a 'fuzzy' backup.

You can try a recovery on the new system before you jump right into opening the database.  You might get lucky but it will be just that, luck.
sikyalaSenior Database AdministratorAuthor Commented:
ok so what commands would I try
slightwv (䄆 Netminder) Commented:
set your ORACLE_SID like you normally would.

then:  sqlplus / as sysdba
SQL> recover database;

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
sikyalaSenior Database AdministratorAuthor Commented:
ok thanks
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.