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 380241960313 for ; Thu, 12 Dec 2013 22:09:48 +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 22:09:48 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EBB82750A; Thu, 12 Dec 2013 16:09:47 -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 HexzVviKmTLx; Thu, 12 Dec 2013 16:09:47 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DAA5626EE4; Thu, 12 Dec 2013 16:09:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 12 Dec 2013 16:08:24 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79E84228C7 for ; Thu, 12 Dec 2013 16:08:24 -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 VLnJGVmEqtwn for ; Thu, 12 Dec 2013 16:08:24 -0500 (EST) Received: from nm49.bullet.mail.ne1.yahoo.com (nm49.bullet.mail.ne1.yahoo.com [98.138.120.56]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3FC532275F for ; Thu, 12 Dec 2013 16:08:23 -0500 (EST) Received: from [127.0.0.1] by nm49.bullet.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 21:08:23 -0000 Received: from [98.138.100.112] by nm49.bullet.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 21:05:32 -0000 Received: from [98.138.89.172] by tm103.bullet.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 21:05:32 -0000 Received: from [127.0.0.1] by omp1028.mail.ne1.yahoo.com with NNFMP; 12 Dec 2013 21:05:32 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 866122.85208.bm@omp1028.mail.ne1.yahoo.com Received: (qmail 60546 invoked by uid 60001); 12 Dec 2013 21:05:32 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1386882332; bh=ki5DK29zs4H/0UwAFd5STa8T5eXYbmzRb0otbcLUNAw=; 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=Y/EkyDw9z3g9SpBI9jOx1m3a+IvJRk4U5SCsEfVulzLnaDP4MiIa0RcKJFmrz4MthIZVxBFVABgXAsGKLAUKxGc9IPf30jCzrFb7eLi617wv8sOxVs8aRr8Lb7CXJp/P8FCoVVNRe51dqNMkN+N3O/JXRuQytrj8dwhtMLNGL9U= 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=aeISzjIMLjSQGPD3qFDjJDclIZjtUX4uZwcsdd+Ke8trljou6zS0qqC9m2pJqCeoPfLpkHlk8PZPim5ubcAozltzUvjW9vq0XlbECo6n0LBSo+EqsEDP7AaGI/9Q3es+IEfMwhmVwqVAhvWQ2MjEKPnNoEBcnF4OGRyPueQBVTk=; X-YMail-OSG: V8zxh2AVM1lPnSOijwgX.kzLvVxOv8TbEx7KogheF0xGWkh BikXe7EjVdPW.KItlOeHxrRGqDe7k4X_VBOK5osOlKeoM9pNGlp4mVDEO84r 66wjeRW2evejOowLQULOwi2gtAkAvXN1WTLlTwgrBt69SRwuNsHDHDlrWOyD 9ysLzaGw7fYYyqp1lwi_4tWkdwbMo9_mPSpHS1i0LGQ7lB3zG4AYXW7IusUA ADccvpb4Fqi4D9qJmzkgPz9S0KGsEqS5mOVIoSV93KOMvmtNvm4DlCpejRFj eh.REhB7MnSRwJu6oY7.C.6QkL2LpBD_LBY9Rtg9mjZTktGOYBcZeHDpCsJi sdgBKgHHedYohULgUJbej.hPmV_5muJpZZ7cqEiR1eDKzeTuK1LeiXwhrcLo _YwtMI90epYPjEfmaD4LoaEzinc_Y_Rzhf.FjThhL_PYHaEdJlsKUHdHVShK 65EF9yGi1_RkRP5yrSut3qakGXnLc.XRw6JiOtPt4hFmK5_tVgc4PmfFR.yy Cb9W9x0sMJW.1JRqZBewDOvtNLATMtTa7lLhkHcFwW4Pel6fjTbQ8rXYZFxG N24HCXXttrW2ZtrlNs5t.jTCf40Ebt2tvtJEp7Mj7F7jq1iBNCBWR1rvvXuW 1GNiLnxK9wfwYtFYiibO.idl4Pip0ykr78ioIj6xWcxygYtAHWbl3aag7DRE yRWVoxYUGBSzL4474xUw0Zx8wDitG8Marx5Vq6gxQMyQA2weTIXPJDci3Vt6 r.wEPACozDJxn9XMr_r4aDNdSDr5IUdDZniCf2SlfwbMUI7GaZygPRiB7teM RKkST5uAxcYTuC.QSailWPXy9gOR6YUBr7.73e.7fOBf25wOwday3FiBD34C uJ0ihy27jwrSQJiGNEdFhBUSrc59.4q67qVX8URW4rsZT4AdKGH_w01AN.Ot v.2M- Received: from [50.77.68.38] by web122101.mail.ne1.yahoo.com via HTTP; Thu, 12 Dec 2013 13:05:32 PST X-Rocket-MIMEInfo: 002.001,SGFzIGFueW9uZSB0cmllZCB0aGUgcHJvY2VzcyBmb3IgY2xvbmUuc2ggYW5kIGNhbiBzaGFyZSB0aGUgZXhwZXJpZW5jZS4gSSBhbSBhbHNvIHdvcmtpbmcgdG8gY3JlYXRlIDExZyBSMiBSQUMgb24gVkJveCB0byB0cnkgdGhlIHByb2Nlc3MgYmVmb3JlIGRvY3VtZW50IHRoZSBzdGVwcyBhbmQgc28gd2FudCB0byBjaGVjayBpZiBhbnlvbmUgaGFzIHVzZWQgYW5kIGZvdW5kL3NoYXJlIGhpcyBleHBlcmllbmNlLgoKVGhhbmtzClNhbmpheQoKCgpPbiBUaHVyc2RheSwgRGVjZW1iZXIgMTIsIDIwMTMgMzo0NiABMAEBAQE- 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> <1386879639.3441.YahooMailNeo@web122102.mail.ne1.yahoo.com> Message-ID: <1386882332.36335.YahooMailNeo@web122101.mail.ne1.yahoo.com> Date: Thu, 12 Dec 2013 13:05:32 -0800 (PST) From: Sanjay Mishra Subject: Re: Oracle RAC DR test To: "ian@slac.stanford.edu" , "gjilevski@gmail.com" Cc: "Freek.DHooge@uptime.be" , "nassyambasha@gmail.com" , "oracle-l@freelists.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1593584224-556623107-1386882332=:36335" X-archive-position: 51839 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 ---1593584224-556623107-1386882332=:36335 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Has anyone tried the process for clone.sh and can share the experience. I a= m also working to create 11g R2 RAC on VBox to try the process before docum= ent the steps and so want to check if anyone has used and found/share his e= xperience.=0A=0AThanks=0ASanjay=0A=0A=0A=0AOn Thursday, December 12, 2013 3= :46 PM, "MacGregor, Ian A." wrote:=0A =0ADone.=0A= =0APlease submit future requests as an RT ticket.=0A=0AThank you=0A=0AIan= =0A=0A-----Original Message-----=0AFrom: oracle-l-bounce@freelists.org [mai= lto:oracle-l-bounce@freelists.org] On Behalf Of Guenadi Jilevski=0ASent: Th= ursday, December 12, 2013 12:35 PM=0ATo: smishra_97@yahoo.com=0ACc: Freek.D= Hooge@uptime.be; nassyambasha@gmail.com; oracle-l@freelists.org=0ASubject: = Re: Oracle RAC DR test=0A=0AHi,=0A=0A=0AYou can use clone.sh to clone GI an= d RDBMS homes to build a new cluster. After that either restore DB or switc= hover if toy take the path of building a standby database.=0A=0A=0ABest Reg= ards,=0A=0A=0AGuenadi Jilevski=0A=0A=0A=0AOn Thu, Dec 12, 2013 at 10:20 PM,= Sanjay Mishra wrote:=0A=0A=0A=A0=A0=A0 Thanks DHoog= e and Maaz=0A=A0=A0=A0 =0A=A0=A0=A0 =0A=A0=A0=A0 Yes I agree that fresh Ins= tall 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 moreov= er company want to check if there are 18 such RAC environment need to be re= created on DR for any outage, then how long it will take and the process.= =0A=A0=A0=A0 =0A=A0=A0=A0 =0A=A0=A0=A0 Yes it is also true that we need to = run few root based command and want to see if anyone has done such exercise= .=0A=A0=A0=A0 =0A=A0=A0=A0 =0A=A0=A0=A0 Thanks=0A=A0=A0=A0 =0A=A0=A0=A0 San= jay=0A=0A=0A=A0=A0=A0 On Thursday, December 12, 2013 3:05 PM, D'Hooge Freek= wrote:=0A=A0=A0=A0 =0A=A0=A0=A0 Sanjay,=0A=A0=A0= =A0 =0A=A0=A0=A0 With Oracle RAC, the name of the host is deeply embedded i= n the cluster registry.=0A=A0=A0=A0 It is even so, that you can not change = the hostname of a cluster node, you need to drop de node from the cluster, = rename it and add it back again.=0A=A0=A0=A0 =0A=A0=A0=A0 So, I think your = only option is to do a normal install of the GI on your DR servers.=0A=A0= =A0=A0 Of course, this is something you can prepare using silent install sc= ripts if you only want to do the installation at the moment of a DR.=0A=A0= =A0=A0 =0A=A0=A0=A0 =0A=A0=A0=A0 regards,=0A=A0=A0=A0 =0A=A0=A0=A0 =0A-- = =0AFreek D'Hooge=0AUptime=0AOracle Database Administrator=0Aemail: freek.dh= ooge@uptime.be=0Atel +32(03) 451 23 82 = =0A=0Ahttp://www.uptime.be =0Adisclaimer: www.uptim= e.be/disclaimer.html=0A=0A=0A=0A=0A=A0=A0=A0 =0A=A0=A0=A0 On do, 2013-12-12= at 11:06 -0800, Sanjay Mishra wrote: =0A=0A=A0=A0=A0 =A0=A0=A0 Nassyam =0A= =0A=0A=0A=A0=A0=A0 =A0=A0=A0 Create Dataguard from 4node to 2 node is not a= n issue. The main requirement is how to clone Oracle Grid infrastructure us= ing the backup taken for software on Primary site. It is DR exercise where = Database 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 an= d how to create the various configuration files including ASM based ocr/vot= ing disk and other ASM configuration. =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 Once = this is done, Database cloning using Tape restore will not be an issue. Thi= s is one time exercise to check and document the procedure to rebuild the e= nvironment from offshore tape backup =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 TIA = =0A=0A=A0=A0=A0 =A0=A0=A0 Sanjay =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 On Thursda= y, December 12, 2013 1:52 PM, Nassyam Basha wrote:= =0A=A0=A0=A0 =A0=A0=A0 =0A=A0=A0=A0 =A0=A0=A0 =0A=0A=A0=A0=A0 =A0=A0=A0 Hi = Sanjay,=A0 =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 Are you looking for 4-node to 2-= node DR setup?=A0 =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 If so you can refer below= links. I usually refer MAA documents.=A0 =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 h= ttp://www.oracle.com/au/products/database/maa-wp-10g-racprimaryracphysicals= ta-131940.pdf =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 http://www.oracledba.org/11gR= 2/dr/11gR2_dataguard_RAC_to_RAC.html =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 docume= ntsay point to 2-node standby or 3-node, you may need to perform changes on= ly few parameters like FAL_SERVER, LOG_ARCHIVE_CONFIG so on. You will get i= dea if you refer those links.=A0 =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 Documents = 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=0A=A0=A0=A0 =A0=A0=A0= Hope this helps.=A0 =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 But the below question= is confusing still, can you describe more ?=A0 =0A=0A=0A=A0=A0=A0 =A0=A0= =A0 =A0=A0=A0 what are the steps for Grid Infrasturcture cloning? =0A=0A=0A= =0A=A0=A0=A0 =A0=A0=A0 Thank you, =0A=0A=A0=A0=A0 =A0=A0=A0 Nassyam Basha = =0A=A0=A0=A0 =A0=A0=A0 Sent from iPhone =0A=0A=0A=A0=A0=A0 =A0=A0=A0 On Dec= 12, 2013, at 11:48 PM, Sanjay Mishra wrote:=0A=A0= =A0=A0 =A0=A0=A0 =0A=A0=A0=A0 =A0=A0=A0 =0A=A0=A0=A0 =A0=A0=A0 =0A=0A=0A=A0= =A0=A0 =A0=A0=A0 =A0=A0=A0 Hi=A0 =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 = 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 RAC with 8 Da= tabases using ASM based OCR/Voting and Databases on Linux environment. Now = Company wants to perform a DR exercise where backup from Primary Tape will = be used to create the DR environment using only 2nodes. So I appreciate=A0 = if someone share experience in RAC cloning/Setup as what are the steps for = Grid Infrasturcture cloning. =0A=0A=0A=0A=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 TIA = =0A=0A=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 Sanjay =0A=0A=0A=0A=0A=0A=0A=0A--=0Ahtt= p://www.freelists.org/webpage/oracle-l ---1593584224-556623107-1386882332=:36335 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Has anyone tried the process for clone.sh and can share = the experience. I am also working to create 11g R2 RAC on VBox to try the p= rocess before document the steps and so want to check if anyone has used an= d found/share his experience.

Thanks
Sanjay

On Thursday, December 12, 2013 3:46 PM, "MacGregor, Ian A." <ian= @slac.stanford.edu> wrote:
Done.

Please submit future reque= sts as an RT ticket.

Thank you

Ian

----= -Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Guenadi Jile= vski
Sent: Thursday, December 12, 2013 12:35 PM
To: smishra_97@yahoo.com
Cc: Freek.DHooge@uptime.be; nassyambasha@gmail.com= ; oracle-l@freelists.org
= Subject: Re: Oracle RAC DR test

Hi,

You can use clone.sh = to clone GI and RDBMS homes to build a new cluster. After that either resto= re DB or switchover if toy take the path of building a standby database.

Best Regards,


Guenadi Jilevski



On Thu, Dec 12, 2013 at 10:20 PM, Sanjay M= ishra <smishra_97@yahoo.com> wrote:


    Thanks D= Hooge and Maaz
   
&nbs= p;  
    Yes I agree that fresh= Install is better option but the issue is that there are several patches b= een done on various homes and so it need to be documented every time and mo= reover company want to check if there are 18 such RAC environment need to b= e recreated on DR for any outage, then how long it will take and the proces= s.
   
  &nbs= p;
    Yes it is also true that we need t= o run few root based command and want to see if anyone has done such exercise.
 =   
   
 = ;   Thanks
   
    Sanjay


    On Thursday, December 12, 2013 3:05 PM, D'Hoog= e Freek <Freek.DHooge@uptime.be> wrote:   
    S= anjay,
   
  =   With Oracle RAC, the name of the host is deeply embedded in the clus= ter registry.
    It is even so, that you = can not change the hostname of a cluster node, you need to drop de node fro= m the cluster, rename it and add it back again.
 &nb= sp; 
    So, I think your only option is to do a = normal install of the GI on your DR servers.
  =   Of course, this is something you can prepare using silent install sc= ripts if you only want to do the installation at the moment of a DR.
   
   
    regards,
  &nbs= p;
   
--
Freek D'Hooge
Uptime
Oracle Data= base Administrator
email: freek.d= hooge@uptime.be
tel +32(03) 451 23 82 <tel:%2B32%2= 803%29%20451%2023%2082>
<= br clear=3D"none">http://www.uptime.be <http://www.uptime.be/>
disclaimer: www.uptime.be= /disclaimer.html



   
&= nbsp;   On do, 2013-12-12 at 11:06 -0800, Sanjay Mishra wrote:
        N= assyam



        Create Dataguard from 4node= to 2 node is not an issue. The main requirement is how to clone Oracle Gri= d infrastructure using the backup taken for software on Primary site. It is= DR exercise where Database restore is not a challenge as long as Grid infr= astructure is ready. So key challenges are to identify the various script t= o be executed after the Software from one of the node is restored on the DR= exercise server and how to create the various configuration files including ASM based ocr/voting disk= and other ASM configuration.



        Once t= his 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 en= vironment from offshore tape backup

<= br clear=3D"none">
        = TIA

      &n= bsp; Sanjay



        On Thursday, December 12= , 2013 1:52 PM, Nassyam Basha <nassyambasha@gmai= l.com> wrote:
       = ;
       
        Hi Sanjay, 


&n= bsp;       Are you looking for 4-node to 2-node DR= setup? 



        If so you can refer be= low links. I usually refer MAA documents. 



     &= nbsp;  htt= p://www.oracle.com/au/products/database/maa-wp-10g-racprimaryracphysicalsta= -131940.pdf


        http://www.oracledba.org/11gR2/dr/11gR2_dataguard_RAC_to= _RAC.html



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



        Documents you ma= y not get exactly as per your environment, you can refer them and of course= you can modify steps as required. 



      &n= bsp; Hope this helps. 



        But the = below question is confusing still, can you describe more ? 


           = ; what are the steps for Grid Infrasturcture cloning?


    &= nbsp;   Thank you,

 &n= bsp;      Nassyam Basha
  =       Sent from iPhone


        On Dec 12, 2= 013, at 11:48 PM, Sanjay Mishra <smishra_97@yahoo.co= m> wrote:
               
&= nbsp;      

=
            Hi 



     &= nbsp;      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-N= ode Oracle 11g R2 RAC with 8 Databases using ASM based OCR/Voting and Datab= ases on Linux environment. Now Company wants to perform a DR exercise where= backup from Primary Tape will be used to create the DR environment using o= nly 2nodes. So I appreciate  if someone share experience in RAC clonin= g/Setup as what are the steps for Grid Infrasturcture cloning.



  = ;          TIA

            Sanja= y








--=
http://www.freelists.org/webpage/oracle-l




---1593584224-556623107-1386882332=:36335-- -- http://www.freelists.org/webpage/oracle-l