Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id C0BD419610EC for ; Thu, 12 Dec 2013 21:25:02 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Thu, 12 Dec 2013 21:25:02 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2904727654; Thu, 12 Dec 2013 15:25:02 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@yahoo.com; dkim-adsp=unknown (insecure policy) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JnKyujwoKnzD; Thu, 12 Dec 2013 15:25:02 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 780E7275F3; Thu, 12 Dec 2013 15:24:20 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 12 Dec 2013 15:23:39 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1167F27506 for ; Thu, 12 Dec 2013 15:23:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id icPUoA5+yXTj for ; Thu, 12 Dec 2013 15:23:39 -0500 (EST) Received: from nm40.bullet.mail.ne1.yahoo.com (nm40.bullet.mail.ne1.yahoo.com [98.138.229.33]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id C7D1B26E7C for ; Thu, 12 Dec 2013 15:23:38 -0500 (EST) Received: from [127.0.0.1] by nm40.bullet.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 20:23:38 -0000 Received: from [98.138.100.113] by nm40.bullet.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 20:20:39 -0000 Received: from [98.138.89.252] by tm104.bullet.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 20:20:39 -0000 Received: from [127.0.0.1] by omp1044.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 20:20:39 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 371866.12847.bm@omp1044.mail.ne1.yahoo.com Received: (qmail 68777 invoked by uid 60001); 12 Dec 2013 20:20:39 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1386879639; bh=WaieDivHAnfhJ+b0TMKsw1bVa/MvctHch2UBrteDau8=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=hrGkwGxWUobqhCHhUsA6LaWwZgbAbZNGOhD8cSN2rt06/yXT6HESRkzEonFx3+KvPFHNcEDuGqrz8q4yS52y1hHR1bGceerDGAR1eWrus4MgSkZSbAaovh1+R+sje0VRklfPK3SqRBeML+a4r6bRi/TiEZR65OUksz1wd4ywABs= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=QUDk1cLyHNKyhoBvZL+u+PykEtU8/8wG+VxgI14OE8brQbrtzteq7ixO1GxCc/Izz+FPS6QJaTqDsalbGtT18roUll3P/w6QpOn8Ks2qoRF56FMi9ZoSYKNNt3FYi+zxNa9xS/dDyAfZLyUkVqD3CxwXR5OXrXNTttQ5WieqXxo=; X-YMail-OSG: FbokuP8VM1mM4hIdO9KkIlyvEfb.fy30c9q7Xke0NSxmfm1 TgJkTegWNAG3jGIFUNQ2CLn4zrIK9kzxN3wXFgZnAnyIY_zuXlN9BP3CWT6x 5nye8DDH8aldNDJjVSG7Z58zUjwFrbfgZPf9YqK2T10gF2ABWKf79I5.tg1g 1PUTsWOD0Fi3BbDUYw_l1jz79ceqJseJlG9pAI0tNxQX7phkBQOBF1.QGA_b 9S_P6X4g46L1mgenm2Jx8OEv3E5cvGCcl77QkYEdYkcp6PcwgvID1lv1K5bo 18uZx8ZTY48__GqOWAv765p.xNSV6Ume60e_7Lutp5HW1fX_fVlARvhx6bK0 6EQsOy5BnMShXnnIDsU3.URjpQZhrLQUeT57XYJEtQqzV67dFMEBR8mQ5g_l Fad2wBcJtmQUGyAyrhbj3zHI79tePjvQYka5m8XTzCeLB28U58R1wwg45eYT fZS3MYNnTWCuXreGm2d.prM2xpk9X3FoaJDGENo.niyWc9c1RoVj7Cakd4mc KKifZ.6pCBAvCNSQvaJW1pDI9b04x2PgqpKXy0uy8zTMkBpyZGqOR5dgZ5q6 iBCIcR8NWLnFdZS23uCNYqzOxEd4UXM0lURbM31lbUp_yddg6n4DpXr5TsJ_ boO5TvkAAbHxRQORsvKniG_tJ6HsRawCuqHpw849bUVghY38rQOnK6paT5v9 3_AuHFD9TWk7tgI_w1eBbu.gNrUdJpH0CJU_qBp2zz5p_CoPfaJLm8_lz3Jw lNwTMwsQk5BJYFUzJtrJeYtgh9cjWXqbZiIJpXWN1xz9CuXVdOCYFPxCQUB_ uAc4fB.6zn1gaGbWzb5Zrbvgn6CmX_WdsYli2.VaSTFxIw3mh4HGWz6V82ga pCwsjTNoTpAYDM5eExvCz5t27 Received: from [50.77.68.38] by web122102.mail.ne1.yahoo.com via HTTP; Thu, 12 Dec 2013 12:20:39 PST X-Rocket-MIMEInfo: 002.001,VGhhbmtzIERIb29nZSBhbmQgTWFhegoKWWVzIEkgYWdyZWUgdGhhdCBmcmVzaCBJbnN0YWxsIGlzIGJldHRlciBvcHRpb24gYnV0IHRoZSBpc3N1ZSBpcyB0aGF0IHRoZXJlIGFyZSBzZXZlcmFsIHBhdGNoZXMgYmVlbiBkb25lIG9uIHZhcmlvdXMgaG9tZXMgYW5kIHNvIGl0IG5lZWQgdG8gYmUgZG9jdW1lbnRlZCBldmVyeSB0aW1lIGFuZCBtb3Jlb3ZlciBjb21wYW55IHdhbnQgdG8gY2hlY2sgaWYgdGhlcmUgYXJlIDE4IHN1Y2ggUkFDIGVudmlyb25tZW50IG5lZWQgdG8gYmUgcmVjcmVhdGVkIG9uIERSIGYBMAEBAQE- References: <1386872339.30389.YahooMailNeo@web122103.mail.ne1.yahoo.com> <31F2D6FE-C557-4F3B-BD08-1AA6F3A999F8@gmail.com> <1386875167.22922.YahooMailNeo@web122106.mail.ne1.yahoo.com> <1386878654.647.143.camel@dhoogfr-lpt1> Message-ID: <1386879639.3441.YahooMailNeo@web122102.mail.ne1.yahoo.com> Date: Thu, 12 Dec 2013 12:20:39 -0800 (PST) From: Sanjay Mishra Subject: Re: Oracle RAC DR test To: "Freek.DHooge@uptime.be" Cc: "nassyambasha@gmail.com" , "oracle-l@freelists.org" In-Reply-To: <1386878654.647.143.camel@dhoogfr-lpt1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="944242502-1524085202-1386879639=:3441" X-archive-position: 51836 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: smishra_97@yahoo.com Precedence: normal Reply-To: smishra_97@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --944242502-1524085202-1386879639=:3441 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thanks DHooge and Maaz=0A=0AYes I agree that fresh Install is better option= but the issue is that there are several patches been done on various homes= and so it need to be documented every time and moreover company want to ch= eck if there are 18 such RAC environment need to be recreated on DR for any= outage, then how long it will take and the process.=0A=0AYes it is also tr= ue that we need to run few root based command and want to see if anyone has= done such exercise.=0A=0AThanks=0ASanjay=0A=0A=0A=0AOn Thursday, December = 12, 2013 3:05 PM, D'Hooge Freek wrote:=0A =0ASanja= y,=0A=0AWith Oracle RAC, the name of the host is deeply embedded in the clu= ster registry.=0AIt is even so, that you can not change the hostname of a c= luster node, you need to drop de node from the cluster, rename it and add i= t back again.=0A=0ASo, I think your only option is to do a normal install o= f the GI on your DR servers.=0AOf course, this is something you can prepare= using silent install scripts if you only want to do the installation at th= e moment of a DR.=0A=0A=0Aregards,=0A=0A=0A-- =0AFreek D'Hooge=0AUptime=0AO= racle Database Administrator=0Aemail: freek.dhooge@uptime.be=0Atel +32(03) = 451 23 82=0Ahttp://www.uptime.be=0Adisclaimer: www.uptime.be/disclaimer.htm= l=0A=0A=0A=0A=0A =0AOn do, 2013-12-12 at 11:06 -0800, Sanjay Mishra wrote: = =0ANassyam =0A=0A>=0A>=0ACreate Dataguard from 4node to 2 node is not an is= sue. The main requirement is how to clone Oracle Grid infrastructure using = the backup taken for software on Primary site. It is DR exercise where Data= base restore is not a challenge as long as Grid infrastructure is ready. So= key challenges are to identify the various script to be executed after the= Software from one of the node is restored on the DR exercise server and ho= w to create the various configuration files including ASM based ocr/voting = disk and other ASM configuration. =0A=0A>=0A>=0AOnce this is done, Database= cloning using Tape restore will not be an issue. This is one time exercise= to check and document the procedure to rebuild the environment from offsho= re tape backup =0A=0A>=0A>=0ATIA =0ASanjay =0A=0A>=0A>=0AOn Thursday, Decem= ber 12, 2013 1:52 PM, Nassyam Basha wrote:=0A>=0A>= =0AHi Sanjay,=A0 =0A=0A>=0A>=0AAre you looking for 4-node to 2-node DR setu= p?=A0 =0A=0A>=0A>=0AIf so you can refer below links. I usually refer MAA do= cuments.=A0 =0A=0A>=0A>=0Ahttp://www.oracle.com/au/products/database/maa-wp= -10g-racprimaryracphysicalsta-131940.pdf =0A=0A>=0A>=0Ahttp://www.oracledba= .org/11gR2/dr/11gR2_dataguard_RAC_to_RAC.html =0A=0A>=0A>=0Adocumentsay poi= nt to 2-node standby or 3-node, you may need to perform changes only few pa= rameters like FAL_SERVER, LOG_ARCHIVE_CONFIG so on. You will get idea if yo= u refer those links.=A0 =0A=0A>=0A>=0ADocuments you may not get exactly as = per your environment, you can refer them and of course you can modify steps= as required.=A0 =0A=0A>=0A>=0AHope this helps.=A0 =0A=0A>=0A>=0ABut the be= low question is confusing still, can you describe more ?=A0 =0A=0A>=0Awhat = are the steps for Grid Infrasturcture cloning? =0A=0A>=0A>=0AThank you, =0A= Nassyam Basha=A0=0A>Sent from iPhone =0A=0A>On Dec 12, 2013, at 11:48 PM, S= anjay Mishra wrote:=0A>=0A>=0A>=0A=0A>=0AHi=A0 =0A= =0A>>=0A>>=0ACan anyone share the doc/reference for doing DR exercise for 4= -node Primary RAC (11g R2) on 2-node DR RAC ? We have 4-Node Oracle 11g R2 = RAC with 8 Databases using ASM based OCR/Voting and Databases on Linux envi= ronment. Now Company wants to perform a DR exercise where backup from Prima= ry Tape will be used to create the DR environment using only 2nodes. So I a= ppreciate =A0if someone share experience in RAC cloning/Setup as what are t= he steps for Grid Infrasturcture cloning. =0A=0A>>=0A>>=0ATIA =0ASanjay =0A= =0A>=0A>=0A> --944242502-1524085202-1386879639=:3441 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Thanks DHooge and Maaz

Yes I agree that fresh Install is better o= ption but the issue is that there are several patches been done on various = homes and so it need to be documented every time and moreover company want = to check if there are 18 such RAC environment need to be recreated on DR fo= r any outage, then how long it will take and the process.

Yes it is also true that we nee= d to run few root based command and want to see if anyone has done such exe= rcise.
Thanks
Sanjay


On Thursday, December 12, 2013 3:05 PM, D'Hooge Fr= eek <Freek.DHooge@uptime.be> wrote:
=0ASanjay,
=0A
=0AWith Oracle RAC, the name of the host is deeply= embedded in the cluster registry.
=0AIt is even so, that= you can not change the hostname of a cluster node, you need to drop de nod= e from the cluster, rename it and add it back again.
=0A<= br clear=3D"none">=0ASo, I think your only option is to do a normal install= of the GI on your DR servers.
=0AOf course, this is some= thing you can prepare using silent install scripts if you only want to do t= he installation at the moment of a DR.
=0A
=0A
=0Aregards,
=0A
=0A=
--
=0AFreek D'Hooge
=0AUptime
=0AOracle Database Administrator<= br clear=3D"none">=0Aemail: freek.dhooge@uptime.be
=0Atel +32(03) 451= 23 82
=0Ahttp://www.uptime.be
=0Adisclaimer: www.uptime.be/disclaimer.html
=0A
=0A
=0A
=0A
=0A
=0AOn do, 20= 13-12-12 at 11:06 -0800, Sanjay Mishra wrote:=0A
N= assyam
=0A

=0A
=0A
=0A
Create Datagu= ard from 4node to 2 node is not an issue. The main requirement is how to cl= one Oracle Grid infrastructure using the backup taken for software on Prima= ry site. It is DR exercise where Database restore is not a challenge as=0A = long as Grid infrastructure is ready. So key challenges are to identify the= various script to be executed after the Software from one of the node is r= estored on the DR exercise server and how to create the various configurati= on files including ASM based ocr/voting=0A disk and other ASM configuration= .
=0A

=0A
=0A
=0A
Once this is done, D= atabase cloning using Tape restore will not be an issue. This is one time e= xercise to check and document the procedure to rebuild the environment from= offshore tape backup=0A
=0A

=0A
=0A
=0A
TIA
=0A
Sanjay
=0A
=0A
=0A=0A
On Thursday, December 12,= 2013 1:52 PM, Nassyam Basha <nassyambasha@gmail.com> wrote:=0A
=0A
=0A
Hi Sanjay, 
=0A

=0A
=0A
=0A
Are you looking for 4-node to 2-node DR setup? 
=0A<= blockquote type=3D"CITE">
=0A
=0A=0A
If so you can refer below links. I usua= lly refer MAA documents. =0A
=0A
=
=0A
=0A
=0A
http://www.oracle.com/au/products/database/maa-wp-10g-racprima= ryracphysicalsta-131940.pdf=0A
=0A

=0A
=0A
=0A
http://www.oracledba.org/11gR2/dr/11gR2_dataguard_RAC_to_RAC.ht= ml=0A
=0A

=0A
=0A
=0A
documentsay point= to 2-node standby or 3-node, you may need to perform changes only few para= meters like FAL_SERVER, LOG_ARCHIVE_CONFIG so on. You will get idea if you = refer those links. =0A
=0A

=0A
=0A
=0A
Documents you may not get exactly as per your environment, you can ref= er them and of course you can modify steps as required. =0A=0A

=0A
=0A=
=0A
Hope this helps.  =0A

=0A
= =0A
=0A
But the below question is conf= using still, can you describe more ? =0A
=0A

=0A
=0A
=0A
what are the steps for Grid Infrasturcture cl= oning?
=0A
=0A

=0A
=0A
=0A
Thank you,
=0A
Nassyam Basha <= br clear=3D"none">=0ASent from iPhone
=0A

=0AOn Dec 12, 2013, at 11:48 PM, Sanjay Mishra <= smishra_97@yahoo.com> wrote:
=0A
=0A=
=0A
=0A

=0A
=0A
=0A
Hi 
=0A
=0A
=0A

=0A
=0A=
=0A
=0A
=0A
Can anyone share the doc/reference for doing DR exercise for 4-= node Primary RAC (11g R2) on 2-node DR RAC ? We have 4-Node Oracle 11g R2 R= AC with 8 Databases using ASM based OCR/Voting and Databases on Linux envir= onment. Now Company=0A wants to perform a DR exercise where backup from Pri= mary Tape will be used to create the DR environment using only 2nodes. So I= appreciate  if someone share experience in RAC cloning/Setup as what = are the steps for Grid Infrasturcture cloning.=0A
=0A=0A
=0A

=0A
=0A
=0A
=0A
=0A
TIA
=0A
= =0A
=0A
Sanjay =0A
=0A

=0A
=0A
=0A
=0A

--944242502-1524085202-1386879639=:3441-- -- http://www.freelists.org/webpage/oracle-l