Re: DB move
Date: Sat, 12 Feb 2011 14:12:14 -0600
Message-ID: <AANLkTikQd+uzHJLMt+SdE_Un7tX-QFRVb5Jpj6MksAK+_at_mail.gmail.com>
Thanks to all. Do the patchset levels have to be the same too? We are trying to move from 10.202 to 10.204. Will it work with TDB? No mention about that in the documents or metalink that I can see.
On Wed, Feb 9, 2011 at 7:40 PM, Oscar Ofiana <oj.ofiana_at_gmail.com> wrote:
> Hi Ram,
>
> It can actually be done in one step. Assuming that you are still migrating
> from the same versions of Oracle on each server, you can use still use
> Convert Database.
>
> You can use the Convert Database command to generate conversion scripts on
> the source target database (while it's in read only), then transfer the
> datafiles to the HP server. Modify the generated scripts to convert the
> datafiles into an ASM location, and then run in RMAN on the target server.
>
> For example, your conversion scripts would look something like this:
>
> RUN {
> CONVERT DATAFILE '/u01/oradata/users01.dbf'
> FROM PLATFORM 'AIX-Based Systems (64-bit)'
> FORMAT '+DATA';
>
> ....
>
> If you have access to Metalink, Doc 414878.1 has the full steps on how to
> do this.
>
> Hope this helps,
> OJ
>
>
> On Thu, Feb 10, 2011 at 6:42 AM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
>>
>> We are in the process of moving an Oracle DB 10g from AIX to HP. Old DB is
>> in non ASM, while the new one will be in ASM. I found this<http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDHCIDA>and
>> this<http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmasm.htm#BABJAFIF>related to moving the DB using Transportable DB and moving files from non
>> ASM to ASM. It looks like it is not possible to directly move from non ASM
>> to ASM from one platform to other in one step. Does it have to be a 2 step
>> process of moving into non ASM in the new hardware and then
>> converting/moving that to ASM?
>>
>> Thanks.
>>
>>
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 12 2011 - 14:12:14 CST