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?
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?
0
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?
0
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

omarfaridCommented:
again please mention how files were copied since it is is important to see how files time stamps were changed.
0
sikyalaSenior Database AdministratorAuthor Commented:
the backup of the files are performed using data protector
0
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.
0
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?
0
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.
0
sikyalaSenior Database AdministratorAuthor Commented:
ok so what commands would I try
0
slightwv (䄆 Netminder) Commented:
set your ORACLE_SID like you normally would.

then:  sqlplus / as sysdba
SQL> recover database;
0

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.