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  |
trantuananh24hg
Messages: 744
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 #645349 is a reply to message #643560] |
Thu, 03 December 2015 21:25  |
trantuananh24hg
Messages: 744
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 |
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun Dec 22 02:39:21 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
