Sitemap

Amicuk Programming Answers

Oracle 10g RAC - two nodes - change SAN storage - only one node up

-0001-11-30   Views:3

Advertisement

Hi all, We're using Oracle 10g with Linux Red Hat. We want to migrate to another SAN storage. The basic steps are: node 1: 1. presents the volume disk and create partition 2. asmlib create disk newvolume 3. alter diskgroup oradata add disk newdisk 4.

Hi all,
We're using Oracle 10g with Linux Red Hat.
We want to migrate to another SAN storage.
The basic steps are:
node 1:
1. presents the volume disk and create partition
2. asmlib create disk newvolume
3. alter diskgroup oradata add disk newdisk
4. alter diskgroup oradata drop disk OLDDISKOTHERSAN
But THE NODE 2 DOWN.
we want start the NODE 2 only after ALL operations in node 1 finish.
What's you opinion? Any impact?
Can I execute the oracleasm scandisks on node 2 after?
thank you very much!!!!

The replay answer
Advertisement
modify the commands just slightly...
1. presents the volume disk node1 AND node2
2. create partition node1 [if necessary?? ]
3. asmlib create disk newvolume [node1] ## I am not a fan of and have never had to use ASMlib - however, apparently you do...
4. asmlib scandisk... [node2]
[on one of the nodes]
alter diskgroup oradata add disk1 newdisk rebalance power 0
alter diskgroup oradata add disk2 newdisk rebalance power 0
alter diskgroup oradata add disk3 newdisk rebalance power 0
alter diskgroup oradata add disk{n} newdisk rebalance power 0
alter diskgroup oradata drop disk1 OLDDISKOTHERSAN rebalance power 0
alter diskgroup oradata drop disk2 OLDDISKOTHERSAN rebalance power 0
alter diskgroup oradata drop disk3 OLDDISKOTHERSAN rebalance power 0
alter diskgroup oradata drop disk{n} OLDDISKOTHERSAN rebalance power 0
alter diskgroup oradata rebalance power {n}
You can actually do this with BOTH nodes ONLINE. I was involved in moving 250TB from one storage vendor to another - all online - no downtime, no outage.
And before you actually do this and break something - TEST it first!!!

Go to See the other 2 answers

Oracle 10g RAC - two nodes - change SAN storage - only one node up

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, We're using Oracle 10g with Linux Red Hat. We want to migrate to another SAN storage. The basic steps are: node 1: 1. presents the volume disk and create partition 2. asmlib create disk newvolume 3. alter diskgroup oradata add disk newdisk 4.[More]

Oracle 10g RAC Database Migration from SAN to New SAN.

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Our client has implemented a Two Node Oracle 10g R2 RAC on HP-UX v2. The Database is on ASM and on HP EVA 4000 SAN. The database size in around 1.2 TB. Now the requirement is to migrate the Database and Clusterware files to a New SAN (EVA 640[More]

Need to change IP address and host name on a ORACLE 10g RAC setup.

Category:DefaultRelease time:-0001-11-30Views:130

Hi Forum, I have a task to change the IP address, host name and host related details for the ORACLE 10g RAC 2 node setup. So Can anyone tell me the procedure to do the same on both the nodes. Regards Prakashchange IP Address Public + VIP + Interconne[More]

Oracle 10g RAC using ASM - Storage Issue

Category:DefaultRelease time:2015-10-11Views:130

I've an issue related to Oracle 10g RAC. I've 2 node cluster each being Dell 2850 Server with RHEL 4.0 I've EMC CX300 SAN storage with following partitions /orasoft     10 Gb          OCFS2 File system /oracrs          2 Gb          OCFS2 File system[More]

Oracle 10g RAC+ASM - Storage Issue

Category:DefaultRelease time:2015-10-11Views:130

I've an issue related to Oracle 10g RAC. I've 2 node cluster each being Dell 2850 Server with RHEL 4.0 I've EMC CX300 SAN storage with following partitions /orasoft     10 Gb          OCFS2 File system /oracrs          2 Gb          OCFS2 File system[More]

Shared Storage allocation for Oracle 10g RAC

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am about to implement a Two Node Oracle 10g RAC on Windows 2008 (32-Bit) servers. We are going to use EVA4400 storeage and we have 600 GB for Oracle RAC and database. I intend to follow the steps given in RACGuides_Rac10gR2OnWindows.pdf mention[More]

Solaris 10 and Hitachi LUN mapping with Oracle 10g RAC and ASM?

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I am working on an Oracle 10g RAC and ASM installation with Sun E6900 servers attached to a Hitachi SAN for shared storage with Sun Solaris 10 as the server OS. We are using Oracle 10g Release 2 (10.2.0.3) RAC clusterware for the clustering s[More]

Oracle 10g RAC

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am a research student currently struggling to install Oracle 10g RAC on Windows OS.What i understand about a Oracle RAC database system is that it involves a configuration of multiple hosts or servers joined together with a clustering softw[More]

Oracle database not starting up in oracle 10g RAC

Category:DefaultRelease time:2015-10-11Views:130

Hi! Recently I came across one problem with one node oracle 10g RAC.When the Oracle database is started,while opening it is giving ORA-03113:End of file on communication channel error.When I saw the the alert trace file and other trace files I found[More]

Problem with Oracle 10g RAC VIP network setting at Solaris 9

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I have tried to set up a Oracle 10g RAC Release 2. With OS solaris 9, and 2 nodes. The nodes setting as the following: nodes 1: Public address: 172.16.0.121 Private address: 192.168.0.121, 192.168.1.121 (dual path for heart beat) nodes 2: P[More]

Shared Disk Subsystem for Oracle 10g RAC

Category:DefaultRelease time:-0001-11-30Views:130

I am investigating the feasibility of clustering two 220Rs together in an Oracle 10g RAC configuration. Can I use a D1000 disk array for the shared storage between the two nodes? Can you briefly describe how to do it or point me to documentation on h[More]

Hot
Hi All, Problem Statement: Iam unable to generate Pick release report, the shipping lines status is "ready to release" and we have a available quantity for the shipment. Step1 : Create a Order. Step2 : Save and Book the Order. Step3 : Pick Relea [More]
Hello Guys, I am making a report using smartforms. I am successful in showing data  but problem is if if i put a value in parameters that does not exist is database, the smartform runs and related fields shows as empty fields. But the form is running [More]
Dear All, As we know that period wise quantity distribution is possible but can it be editable & can we adjust the quantities manually?Hi DHRUV, The table of CJ20N is not a ALV table, which allow you hide or dispay the selecte column. So if you would [More]
Dear wise friends, I was careless and started dragging photos from my iPhoto Albums folder, which is inside the iPhoto Library folder, which is inside the Pictures folder under my user name on the Hard drive. I didn't notice until after I dragged a c [More]
installed new router. hp1102w  which was previously used with former router now shows "unable to communicate with any wireless router or access point. I have tried installing printer per owners manual, even removed printer, then reinstalled. Nothing. [More]
Hi Guru, I have a ALV program report. It has about 18 columns, but for some strange reason, when we download this report to an ALV the 3rd column which host the material number as the last digit missing/truncated. For example if we have a material nu [More]
I created a funtion with this cursor Cursor C2(c_leasecomp lease.leaseid%Type) is select distinct sorg.orgid department from space_lease sl,spaceorg sorg,org org, (select case when (select 1 from space_lease where UOM_STD_ID = 'METR_MTR' and rownum = [More]
I receive the following error during the install of Xcelsius v 4.5: "Error applying transforms. Verify that the specified transform paths are valid" I don't know what this means. Any help is appreciated. Thank you.Thanks for the response. I'm in [More]
Hi All, I got a seven digit number any number say for example (6581231). Now i need to add even number and odd number separately. Output should be 6 + 8 + 2 = 16 5 + 1 + 3 + 1 = 10 Thanks SAssuming the number is always 7 digits one way to do this wou [More]
Hi, I recently cracked the screen on my 3G iPhone and a have fortunately managed to convince the insurance company to pay for a new one. I'd like to be able to transfer all my contacts, apps aand setting to the new phone. Only problem is I have to gi [More]