Re: Copying Backup of 32-bit Win2000 10g Database into a 64 Bit Win2003 Server
Date: Thu, 13 May 2010 07:50:01 -0700 (PDT)
On Apr 14, 12:25 am, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> We have a cold backup of a 10.2.0.2 database from a 32-bit Windows
> 2000 environment.
> We would like to copy that database into a 10g 64-bit Windows 2003
> We already have the 10g binaries (Also 10.2.0.2) installed on x64
> Can this be done? If so, is the procedure documented anywhere?
We've done a similar move as part of an upgrade from 8i on win2000 (32- bit) to 10gR2 on Win2008 (64-bit)
You would need to do the following :- [assuming file structure on both servers is identical, else recreate controlfile is required] Refer MOS note 403522.1
1. Restore your backup to the 64-bit server. 2. Create Windows services 3. Edit init.ora to increase shared_pool & java_pool. Both should bedoubled.
4. Start the database in UPGRADE mode. This is required to convert the database to 64-bit
5. Run conversion script (utlip.sql) 6. Shutdown & startup normal. 7. Run compile script (utlrp.sql)
I also found the following documentation that claims the conversion will be automatic if the database version is not changing:- http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/intro.htm#i1008703
I have however, done steps 1-7 & it all worked fine for me.
Sandy Received on Thu May 13 2010 - 09:50:01 CDT