Home » RDBMS Server » Backup & Recovery » Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit ( 11g Release 11.1.0.7.0 on windows 2003 32 bit, Oracle 11.1.0.7.0 to Windows 2008 server 64 bit )
Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #501646] Wed, 30 March 2011 07:18 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
I want to Transfer Oracle Database 11g Release 11.1.0.7.0 on windows 2003 32 bit server to Windows 2008 server 64 bit
I have Cold RMAN backup.
and directory structure of both server are same
What will be the steps?
Do i need to do anything to change datafile to 64 bit or do i need to apply any change to any object
Re: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #501648 is a reply to message #501646] Wed, 30 March 2011 07:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export/create database/import

Regards
Michel
Re: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #502700 is a reply to message #501648] Fri, 08 April 2011 03:31 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
1. Install Oracle software only.
2. Restore your datafiles to the new server.
3. Recover there by creating new Control file.

Ridhi
Re: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #502701 is a reply to message #502700] Fri, 08 April 2011 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure when changing the word length you can restore?

Regards
Michel
Re: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #502764 is a reply to message #502701] Sat, 09 April 2011 00:57 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I think it will work. Needs to be tested. I will test if i ll get a chance and confirm. Else if somebody can test please post your findings here.

Thanks
Ridhi
Re: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #503444 is a reply to message #502764] Fri, 15 April 2011 11:19 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
Thanks for help

I have restored my database 11.1.0.7.0 backup of windows 2003 32 bit to Windows 2008 64 bit server successfully.

After recovering the database, i got internal errors

I shutdown and do startup upgrade and run utlirp.sql and then
did shutdown immediate and then startup normally

After startup i run utlirp.sql and everything is running fine since then.

I am taking RMAN backup as follows

BACKUP check logical database

and there is no error


[Updated on: Fri, 15 April 2011 11:20]

Report message to a moderator

Re: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #503446 is a reply to message #503444] Fri, 15 April 2011 12:00 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: RMAN from Feb 28th
Next Topic: Managing partition table please help
Goto Forum:
  


Current Time: Thu Mar 28 03:34:24 CDT 2024