FAQ
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

CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Search Discussions

  • LS Cheng at Aug 6, 2007 at 9:19 am
    have a look here

    http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gASMMigration.pdf

    thanks

    --
    LSC
    On 8/6/07, VIVEK_SHARMA 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


    **************** CAUTION - Disclaimer *****************
    This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
    solely for the use of the addressee(s). If you are not the intended
    recipient, please notify the sender by e-mail and delete the original
    message. Further, you are not to copy, disclose, or distribute this e-mail
    or its contents to any other person and any such actions are unlawful. This
    e-mail may contain viruses. Infosys has taken every reasonable precaution to
    minimize this risk, but is not liable for any damage you may sustain as a
    result of any virus in this e-mail. You should carry out your own virus
    checks before opening the e-mail or attachment. Infosys reserves the right
    to monitor and review the content of all messages sent to or from this
    e-mail address. Messages sent to or from this e-mail address may be stored
    on the Infosys e-mail system.
    ***INFOSYS******** End of Disclaimer ********INFOSYS***
    --
    http://www.freelists.org/webpage/oracle-l
  • Ravi Madabhushanam at Aug 6, 2007 at 10:47 am
    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, VIVEK_SHARMA 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
  • Ravi Madabhushanam at Aug 6, 2007 at 10:48 am
    i was about to say " might not be as best as the earlier post".. not
    "might as best as the previous "..

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 6, '07 at 7:33a
activeAug 6, '07 at 10:48a
posts4
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase