Re: Copying Backup of 32-bit Win2000 10g Database into a 64 Bit Win2003 Server
Date: Tue, 13 Apr 2010 13:21:33 -0700 (PDT)
On Apr 13, 3:25 pm, "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?
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
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
IF Received on Tue Apr 13 2010 - 15:21:33 CDT