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

From: if_investor_at_yahoo.com <basis_consultant_at_hotmail.com>
Date: Tue, 13 Apr 2010 13:21:33 -0700 (PDT)
Message-ID: <bc33eb47-8edf-4549-8e7e-93dfa93f13f3_at_z11g2000yqz.googlegroups.com>

On Apr 13, 3:25 pm, "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,

After some research, my tentative procedure is as follows, though I am not sure if it will work from 32 bit Win2000 to x64 Win2003; My reference
is Metalink Doc 341880.1 (Though it is for Linux).

Will this work?

(i) Copy the datafiles and recreate the control file.
(ii) Alter database open
(iii) Startup upgrade
(iv) Run _at_$ORACLE_HOME/rdbms/admin/utlirp.sql
(v) shutdown immediate;
(vi) Startup upgrade
(vii) Run _at_$ORACLE_HOME/rdbms/admin/utlrp.sql

Thanks,
IF Received on Tue Apr 13 2010 - 15:21:33 CDT