RE: Database migration between Windows Servers via. copying files
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: "'giantpanda@xxxxxxx'" <giantpanda@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Oct 2010 09:57:43 -0400
Not sure about the OS changes - what impact they'll have. However, we've done a
very similar procedure for moving from 32-bit 2003 to 64-bit 2003.
One word of warning - OLAP is bit-sensitive, so if you have OLAP, you'll need
to drop and recreate it.
stephan
_____________________________________________________________________________
Stephan Uzzell | MICROS Systems, Inc.
Database Administrator - OPERA Global Technical Services
7031 Columbia Gateway Dr, Columbia, MD 21046 | 7 443.285.8000x2760 |
443.285.6505
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ingrid Voigt
Sent: Tuesday, 05 October, 2010 09:52
To: oracle-l@xxxxxxxxxxxxx
Subject: Database migration between Windows Servers via. copying files
Hi,
we urgently need a working procedure to move a database between two
servers. Usually we do this via exp/imp, but it throws a lot of
errors in this case.
Here is what we came up with. It seems to work in a test environment,
but feels fishy (too easy).
Before doing this in production I'd like to hear your opinion...
Old server: Windows 2003, 32 Bit, Oracle 10.2.0.4, Patchset 30
New server: Windows 2008, 64 Bit, Oracle 10.2.0.4, Patchset 38
Directory structure is different.
Old server:
Backup controlfile to trace
(simplifies the moving of datafiles)
Create pfile from spfile
Shutdown immediate
Move:
Create new directories
Copy all datafiles, redo logs, pfile, and the trace file to new place
New Server:
Oradim -new
Change parameter control_files, %dest in pfile
Startup nomount
Change all datafile and redolog locations in trace file
Create new controlfile
Alter database open
Create new temp tablespace
Cleanup:
@utlirp to get from 32 to 64 Bit
@utlrp
@catcpu, @view_recompile, @utlrp to apply the new patchset
Create spfile from pfile
Restart new database
What do you think... are we going to drown in errors in a few weeks or will
this really work even for non-identical OS versions?
Best regards
Ingrid Voigt
--
Neu: GMX De-Mail - Einfach wie E-Mail, sicher wie ein Brief!
Jetzt De-Mail-Adresse reservieren: http://portal.gmx.net/de/go/demail
--
//www.freelists.org/webpage/oracle-l
Other related posts:
