Solved

how do i restore a database to a new server

Posted on 2012-03-21
11
371 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
 
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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.

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now