OraFAQ Forum: Backup & Recovery » Restore to a different server

Home » RDBMS Server » Backup & Recovery » Restore to a different server - different versions? (Oracle 10.2.4, Solaris 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore to a different server - different versions? [message #386735]

Mon, 16 February 2009 21:35

lotusdeva
Messages: 201
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!

Report message to a moderator

Re: Restore to a different server - different versions? [message #386739 is a reply to message #386735]

Mon, 16 February 2009 22:01

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Restore to a different server - different versions? [message #386740 is a reply to message #386739]

Mon, 16 February 2009 22:11

lotusdeva
Messages: 201
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?

Report message to a moderator

Re: Restore to a different server - different versions? [message #386990 is a reply to message #386740]

Tue, 17 February 2009 08:48

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.

Report message to a moderator

Re: Restore to a different server - different versions? [message #386997 is a reply to message #386990]

Tue, 17 February 2009 09:27

lotusdeva
Messages: 201
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..

Report message to a moderator

Re: Restore to a different server - different versions? [message #386998 is a reply to message #386735]

Tue, 17 February 2009 09:35

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Restore to a different server - different versions? [message #387001 is a reply to message #386998]

Tue, 17 February 2009 09:50

lotusdeva
Messages: 201
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.

Report message to a moderator

Re: Restore to a different server - different versions? [message #387016 is a reply to message #386735]

Tue, 17 February 2009 10:32

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Restore to a different server - different versions? [message #387019 is a reply to message #387016]

Tue, 17 February 2009 10:38

lotusdeva
Messages: 201
Registered: March 2005

Senior Member

exactly! that makes sense! thank you!

Report message to a moderator

Previous Topic:	Which archive files are needed.
Next Topic:	Disaster Recovery Scenario (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 04:30:32 CDT 2024