Re: Copying Backup of 32-bit Win2000 10g Database into a 64 Bit Win2003 Server

From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Thu, 13 May 2010 07:50:01 -0700 (PDT)
Message-ID: <0b49da2e-1a65-4320-b19c-5294688c9b86_at_n37g2000prc.googlegroups.com>



On Apr 14, 12:25 am, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> 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
> environment.
> We already have the 10g binaries (Also 10.2.0.2)  installed on x64
> Win2003.
>
> Can this be done? If so, is the procedure documented anywhere?
>
> Thanks,
> IF

Hi,
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 be
doubled.
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.

Regards
Sandy Received on Thu May 13 2010 - 09:50:01 CDT

Original text of this message