Re: ASM RAC Database from one RAC to another
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 15 May 2009 11:31:25 -0700 (PDT)
Message-ID: <869642.18427.qm_at_web51304.mail.re2.yahoo.com>
Date: Fri, 15 May 2009 11:31:25 -0700 (PDT)
Message-ID: <869642.18427.qm_at_web51304.mail.re2.yahoo.com>
Matt Isn't the same when we have one RAC and one non-RAC instance available on the same RAC node can utilize the same ASM instance and can see the ASM diskgroup. I might be wrong and surely will go as per your advice to check it and working to remove the 2-Node RAC from one of the Test servers and then will create two different one - Node RAC servers. Then I will create the ASM instance on one and will see if I can see the disk on the other Single Node RAC instance. Thanks ________________________________ From: Matthew Zito <mzito_at_gridapp.com> To: smishra_97_at_yahoo.com; oracle-l_at_freelists.org Sent: Friday, May 15, 2009 2:05:00 PM Subject: RE: ASM RAC Database from one RAC to another I would be very leery of having two different clustered ASM databases seeing the same set of ASM disks. It might work, but I’d highly recommend testing that before trying to do this. Alternately, you could do a backup/restore/duplicate process and get new disks on the destination cluster. This would also allow you to separate out the various steps of the migration process to mitigate risk. Thanks, Matt ________________________________ From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Friday, May 15, 2009 2:00 PM To: oracle-l_at_freelists.org Subject: ASM RAC Database from one RAC to another Hi I want to have some insight from somebody who has done the following or has face such situation. I had two different 3-Node RAC in production having 3 Databases instances running in both environment. Now one of the Application Database is taking too much CPU resources in One 3-Node infrastructure and the second 3-Node infrastructure is underutilized. So I am planning to move one of the Database from First 3-Node Rac environment to second 3-Node Rac environment. This way first RAC environment will have only 2 Database and second will have 4 database. Now the question is that if I can stop the database sanjay on First 3-Node Rac environment and mount the ASM lun on the Second 3-Node RAC environment, Are the following Assouptions hold true 1. Stop the Database sanjay on First 3-Node RAC environment 2. using Srvctl , remove it from its cluster resgistry in First environment 3. Make the LUNS used by ASM for sanjay database on Second RAC environment. This can be done even in Advance to make sure it is visible on second Environment 4. using Srvctl, Add Database instance in the Second environment 5. Start the sanjay database in Second environment. Any suggestion or issues in the above setup Thanks Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 15 2009 - 13:31:25 CDT