Re: Active DATA GUARD 11g

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Tue, 14 May 2013 20:46:26 +0530
Message-ID: <CAABGLuJF7t8iJ0dpt4Z4NXOpjXm24U_t9tH45_4MbEeUt77eJw_at_mail.gmail.com>

Tiran,
LOG_ARCHIVE_CONFIG refers to the remote destinations, Where you have to mention DB_UNIQUE_NAME of all the database of Data Guard configuraiton.

If you have more than one standby, you need to just add keep on. Example:

LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM_DB_UNIQUE_NAME, STDBY1_DB_UNIQUE_NAME, STDBY2_DB_UNIQUE_NAME)'; Above each value refers to the DB_UNIQUE_NAME of each database. Hope you got it ;)

Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com

On Tue, May 14, 2013 at 8:37 PM, Tiran Harutyunyan <mufc01666_at_gmail.com>wrote:

> Nassyam,
>
> Thanks for answer. You are understand me right. What about
> log_archive_config ? Need I change this also , add second standby name ?
>
>
>
> Stay in touch...
> -------------------
> Tiran Harutyunyan
> Senior Specialist of DB/System administration and Virtualization
> Belgium, Antwerp
> E-mail: mufc01666_at_gmail.com
> LinkedIn: http://www.linkedin.com/in/tiranh
>
>
>
> Tiran,
>
> Question is bit confusing, Please let me know if my assumption is wrong.
> You have enabled ADG on first standby and you want to add extra standby to
> the Data Guard environment? Yes you can add.
>
> In LOG_ARCHIVE_DEST_n parameter, if the number is from 1 to 10, You can
> configure 1 to 10 standby database(s). But for every ADG you must have
> license to use of it.
>
> If am missing your question please describe more. :)
>
> Thanks & Regards,
> Nassyam Basha.
>
>
>
> On Tue, May 14, 2013 at 7:57 PM, Tiran Harutyunyan <mufc01666_at_gmail.com>
> wrote:
> Hi ADG experts,
> I have installed Oracle 11g data guard in our live environment , now I
> think about to add second standby DB, can I do that? I mean is Oracle 11g
> support 2 way replication with Data Guard physical standby ?
>
> >
> > Hardware: IBM Blade center , RAM 36G, CPU Intel Xeon 12 core.
> > OS RHEL 6.3
> > DB: Oracle 11gR2
> >
> > Thanks in advance.
> >
> > Stay in touch...
> > -------------------
> > Tiran Harutyunyan
> > Senior Specialist of System/DB administration and Virtualization
> > Yerevan, Armenia
> > E-mail: mufc01666_at_gmail.com
> >
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Thanks & Regards,
> Nassyam Basha.
>
>

-- 
Thanks & Regards,
Nassyam Basha.


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

Received on Tue May 14 2013 - 17:16:26 CEST