OraFAQ Forum: Backup & Recovery » Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit

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 )

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

Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit [message #501646]

Wed, 30 March 2011 07:18

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

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Export/create database/import

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure when changing the word length you can restore?

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN from Feb 28th
Next Topic:	Managing partition table please help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 07:28:29 CST 2024