6 Replies Latest reply: May 27, 2013 8:48 PM by SAML. RSS

    Migration to RAC

    Jackie.KH
      Dear All,

      Can you tell me the step to migration data from single instance to rac environment?

      hope to see your answer
      thx
        • 1. Re: Migration to RAC
          FreddieEssex
          Here you go:

          http://docs.oracle.com/cd/B28359_01/install.111/b28264/cvrt2rac.htm

          You didn't mention a version, but you have a few options including dbca.
          • 2. Re: Migration to RAC
            rarain
            Hi,

            Please answer the following question:-

            1) Cluster and Database binaries version?

            2) Is single instance and cluster database binaries version are same or different?

            3) Is your database running on different server or running on one of RAC node server?

            Thanks
            • 3. Re: Migration to RAC
              Jackie.KH
              hi rarain,

              1.) it's binary.
              2.) the same version.
              3.) different server.

              hope to see your detail step

              thanks
              • 4. Re: Migration to RAC
                user12288492
                Please refer to the following link which demonstrates migration of a RAC database from one cluster to another.
                You can follow the same steps even for migrating a single instance database to a RAC environment.
                http://oracleinaction.blogspot.in/2013/02/MIGRATERACDB.html

                Hope it helps.

                Regards
                • 5. Re: Migration to RAC
                  rarain
                  Hi,

                  Better to follow the docs as suggested. In this doc DBCA is used to convert database from single instance to cluster database. I just summarize the steps mention in the docs which will help you probably while reading the docs.

                  http://docs.oracle.com/cd/B28359_01/install.111/b28264/cvrt2rac.htm


                  Step 1> Invoke DBCA where single instance database is running and create a database template with Structure as well as Data option.

                  Step 2> Move Template files from single Instance server to any one of the RAC node server.

                  Step 3> Invoke DBCA from the node where you copied the template files and create a RAC database using that template.

                  Thanks
                  • 6. Re: Migration to RAC
                    SAML.
                    Hi,

                    I normally do migration using data guard to reduce downtime. Then I will convert to RAC using one of the following methods

                    a) DBCA
                    b) rconfig
                    c) manual add instance

                    Cheers,
                    SAM L.