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

From: sandeep pande <>
Date: Thu, 13 May 2010 07:50:01 -0700 (PDT)
Message-ID: <>

On Apr 14, 12:25 am, "" <> wrote:
> Hi,
> We have a cold backup of a 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  installed on x64
> Win2003.
> Can this be done? If so, is the procedure documented anywhere?
> Thanks,
> IF

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
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:-

I have however, done steps 1-7 & it all worked fine for me.

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

Original text of this message