Re: RMAN restore to lower point release/different OS?
Date: Fri, 13 Feb 2009 23:43:59 +1100
Message-ID: <gn3pld$3g5$1_at_reader.motzarella.org>
Malcolm Dunnett wrote,on my timestamp of 13/02/2009 9:50 AM:
>
> One of the wrinkles is that the VMS server is currently running Oracle
> 10.2.0.2 (Oracle hasn't yet released 10.2.0.4 for VMS).
Ay!...
> principle there shouldn't be an issue moving the files. I know that
> Oracle supports moving database files between VMS on Alpha and VMS on
> Itanium (I've successfully done that numerous times) but I'm not sure if
> the database running on Linux on Itanium makes a difference.
Could well be more than that. I do recall the upgrade from 10.2.0.2 to 10.2.0.3 is not just a code patch: there is a final step that upgrades the dictionary, with heaps of changes. You're potentially looking at major dictionary changes between 0.4 and 0.2. Might work if your VMS was 0.3?
Still: worth having a chat with the support folks. Or investigate the use of transportable tablespaces? Received on Fri Feb 13 2009 - 06:43:59 CST