Migration to cluster
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Migration to cluster

  1. #1
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Migration to cluster

    I have a Oracle 9i with storage, an instance only, to transform into cluster, two clusters, he is possible to only migrar, or I must reinstall? exists documentation?
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Do you mean migrating a Ora9i single instance into a two nodes Ora10g RAC?

    Sure you can.

    Can you afford some down time? how big is your database?

    Having your data sitting in an external storage subsystem you can either upgrade it in place or migrate it.

    My personal preference? migrate it. This way you are gonna have both your 9i and 10g versions alive all the time.

    If you decide to pursue the migration path...

    1) Setup your 10g RAC environment
    2) Pre create your database
    3) Move data from 9i to 10g by exporting/importing it.
    4) Voila!

    Documentation? tons of it. Just google it.
    Last edited by PAVB; 05-28-2007 at 11:12 AM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    i not can migrate to 10g, only migrate to cluster.
    i have one server and grow to two servers on cluster.
    my first installation is not to cluster, as to make ?
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I see...

    What kind of "cluster" are we talking about here?

    Are you referring to RAC or are you referring to an Active/Passive cluster?

    Assuming you are talking about RAC, please check http://download-east.oracle.com/docs...00/migrate.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Lightbulb

    Thanks.
    he was this that I needed.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Não seja por isso. Bom trabalho.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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