Upgrade and migrate options
Date: Fri, 26 Jun 2009 11:17:51 +1200
Message-ID: <4a38d9060906251617q4467a7a1m22f4d1d3a4c339b2_at_mail.gmail.com>
Hi Folks,
Environment, VM guests:
Source
Oracle: *10.2.0.4* with APEX 3.2 using Embedded PL/SQL Gateway (EPG). No
ASM, no RAC
32-bit OS: Suse Linux 10.1 2.6.16.13-4-default i686 i686 i386 GNU/Linux
Target
Oracle: *11.1.0.6* - installed - nothing else 32-bit OS: openSuse 11.1 2.6.27.7-9-default SMP i686 i686 i386 GNU/Linux
Goal:
Get the database that's running on source, running on target. Its only small (~500M) and there are no downtime issues as this is a sandpit environment and the exercise purely for training.
I have a couple of ideas for the "best" way to go with this:
Exp/imp (traditional or datapump):
- Build empty database on target
- [on target] exp or expdb from source (full = y)
- copy exp to target (not req'd if exp done on target)
- imp full=y
- run upgrade scripts or DBUA
- configure EPG
This seems the simplest approach (I have seen the recent discussion full=y vs separate schemas)
Use RMAN
Not sure about this one.
- on source "backup copy copy of database" 1a - hypothetical) IF in production then stop app
- copy to target inc archive redo, controlfiles, pfile
- on target: set SID and recover database
- run upgrade scripts or DBUA
- configure EPG
Pros:
- dont have to pre-create empty database on target
- possibly quicker than imp / exp (not an issue right now, but always worth investigating for real-world scenarios)
What are you're thoughts list?
Regards
Tony
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 25 2009 - 18:17:51 CDT