Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Migrating to ASM on new hardware via RMAN

Re: Migrating to ASM on new hardware via RMAN

From: Don Seiler <don_at_seiler.us>
Date: Fri, 23 Feb 2007 22:59:57 -0600
Message-ID: <716f7a630702232059v7559105cqd69106b07efac1b0@mail.gmail.com>


Well this other section of the same Oracle book pretty much provides an example of what I hope to do:

"RMAN DUPLICATE DATABASE From File System to ASM: Example" http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb006.htm#sthref1306

On 2/23/07, Don Seiler <don_at_seiler.us> wrote:
> Slightly related to my previous post, but I thought it deserved its own thread.
>
> To recap, I'm migrating my 10g (10.2.0.2) instance from a 32-bit
> machine to a shiny new 64-bit monster, obviously doing this on test
> instances first. We currently use non-ASM storage on linux
> filesystems. As part of the migration, we wanted to make the change
> to ASM. I had been reading an Oracle HOWTO [1] but it seems to
> address migrating from non-ASM to ASM on the same instance on the same
> box.
>
> I'm wondering if it is feasible to use RMAN to duplicate the current
> production instance onto my 64-bit machine using the DUPLICATE
> DATABASE command, and using db_file_name_convert and
> log_file_name_convert to specify the ASM disk group as the new
> destination.
>
> My alternative method is to create a brand new 64-bit instance and use
> datapump to move the application schemas over. I'd still have to
> create all of the users/roles though and set privileges again, but I
> have some scripts to create those statements (from previous HP-UX ->
> Linux migration).
>
>
> [1] http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmasm.htm#i1016581
>
> --
> Don Seiler
> http://seilerwerks.blogspot.com
>

-- 
Don Seiler
http://seilerwerks.blogspot.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 23 2007 - 22:59:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US