Home » RDBMS Server » Backup & Recovery » Restore and migration from Windows32bit to Linux64bit (Oracle 10g and 11g)
Restore and migration from Windows32bit to Linux64bit [message #643556] Mon, 12 October 2015 02:32 Go to next message
trantuananh24hg
Messages: 724
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi,

I have a case, will build test before doing in production.

My source database: Portal DB, 10.1.0.5
My target database: Empty

The source database is running in Windows 32bit, and target database have been being configured in Linux x86_64, all of target and source are Little Endian (Intel AMD).

First time, DataPump and Transpor tablespace methods are invoked, successfully but wrong sequential of number tables because of Portal's sequencies generation.

The second time was same situation with Transport Tablespace.

Then, I decided to restore and migration doing by RMAN. However, I have got something:

- From 10.1.0.5, it can not upgrade to 11.2.0.4 directly, so that, I much upgrade the target database into 10.2.0.4 at least. The patchset is not supported right now from Oracle Support. I can not download from anywhere.
- Even upgrade target database to 10.2.0.4, these below steps are right?
+ Backup full target database
+ Restore in source
+ Migration to Linux using RMAN convert
+ Recover database, upgrade to 11.2.0.4 and post scripts.

This is the first time got a case like that, may you guide me more?

Thank you very much!
Re: Restore and migration from Windows32bit to Linux64bit [message #643557 is a reply to message #643556] Mon, 12 October 2015 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can get the patchset from Oracle opening a SR.

Re: Restore and migration from Windows32bit to Linux64bit [message #643558 is a reply to message #643557] Mon, 12 October 2015 02:40 Go to previous messageGo to next message
trantuananh24hg
Messages: 724
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel.

I already suggest the patchset from SR opened 2 days ago. Hope got them as soon as possible.
Then, please comments in my steps which using RMAN.
Re: Restore and migration from Windows32bit to Linux64bit [message #643559 is a reply to message #643558] Mon, 12 October 2015 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Your steps seem correct but you have to test them anyway to see if they work.

Re: Restore and migration from Windows32bit to Linux64bit [message #643560 is a reply to message #643559] Mon, 12 October 2015 02:54 Go to previous messageGo to next message
trantuananh24hg
Messages: 724
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you very much, Michel.

I must build a test lab before doing the real in production.

Thanks again
Re: Restore and migration from Windows32bit to Linux64bit [message #645349 is a reply to message #643560] Thu, 03 December 2015 21:25 Go to previous messageGo to next message
trantuananh24hg
Messages: 724
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Michel, I have done the test lab.

It was almost same to those above steps, but a little more doing among them.

I. Restore/recover Portal Database from Windows 32bit to Windows 64bit
1- Backup full Portal source Database.
2- Installation, configuration Oracle Enterprise 10.2.0.4, update patchset 10.2.0.5 on the new host Windows 2003, server, 64bit.
3- Cloning the Portal Database using RMAN, migrate datafile system-file to ASM
4- Upgrade 32bit to 64bit
5- Re-configuration and deploying the Portal App
6- Important: Changing the Java word size from 32bit to 64bit in Portal App.

II. Migration from Oracle 10gr2, Windows 64bit to Linux x86_64, 11gr2
1- Building the new Linux RHEL5,6 (CentOS 5,6), in my case, I used RHEL5 because of validation licsence until 2017.
2- Installation, configuration Oracle 11gr2, update patchset 11.2.0.4.
3- Configuration the DataGuard on Linux RHEL5, it was the Physical Standby to Windows 64bit (Oracle 10gr2 was the Primary).
4- Temporarily disconnect the App to Primary Database (Windows x64bit), have done failover to Linux 11gr2.
5- Upgrade to 11gr2.

Note:

- Paid contention to ASM Instance in Windows. I had got the error when reboot the Windows Server, ASM did not discover any diskgroup, lost asm_string, asmlg did not meet the
partition which was configured to diskgroup ORCL:.
+ The solution: Enable automount. In "diskpart", choose the disk contains the partition, raised to partition listed and enter "Automount Enable". Reboot the server.

- The dispatcher in Portal Database was rather different to normal, example: PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer). If using the DNS, re-configuration to match the name-server in there. I tried to verify with hostname, but could not. Depend to your network and PRE.
- During the Failover, I had got error when displaying the Portal App in website, in which, some contents did not meet the url, I thought it might be the extents sequential. So, when doover again, disconnect any Application to do successfull.

Thank you!
All of tasks have been done in test-lab.

[Updated on: Thu, 03 December 2015 21:26]

Report message to a moderator

Re: Restore and migration from Windows32bit to Linux64bit [message #645351 is a reply to message #645349] Fri, 04 December 2015 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thank you very much for this very detailed feedback.

Re: Restore and migration from Windows32bit to Linux64bit [message #646621 is a reply to message #645351] Tue, 05 January 2016 13:14 Go to previous message
johnsid
Messages: 3
Registered: January 2016
Location: India
Junior Member
Thanks Michel
Previous Topic: EMC networker for Oracle Rman recovery
Next Topic: Is there a way to compress an existing uncompressed backupset
Goto Forum:
  


Current Time: Tue Oct 23 11:16:04 CDT 2018