Re: Movement from NON-ASM Database to ASM-RAC Database .. Basic Qs

From: Ravi Madabhushanam <ravi.madabhushanam_at_gmail.com>
Date: Mon, 6 Aug 2007 16:17:41 +0530
Message-ID: <f2f282d10708060347k4dfd3e0br6a106ade1913cfa@mail.gmail.com>

Hi Vivek,

My views might as best as the previous one, but few thoughts, you might want to consider..

 Seperate your entire task into two. (a) from FS based to ASM (b) NOn-RAC to RAC.. To convert from FS based to ASM instance, all you need is a disk array which can be shared with on nodes. If you setup up your disk group/arry in such a way that it is shared without any problems, your second task will be easy.

First estimate your down time, assuming you have sufficient down time, (a). Setup an ASM instance with all the diskgroups.. Preferably use a seperate ORACLE_HOME for ASM( as sugested by ORACLE).

(b). take a backup of your datafiles ( backup as copy) onto the ASM disks.
(c) switch all the datafiles.
(d) Add the log/temp files on the ASM..

  and its done.

Second task will be just converting a single node instance to 2 node RAC.

add anew node , which can have access to the DB i.e., ASM disks. Bring up the ASm instance in cluster mode as well.. then bring the new DB instance..

Ofcourse it is not as simple as the above statements, but its lot simpler than many other things..

Regards,
Ravi.M

On 8/6/07, LS Cheng <exriscer_at_gmail.com> wrote:
>
> have a look here
>
>
> http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gASMMigration.pdf
>
> thanks
>
> --
> LSC
>
> On 8/6/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
> >
> > Folks
> >
> >
> >
> > Data from a NON-RAC Database existing in version 10.2.0.2 needs to be
> > moved to an ASM-RAC Database on the Same Machine. ORACLE_HOME of ASM RAC
> > setup is 10.2.0.3
> >
> >
> >
> > NOTE - NON-RAC Database exists on a Mounted Filesystem.
> >
> > O.S. Solaris 10
> >
> >
> >
> > Qs 1 Should the NON-RAC Database be 1st Brought up using the ASM-RAC
> > ORACLE_HOME, Upgraded using ASM-RAC ORACLE_HOME/rdbms/admin/*
> > catupgrd.sql* thereafter the Data Transfer be initiated?
> >
> >
> >
> > Qs 2 Any Docs, Links to move the Data from NON-ASM to ASM RAC Database?
> > Is the following Link Sufficient?
> >
> >
> > http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmasm001.htm
> >
> >
> >
> >
> >
> > Qs 3 Can the NON-RAC & RAC Databases *Co-Exist* on the SAME Machine with
> > Different ORACLE_SIDs After Data Transfer from NON-RAC Database to ASM-RAC
> > DB?
> >
> >
> >
> > Cheers & Thanks
> >
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 06 2007 - 05:47:41 CDT