Re: Needs help in configuring single node active data guard in ASM for 2 node RAC

This blog has the information. Seriously, there are plenty of step by step blogs on how to do this.

https://gemsofprogramming.wordpress.com/2014/03/13/building-a-single-instance-physical-standby-for-a-rac-primary-or-active-dataguard-save-my-daily-data/

On Thu, Feb 16, 2017 at 9:32 AM, Arauz, Gabriel < Gabriel_Arauz_at_dfci.harvard.edu> wrote:

> Hi,
>
>
>
> can you review Document 1475344.1 on oracle support it has step by step
> how to do it
>
>
>
>
>
> Thank you,
> Gabriel Arauz
> Dana Farber Cancer Institute.
> Database Services
> Phone: (617) 632-4037, (617) 650-4645 email: *garauz_at_partners.org*
> <garauz_at_partners.org>
> *"**Be** strong when you are weak, be brave when you are scared, be
> humble when you are victorious**.”* *–* Anonimo - Keep On!!!
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Sandip Mukhopadhyay
> *Sent:* Thursday, February 16, 2017 10:25 AM
> *To:* Andrew Kerber <andrew.kerber_at_gmail.com>
> *Cc:* oracle-l_at_freelists.org; Seth Miller <sethmiller.sm_at_gmail.com>
> *Subject:* Re: Needs help in configuring single node active data guard in
> ASM for 2 node RAC
>
>
>
> Hi ,
>
>
>
> Can anyone please assist .
>
>
>
> Best Regards,
>
> Sandy
>
>
>
> On Thu, Feb 16, 2017 at 8:53 AM, Sandip Mukhopadhyay <
> sandip.mukhopadhyay24_at_gmail.com> wrote:
>
>
>
> On 16-Feb-2017 7:15 AM, "Sandip Mukhopadhyay" <
> sandip.mukhopadhyay24_at_gmail.com> wrote:
>
> Hi All,
>
>
>
> Thanks for your reply,can anyone provide me sample tnsnames.ora files for
> 2 nodes RAC and standby mode, db_name is rac and db_unique name is standby
> in case of standby ,since all the 3 nodes(2 nodes RAC and 1 node standby)
> are in 11.2.0.3 asm ,all the listeners are running from grid home , do I
> need to create a seperate listener for cloning running from node 1 in
> rac(instance names- rac1,rac2), I have seen in the past tthat in
> tnsnames.ora if we are giving scan name it results in failure.What will be
> my log_archive_dest_2 value and fal_server exact value in standby mode
> assuming that my primary net service name for rac instances is rac and
> services name for standby is standby itself.
>
>
>
> These seems to be very basic queries but if anyone can reply it, it will
> be great.
>
>
>
> Thanking you.
>
>
>
> Best Regards,
>
> Sandy
>
>
>
> On 16-Feb-2017 4:33 AM, "Andrew Kerber" <andrew.kerber_at_gmail.com> wrote:
>
> Yes, this is pretty straightforward. Even in RAC, you actually only run
> apply on one node, the others are mounted but not running apply. What
> problems are you having?
>
>
>
> On Wed, Feb 15, 2017 at 4:09 PM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
> Sandy,
>
>
>
> I have done this configuration dozens of times without issue. What
> specifically are your concerns?
>
>
>
>
>
> Seth Miller
>
>
>
> On Wed, Feb 15, 2017 at 1:53 PM, Sandip Mukhopadhyay <
> sandip.mukhopadhyay24_at_gmail.com> wrote:
>
> Hi All,
>
>
>
> I am bit confused to configure single node phsyical active dataguard in
> ASM for my 2 node RAC in 11g r2(11.2.0.3 ) setup. I am planning to use
> rman duplicate from active for standby database but there are some doubts
> regarding tnsnames.ora configuration in both rac nodes and single node
> standby also the value of log_archive_dest_2 and fal_server parameter in
> standby .
>
>
>
>
>
> I searched a lot online but they are not complementing each other
>
>
>
> Any help will be highly appreciated .
>
>
>
> Best Regards,
> Sandy
>
>
>
>
>
>
>
>
>
>
> --
>
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
>
> The information in this e-mail is intended only for the person to whom it
> is
> addressed. If you believe this e-mail was sent to you in error and the
> e-mail
> contains patient information, please contact the Partners Compliance
> HelpLine at
> http://www.partners.org/complianceline . If the e-mail was sent to you in
> error
> but does not contain patient information, please contact the sender and
> properly
> dispose of the e-mail.
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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