DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: RAC Upgrade steps

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    RAC Upgrade steps

    Hi,

    We are in the process of migration / upgradation. Below are the steps, i am planning to follow. Can pls somebody correct me if i am missing something ??

    Thx.
    -------


    Source:

    2 Node RAC (production)
    Cluster: 10g R1 CRS
    DB: 10.1.0.4
    OracleHome
    File system: HP unix FS
    Storage Data FileSystem: Rawfiles.

    Requirement is to convert the Above Source into the below Target configuration
    ------------------------------------------------------------------------------------------------------------------
    Target:

    2 Node RAC
    Cluster: 10g R2 CRS ( To be upgraded from R1)
    DB: 10.2.0.3 (To be upgraded from 10.1.0.4)

    OracleHome
    File system: HP Unix FS
    Data FileSystem: Veritas File System. ( Existing in source is RAW file system)


    STEPS we are planning to follow:
    --------------------------------
    1.Shutdown the Source (production) and take cold backup of datafiles and Oracle home.
    2. Copy the Raw files from source to target using dd command.
    (The target has veritas FS)
    To do this we are using dd command.

    3. Copy Oracle Home from Source to Target. (Single Node)

    4. Recreate Controlfile and bring up the single Node on Veritas File system

    5. Ensure everything is working Fine.

    Steps to upgrade.
    --------------------------------
    8. Upgrade DB from 10.1.0.4 To 10.2.0.1 and apply patchset 10.2.0.3.

    10. Install 10.2.0.1 CRS on 2 nodes for RAC.

    11. Upgrade 10.2.0.1 to 10.2.0.3 by applying patchset.

    12. Convert Single node RAC to Dual node RAC (either using rconfig or DBCA )
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    how do you steps match up against the upgrade guide supplied by oracle?

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You need to first upgrade the oracle clusterware to 10.2 or reinstall it and then follow all the steps outlined by you.

    Davey do you have a oracle supplied guide for doing this ?

    regards
    Hrishy

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    How about

    Take a backup of the whole database
    Install 10.2.0.1 CRS on 2 nodes for RAC
    Startup the 10.1.0.4 RAC with 10.2.0.1 CRS
    Install a New Oracle home for 10.2.0.1
    Shutdown the 10.1.0.4 RAC Database
    Use DBUA to upgrade the database to 10.2.0.1
    Bring up the RAC and check everything
    Shutdown the Database and instances
    Use RMAN (you can also switch the database to copies etc) or DD the datafile to VXFS filesystem
    Recreate the controlfile
    restart the database

    Note i have not done a upgrade from 10.1 to 10.2 RAC but i guess the key is getting the 10.2.0.1 CRS up and running right others all should be normal steps.

    Wundering did you check with oracle support guys on this i am curious

    I am curious why you went up the route of conveting to single instance and then back to a clustered instance ?

    regards
    Hrishy

  5. #5
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Dear All,

    1. Backup the database.
    1a. Export the entire database.
    2. Install the new CRS 10.2.0.1.0 and upgrade it to 10.2.0.3.0.
    3. Create database using dbca which will be of version 10.2.0.3.0.
    4. Import the full database.

  6. #6
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Dear All,

    Missed one step

    1. Backup the database.
    1a. Export the entire database.
    2. Install the new CRS 10.2.0.1.0.
    2a. Install Database software 10.2.0.1.0 and patch it 10.2.0.3.0 and upgrade crs IF NEEDED.
    3. Create database using dbca which will be of version 10.2.0.3.0.
    4. Import the full database.

  7. #7
    Join Date
    Sep 2002
    Posts
    376
    Quote Originally Posted by pareshjavkar
    Dear All,

    Missed one step

    1. Backup the database.
    1a. Export the entire database.
    2. Install the new CRS 10.2.0.1.0.
    2a. Install Database software 10.2.0.1.0 and patch it 10.2.0.3.0 and upgrade crs IF NEEDED.
    3. Create database using dbca which will be of version 10.2.0.3.0.
    4. Import the full database.

    It is 500gb db. It would take long time for Export / Import.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  8. #8
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    You can use expdp and impdp

  9. #9
    Join Date
    Nov 2006
    Posts
    158
    What storage system are u anticipating for ur new 10.2.0.3 RAC database?

  10. #10
    Join Date
    Nov 2006
    Posts
    158
    For a std upgrade from 10.1 to 10.2, shut down the CRS stack on all nodes, & unlock the CRS home using the script [B]mountpoint/clusterware/upgrade/preupdate.sh. When u run OUI & select the option to install Oracle Clusterware on a subset of nodes, OUI installs Oracle 10.2 clusterware into the existing CRS home on the local & remote node subset.
    When all member nodes of the cluster are running clusterware 10.2, then the new clusterware becomes the active version.
    You can now upgrade ur db from 10.1 to 10.2. If u're planning to use ASM for storage, then i'll suggest u install & patch the ASM from 10.2.0.1 to 10.2.0.3 & do the same for the oracle software separately. I found it easier trouble shooting separate ASM/software installs than first laying down the software & using dbca to create an ASM instance.

    Good luck...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width