My current environment is listed below.
OS - Windows Server 2003 R2 STD 64 bit
DB - Oracle 11g R1 126.96.36.199 64 bit
Storage - Non-ASM
I wanted to upgrade the Hardware, OS and DB to the latest. Also i wanted to use ASM for the new database. so my target environment will have the below configuration.
Hardware - New server with high capacity
OS - Windows Server 2008 R2 ENT 64 bit
DB - Oracle 11g R2 188.8.131.52 64 bit
Storage - ASM
I checked the Oracle Database 11gR2 Upgrade Companion doc but could not find any case matching my requirement. Any advice/help with the steps for this kind of DB migration will be very useful.
What is the size of your database?
I recommend you the following actions:
1) Install 11gr2 Software
2) create & Configure ASM Disk group
3) Create database
4) Perform full export from the 11gR1 database
5) Import full database in 11gr2
Hope this helps :)
X A H E E R
In your scenario DB upgrade, platform change and storage move to ASM are involved.
Better first start with DB upgrade to 184.108.40.206.
220.127.116.11 is supported on Windows server 2003 R2
To know upgrade steps, refer Note 837570.1 Complete Checklist for Manual Upgrades to 11gR2 Note 870814.1 Complete checklist to upgrade the database to 11gR2 using DBUA
Once upgrade is completed, you can move DB to ASM file system in windows 2008 R2
Steps are mentioned in
Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa (Doc ID 252219.1)
Since DB is upgrade to 18.104.22.168, we can utilize new features to upgrade to 11gR2
I kinda agree with 'Simon DBA': split the hardware upgrade from the transition to ASM.
If it was me, I'd install 22.214.171.124 on the new server, and simply copy the database across.
Then, once that was working well, I'd upgrade to 126.96.36.199.
Then, once that had been tested to be working, I'd use RMAN to duplicate the database into new ASM storage.
Otherwise, there are too many moving parts. I'd certainly want to test and evaluate each one before moving on. (But maybe I'm just cowardly).
My DB size is around 500GB.
I agree Export/import or datapump is an option. Since there are many inter dependencies between the DB schemas i fear the import will fail or complete with inconsistencies. Also resolution of these errors will be a mammoth exercise.
yes RMAN can be used. Since i am migrating the database all together to the new hardware and new OS (win2008) i think out-of-place upgrade cannot be considered. I believe out of place upgrade should be done in the same environment without changing the hardware or OS.
The steps given by you fits if i wanted to upgrade the DB to 188.8.131.52 and move the Database from Non-ASM to ASM in the same server environment.
In my case i wanted to migrate the database to the new hardware, new OS, new DB version with ASM.
Hi Catfive Lander ,
When you say "I'd install 184.108.40.206 on the new server" you mean 220.127.116.11 on windows 2003 or windows 2008 OS ?
To sum up i am expecting a migration procedure like the one below. But not sure whether this is possible.
1. Install 2008 OS in the new server.
2. Install 18.104.22.168 GI & Oracle RDBMS binaries and patches.
3. Take a cold backup of the source 22.214.171.124 DB using RMAN or Manual method.
4. Restore in the 126.96.36.199 DB. (But dont open the DB)
5. Upgrade the DB using DBUA.
6. Move the Database from Non-ASM to ASM
7. Test and evaluate the DB.
There's no need to have steps 4 and 6 separate. When you do the RMAN restore in step 4 just restore it into ASM.
Keep in mind that ASM software runs out of it's own home. Seems like you're not RAC so it would be "Standalone Grid Infrastructure". That software should be at the highest release so install the GI home as 188.8.131.52. That will be fine for the 11gR1 database, heck even a 10g database can use a 11gR2 GI home. ASM and your listener will run from the GI home.
And as far as "out-of-place" goes, you're really still on the same OS - it's still Windows. You're not changing Endian which would make things much more complicated.
So you can just take a backup of the old 11.1 database on Win2003, restore that into ASM on Win2008, open it with the 11.2 RDBMS software as "startup upgrade" and then perform the upgrade. You don't actually need to even have the 11.1. software on the Win2008 machine.
Thanks for the migration approach provided. What are the steps required to be completed in the new server before restoring the RMAN backup on win2008 ?
I have completed the below steps in the new server.
1. Install 2008 OS in the new server.
2. Configure storage for ASM in the new server.
3. Install 184.108.40.206 standalone GI & Oracle RDBMS binaries and patches.
But there is no DB instance created so far in the new server. In this case how to map the RMAN backup with the database on the new server?
Also i like to know the steps required to "Restore RMAN backup into ASM on Win2008". I checked the below MOS doc but it seems it does not use RMAN backup.
Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa [ID 252219.1]
Taking RMAN backup from old 11.1 database and Restoring that directly into 11.2 RDBMS software supported by Oracle ? Can you please confirm ? Have you tried this in any real time upgrade environment ?