Home » RDBMS Server » Backup & Recovery » Restore to a different server - different versions? (Oracle 10.2.4, Solaris 5.10)
Restore to a different server - different versions? [message #386735] Mon, 16 February 2009 21:35 Go to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
Hi, I am testing one of the recovery scenarios whereby I am trying to restore database to a different server. Here are my variables:

1. We take hot backups via RMAN
2. We use RMAN catalog
3. Oracle version between db where the backup was taken is
different (10.2.4) from the version where I am trying to
restore this backup (10.2.3).
4. Every hot backup includes archivelogs, spfile and
controlfile backup
5. I will be using nocatalog during thie restore.

I have two questions:

a) Can I restore to a different server is the versions of Oracle are different - 10.2.4 and 10.2.3?

b) Can anyone point me to some clear documentation that describes how to restore to a different server from hotbakup?

thank you!
Re: Restore to a different server - different versions? [message #386739 is a reply to message #386735] Mon, 16 February 2009 22:01 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>a) Can I restore to a different server is the versions of Oracle are different - 10.2.4 and 10.2.3?
no
>b) Can anyone point me to some clear documentation that describes how to restore to a different server from hotbakup?

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm

How would RMAN know whether it is same or different server & why would it care?

Re: Restore to a different server - different versions? [message #386740 is a reply to message #386739] Mon, 16 February 2009 22:11 Go to previous messageGo to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
For one thing datafiles are located in different directories on this other server. Docs are confusing - I am not sure if I am supposed to follow docs that describe cloning db to another server or restoring (where you import your RMAN catalog, etc). I am trying to simulate disaster recovery scenario where my database server is not available and I got RMAN hot backup + archivelogs + spfile + controlfile with that backup. So I want to restore it to another server. What makes sense in this situation?

Thank you!


p.s but if the versions are different, I cannot restore period?
Re: Restore to a different server - different versions? [message #386990 is a reply to message #386740] Tue, 17 February 2009 08:48 Go to previous messageGo to next message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member
lotusdeva wrote on Tue, 17 February 2009 04:11
p.s but if the versions are different, I cannot restore period?


Yes and no.

Chances are that it will work - but the question is "would you really do this" in a real disaster?

You should have the correct versions of Oracle installed on your failover nodes - there really arnt any excuses.
Re: Restore to a different server - different versions? [message #386997 is a reply to message #386990] Tue, 17 February 2009 09:27 Go to previous messageGo to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
Well, we have over 100 databases, some run 10.2.3, some 10.2.4 some are still on 9i. I only have one "failover" test server with 10.2.4. on it..
Re: Restore to a different server - different versions? [message #386998 is a reply to message #386735] Tue, 17 February 2009 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
What is reality for you?
>I only have one "failover" test server with 10.2.4. on it..
>3. Oracle version between db where the backup was taken is different (10.2.4) from the version where I am trying to restore this backup (10.2.3).

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Do NOT describe. use CUT & PASTE to show exactly what you have & do
Re: Restore to a different server - different versions? [message #387001 is a reply to message #386998] Tue, 17 February 2009 09:50 Go to previous messageGo to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
I have not restored to a different server yet. This is the first time I am trying to do it. I am just trying to figure out the best way to go about this and follow recommended guidelines.
Re: Restore to a different server - different versions? [message #387016 is a reply to message #386735] Tue, 17 February 2009 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
On your test system, you can/should have multiple ORACLE_HOME directories; one for each version that exists in Production.

If so, then you could restore any Production DB onto the test system.
Re: Restore to a different server - different versions? [message #387019 is a reply to message #387016] Tue, 17 February 2009 10:38 Go to previous message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
exactly! that makes sense! thank you!
Previous Topic: Which archive files are needed.
Next Topic: Disaster Recovery Scenario (merged)
Goto Forum:
  


Current Time: Wed Dec 07 16:26:18 CST 2016

Total time taken to generate the page: 0.06043 seconds