Re: ASM RAC Database from one RAC to another

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-l