Solved

how do i restore a database to a new server

Posted on 2012-03-21
11
375 Views
Last Modified: 2012-03-22
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
0
Comment
Question by:sikyala
  • 5
  • 4
  • 2
11 Comments
 
LVL 40

Expert Comment

by:omarfarid
ID: 37748130
How the copy was done?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37748135
>>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
 

Author Comment

by:sikyala
ID: 37748191
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 40

Expert Comment

by:omarfarid
ID: 37748249
again please mention how files were copied since it is is important to see how files time stamps were changed.
0
 

Author Comment

by:sikyala
ID: 37748389
the backup of the files are performed using data protector
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 37748420
>>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
 

Author Comment

by:sikyala
ID: 37748476
if the database was live during the backup is there a way to restore it on the new machine or is restore impossible?
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 37748488
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
 

Author Comment

by:sikyala
ID: 37748496
ok so what commands would I try
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37748884
set your ORACLE_SID like you normally would.

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

Author Comment

by:sikyala
ID: 37754034
ok thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question